¡¾¸´Ï°¡¿SQL ÄÚ£¬Í⣬×ó£¬ÓÒÁ¬½Ó
ÐÅÏ¢±í(infor)¹¤×ʱí(pay)
ÄÚÁ¬½Ó
select pay.name,infor.AGE,PAY.MONEY,infor.email from pay join infor on infor.name=PAY.name
×óÍâÁ¬½Ó
select pay.name,infor.AGE,PAY.MONEY,infor.email from pay left join infor on infor.name=PAY.name
PS£º½á¹ûÓÐÍõÎ壬¹¤×ÊΪ0
ÓÒÍâÁ¬½Ó
select pay.name,infor.AGE,PAY.MONEY,infor.email from pay right join infor on infor.name=PAY.name
È«ÍâÁ¬½Ó
select pay.name,infor.AGE,PAY.MONEY,infor.email from pay full join infor on infor.name=PAY.name
Ïà¹ØÎĵµ£º
²»ÖªµÀÕâÑùµÄÒªÇóÄܲ»ÄÜʵÏÖ£¿
±ÈÈçÎÒÓÐÒ»ÕűíT1£¬ÀïÃæÖ»ÓÐÒ»¸ö×Ö¶Î1
ÀïÃæÓÐ100Ìõ¼Ç¼£¬ÈçÏÂËùʾ£º
×Ö¶Î1
A1
A2
A3
A4
...
A100
ÎÒÏëÓÃÒ»ÌõSQLÏÔʾÕâÑùµÄ½á¹û
µÚÒ»ÁÐ µÚ¶þÁÐ ... µÚÊ®ÁÐ
A1 A11 &nb ......
SQL Server×Ö·û´®´¦Àíº¯Êý´óÈ«
selectÓï¾äÖÐÖ»ÄÜʹÓÃsqlº¯Êý¶Ô×ֶνøÐвÙ×÷£¨Á´½Ósql server£©£¬
select ×Ö¶Î1 from ±í1 where ×Ö¶Î1.IndexOf("ÔÆ")=1;
ÕâÌõÓï¾ä²»¶ÔµÄÔÒòÊÇindexof£¨£©º¯Êý²»ÊÇsqlº¯Êý£¬¸Ä³Ésql¶ÔÓ¦µÄº¯Êý¾Í¿ÉÒÔÁË¡£
left£¨£©ÊÇsqlº¯Êý¡£
select ×Ö¶Î1 from ±í1 where charindex£¨'Ô ......
¡¡¡¡Ïò±íÖÐÔö¼ÓÒ»¸ö varchar ÁУº
¡¡¡¡ALTER TABLE distributors ADD COLUMN address varchar(30);
¡¡¡¡´Ó±íÖÐɾ³ýÒ»¸ö×ֶΣº
¡¡¡¡ALTER TABLE distributors DROP COLUMN address RESTRICT;
¡¡¡¡ÔÚÒ»¸ö²Ù×÷ÖÐÐÞ¸ÄÁ½¸öÏÖÓÐ×ֶεÄÀàÐÍ£º
¡¡¡¡ALTER TABLE distributors
¡¡¡¡ALTER COLUMN address TYPE varchar(80),
......
ʹÓà TRUNCATE TABLE ɾ³ýËùÓÐÐÐ
ÈôҪɾ³ý±íÖеÄËùÓÐÐУ¬Ôò TRUNCATE TABLE Óï¾äÊÇÒ»ÖÖ¿ìËÙ¡¢ÓÐЧµÄ·½·¨¡£TRUNCATE TABLE Óë²»º¬ WHERE ×Ó¾äµÄ DELETE Óï¾äÀàËÆ¡£µ«ÊÇ£¬TRUNCATE TABLE Ëٶȸü¿ì£¬²¢ÇÒʹÓøüÉÙµÄϵͳ×ÊÔ´ºÍÊÂÎñÈÕÖ¾×ÊÔ´¡£
Óë DELETE Óï¾äÏàͬ£¬Ê¹Óà TRUNCATE TABLE Çå¿ÕµÄ±íµÄ¶¨ÒåÓëÆäË÷ÒýºÍÆäËû¹ØÁª¶ÔÏóÒ ......