sql Óï¾ä×ܽá
mysql : ½«Ò»¸ö±íµÄÊý¾Ý²åÈëµ½newT ÖÐ
£¨newT ±íÐë´æÔÚ£¬ÇҽṹÓëselect Óï¾ä¶ÔÓ¦µÄ½á¹¹Í¬ £¬×îºÃ²»ÓÃ* ¶øÊǾßÌå×ֶΣ©
insert into newT select * from t1 where ...
Ò²¿ÉÒÔcreate table newT select f1,f2 from t1; (select into µÄÌæ´ú·½·¨£¬mysql ²»Ö§³Öselect into )
MySQL²»Ö§³ÖSelect Into
database table µÄ±¸·Ý
mysqldump -uroot -proot -h192.101.111.111 databaseName [tableName] >a.sql
Éú³É±í½á¹¹¼°ÀïÃæµÄËùÓÐÊý¾Ý
£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½
¿ÉÒÔÓÃÏÂÁÐÓï¾ä
source a.sql ÖØÐµ¼Èë
µ±È»µ¼Èë֮ǰ¿ÉÒÔÐÞ¸Äa.sql ÀïµÄÄÚÈÝ£¬Èç±íÃû£¬Èç´Ë¿ÉʵÏÖ±¸·Ý
½«Êý¾Ý±¸·Ý£¬£¨²»Êǵ¼³ösql Óï¾ä£¬¶øÖ»µ¼³ö ÆäÖÐ µÄÊý¾Ý£©
select * into outfile 'c:\out.txt' from tableName where ...;
¶ÔÓ¦µÄµ¼È룺
load data local infile 'c:\out.txt' into table positiondata fileds terminated by ';' (userid ,username );
Ïà¹ØÎĵµ£º
²éÑ¯ÖØ¸´Öµ£¬ÏÔʾ³ö²»Öظ´µÄ²¿·Ö
select distinct(employeeid) from orders
²éѯÁ½¸ö±íÖ®¼äÏàͬÊý¾Ý
select orders.EmployeeID,Employees.EmployeeID
from orders INNER JOIN Employees
on Employees.EmployeeID=orders.EmployeeID
ʵÏÖÄ¿µÄ£¬Ò»¸ö±í´æ·ÅÓû§±àºÅºÍÓû§Ãû£¬ÔÚÁíÒ»¸ö±íÖпÉÒÔ¸ù¾ÝÓû§±àº ......
Ò²ÊÇSQL Server 2005´øÀ´µÄÐÂÌØÐÔ£¬²¿·Ö±¸·Ý£¨partial backup£©×Ô¶¯´´½¨Êý¾Ý¿âÖÐÖ÷Îļþ×éºÍËùÓ줻î¶Áд¹¦ÄܵÄÎļþ×éµÄ±¸·Ý¡£Èç¹û±¸·Ý´æÔÚÖ»¶ÁÎļþ×éµÄÊý¾Ý¿â£¬²¿·Ö±¸·Ý½«Ö»¶ÔÖ÷Îļþ×é½øÐб¸·Ý¡£Õâ¸öÑ¡Ïî¶ÔÓÚÄÇЩ´æÔÚÖ»¶ÁÎļþ×éµÄ³¬´óÐÍÊý¾Ý¿âÊÇÀíÏëµÄ£¬Ëü²»ÐèÒªÏñÄÇЩ¿ÉдµÄÎļþ×鱸·ÝµÃÄÇôƵ·±¡£
³ýÁËÐèÒªÖ¸¶¨READ_WRIT ......
ÈçºÎÈ·¶¨ËùÔËÐÐµÄ SQL Server 2005 µÄ°æ±¾
Ҫȷ¶¨ËùÔËÐÐµÄ SQL Server 2005 µÄ°æ±¾£¬ÇëʹÓà SQL Server Management Studio Á¬½Óµ½ SQL Server 2005£¬È»ºóÔËÐÐÒÔÏ Transact-SQL Óï¾ä£º
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
ÔËÐнá¹ûÈçÏ£º
²úÆ·° ......
ÓαêµÄÀàÐÍ£º
1¡¢¾²Ì¬Óαê(²»¼ì²âÊý¾ÝÐеı仯£©
2¡¢¶¯Ì¬Óα꣨·´Ó³ËùÓÐÊý¾ÝÐеĸı䣩
3¡¢½öÏòǰÓα꣨²»Ö§³Ö¹ö¶¯£©
4¡¢¼ü¼¯Óα꣨ÄÜ·´Ó³Ð޸쬵«²»ÄÜ׼ȷ·´Ó³²åÈ롢ɾ³ý£©
ÓαêʹÓÃ˳Ðò£º
1¡¢¶¨ÒåÓαê
2¡¢´ò¿ªÓαê
3¡¢Ê¹ÓÃÓαê
  ......
µ±ÔÚÄÚÁ¬½Ó²éѯÖмÓÈëÌõ¼þʱ£¬ÎÞÂÛÊǽ«Ëü¼ÓÈëµ½join×Ӿ䣬»¹ÊǼÓÈëµ½where×Ӿ䣬ÆäЧ¹ûÊÇÍêȫһÑùµÄ£¬µ«¶ÔÓÚÍâÁ¬½ÓÇé¿ö¾Í²»Í¬ÁË¡£µ±°ÑÌõ¼þ¼ÓÈëµ½ join×Ó¾äʱ£¬»á·µ»ØÍâÁ¬½Ó±íµÄÈ«²¿ÐУ¬È»ºóʹÓÃÖ¸¶¨µÄÌõ¼þ·µ»ØµÚ¶þ¸ö±íµÄÐС£Èç¹û½«Ìõ¼þ·Åµ½where×Ó¾äÖУ¬½«»áÊ×ÏȽøÐÐÁ¬½Ó²Ù×÷£¬È»ºóʹÓÃwhere×Ó¾ä¶ÔÁ¬½ÓºóµÄÐнøÐÐɸѡ¡ ......