SQL¼ò½é
OracleϵÁУºSQL
Ò»£¬Ê²Ã´ÊÇSQL£¿
1£¬SQLÈ«³ÆÊÇ“½á¹¹»¯²éѯÓïÑÔ(Structured Query Language)”£¬¹ØϵÊý¾Ý¿â¹ÜÀíϵͳµÄÒ»ÖÖ²éѯÓïÑÔ¡£
2£¬SQLÊǸ߼¶µÄ·Ç¹ý³Ì»¯±à³ÌÓïÑÔ£¬¾ßÓÐÍêÈ«²»Í¬µ×²ã½á¹¹µÄ²»Í¬Êý¾Ý¿âϵͳ¿ÉÒÔʹÓÃÏàͬµÄSQLÓïÑÔ×÷ΪÊý¾ÝÊäÈëÓë¹ÜÀíµÄ½Ó¿Ú¡£
3£¬ÒԼǼ¼¯ºÏ×÷Ϊ²Ù×ݶÔÏó£¬ËùÓÐSQLÓï¾ä½ÓÊܼ¯ºÏ×÷ΪÊäÈ룬·µ»Ø¼¯ºÏ×÷ΪÊä³ö£¬
ÕâÖÖ¼¯ºÏÌØÐÔÔÊÐíÒ»ÌõSQLÓï¾äµÄÊä³ö×÷ΪÁíÒ»ÌõSQLÓï¾äµÄÊäÈ룬ËùÒÔSQLÓïÑÔ¿ÉÒÔǶÌס£
4£¬SQLͬʱҲÊÇÊý¾Ý¿âÎļþ¸ñʽµÄÀ©Õ¹Ãû¡£
5£¬SQLÓïÑÔ°üº¬4¸ö²¿·Ö£º
Êý¾Ý¶¨ÒåÓïÑÔ£¨DDL£©£º£¨ÈçCREATE, DROP,ALTERµÈÓï¾ä£©
Êý¾Ý²Ù×ÝÓïÑÔ(DML): £¨SELECT£¬INSERT, UPDATE, DELETEÓï¾ä£©
Êý¾Ý¿ØÖÆÓïÑÔ£¨DCL£©: £¨ÈçGRANT,REVOKE,COMMIT, ROLLBACKµÈÓï¾ä£©
ÊÂÎñ¿ØÖÆÓïÑÔ
À´Ô´£ºhttp://baike.baidu.com/view/34.htm
¶þ£¬Êý¾Ý¶¨ÒåÓïÑÔ£¨DDL£©
ÓÃÀ´´´½¨¡¢ÊµÏֺ͹ÜÀíÊý¾Ý¿â½á¹¹¡£
Create(´´½¨)£¬ Alter (ÐÞ¸Ä)£¬ Drop(ɾ³ý)ÃüÁî
Èý£¬Êý¾Ý¿â²Ù×÷ÓïÑÔ(DML)
ÓÃÓÚ¼ìË÷£¬²åÈëºÍÐÞ¸ÄÊý¾Ý¿âÐÅÏ¢¡£
Select(²éѯ)£¬Insert(²åÈë)£¬Update(¸üÐÂ)£¬Delete(ɾ³ý)
ËÄ£¬Êý¾Ý¿ØÖÆÓïÑÔ£¨DCL£©
ÓÃÓÚÊý¾Ý¿â·ÃÎʺͲÙ×÷ȨÏ޵ĹÜÀí¡£
Grant(ÊÚÓè)£¬Revoke£¨ÒƳý£©
Î壬ÊÂÎñ¿ØÖÆÓïÑÔ
ÊÂÎñÊǵ¥¸öµÄ¹¤×÷µ¥Ôª¡£
Èç¹ûijһÊÂÎñ³É¹¦£¬ÔòÔÚ¸ÃÊÂÎñÖнøÐеÄËùÓÐÊý¾ÝÐ޸ľù»áÌá½»£¬³ÉΪÊý¾Ý¿âÖеÄÓÀ¾Ã×é³É²¿·Ö¡£
Èç¹ûÊÂÎñÓöµ½´íÎóÇÒ±ØÐëÈ¡Ïû»ò»Ø¹ö£¬ÔòËùÓÐÊý¾ÝÐ޸ľù±»Çå³ý
Commit(Ìá½»)£¬SavePoint(±£´æµã)£¬RollBack(»Ø¹ö)
Áù£¬SQL²Ù×÷·û
ËãÊõ²Ù×÷·û£ºÖ´Ðлù±¾ÊýÖµ¼ÆËã¡£
Á¬½Ó²Ù×÷·û£ºÁ¬½Ó×Ö·û´®¡£
±È½Ï²Ù×÷·û£º±È½Ï¶þ¸ö±í´ïʽµÄÖµ¡£
Âß¼²Ù×÷·û£º×éºÏ¶à¸ö±È½ÏÔËËãµÄ½á¹ûÉú³ÉÒ»¸öÂß¼Öµ¡£
¼¯ºÏ²Ù×÷·û£º½«¶þ¸ö²éѯµÄ½á¹û×éºÏΪһ¸ö½á¹û¼¯
Æߣ¬SQLº¯Êý
SQLº¯Êý¿ÉÒÔ·ÖΪ£º±êÁ¿º¯Êý£¬¾ÛºÏº¯Êý£¬·ÖÎöº¯Êý
±êÁ¿º¯Êý·ÖÀࣺ
×Ö·ûº¯Êý
ÈÕÆÚº¯Êý
Êý×Öº¯Êý
ת»»º¯Êý
ÆäËûº¯Êý
¾ÛºÏº¯Êý£º
AVG
MIN
MAX
SUM
COUNT
Group By ×Ó¾ä
Having×Ó¾ä
·ÖÎöº¯Êý£ºSelectÁÐ
Ïà¹ØÎĵµ£º
character-set-server = GB2312
collation-server = latin1_general_ci
MySQL×Ö·û¼¯ GBK¡¢GB2312¡¢UTF8Çø±ð ½â¾ö MYSQLÖÐÎÄÂÒÂëÎÊÌâ ÊÕ²Ø
MySQLÖÐÉæ¼°µÄ¼¸¸ö×Ö·û¼¯
character-set-server/default-character-set£º·þÎñÆ÷×Ö·û¼¯£¬Ä¬ÈÏÇé¿öÏÂËù²ÉÓõġ£
character-set-database£ºÊý¾Ý¿â×Ö·û¼¯¡£
character-set-table£ºÊ ......
1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......
declare @str varchar(8000),@sql varchar(8000)
set @str=''
select @str=@str+','+name from syscolumns WHERE ID=OBJECT_ID('±íÃû') AND NAME!='ÒªÅųýµÄÁÐÃû'
set @str=stuff(@str,1,1,'')
set @sql='select '+@str+' from ±íÃû'
exec (@sql) ......
1¡¢SQLÂß¼²éѯ´¦ÀíÖеĸ÷¸ö½×¼¶Ë³Ðò
(8)SELECT (9) DISTINCT (11) <tOP_Specification> <select list>
(1)from¡¡£¼Left tables£¾
(3)<Join type>Join<Right_table>
&n ......