¡¶£Ó£Ñ£Ì Óï·¨²Î¿¼ÊÖ²á(SQL)¡·
£Ó£Ñ£Ì Óï·¨²Î¿¼ÊÖ²á(SQL)/Êý¾ÝÀàÐÍ
DB2 ÌṩÁ˹ØÁ¬Ê½×ÊÁÏ¿âµÄ²éѯÓïÑÔ £Ó£Ñ£Ì (Structured Query Language)£¬ÊÇÒ»Öַdz£¿ÚÓﻯ¡¢¼ÈÒ×ѧÓÖÒ×¶®µÄÓï·¨¡£´ËÒ»ÓïÑÔ¼¸ºõÊÇÿ¸ö×ÊÁÏ¿âϵͳ¶¼±ØÐëÌṩµÄ£¬ÓÃÒÔ±íʾ¹ØÁ¬Ê½µÄ*×÷£¬°üº¬ÁË×ÊÁϵ͍Ò壨£Ä£Ä£Ì£©ÒÔ¼°×ÊÁϵĴ¦Àí£¨£Ä£Í£Ì£©¡£SQLÔÀ´Æ´³ÉSEQUEL£¬ÕâÓïÑÔµÄÔÐÍÒԓϵͳ R“µÄÃû×ÖÔÚ IBM Ê¥ºÉÎ÷ʵÑéÊÒÍê³É£¬¾¹ýIBMÄÚ²¿¼°ÆäËûµÄÐí¶àʹÓÃÐÔ¼°Ð§ÂʲâÊÔ£¬Æä½á¹ûÏ൱ÁîÈËÂúÒ⣬²¢¾ö¶¨ÔÚϵͳR µÄ¼¼Êõ»ù´¡·¢Õ¹³öÀ´ IBM µÄ²úÆ·¡£¶øÇÒÃÀ¹ú¹ú¼Ò±ê׼ѧ»á£¨ANSI£©¼°¹ú¼Ê±ê×¼»¯×éÖ¯£¨ISO£©ÔÚ1987×ñÑÒ»¸ö¼¸ºõÊÇÒÔ IBM SQL Ϊ»ù´¡µÄ±ê×¼¹ØÁ¬Ê½×ÊÁÏÓïÑÔ¶¨Òå¡£
Ò»¡¢×ÊÁ϶¨Òå £Ä£Ä£Ì£¨Data Definition Language)
×ÊÁ϶¨ÓïÑÔÊÇÖ¸¶Ô×ÊÁϵĸñʽºÍÐÎ̬϶¨ÒåµÄÓïÑÔ£¬ËûÊÇÿ¸ö×ÊÁÏ¿âÒª½¨Á¢Ê±ºòʱÊ×ÏÈÒªÃæ¶ÔµÄ£¬¾Ù·²×ÊÁÏ·ÖÄÄЩ±í¸ñ¹ØÏµ¡¢±í¸ñÄÚµÄÓÐʲ÷áÀ¸Î»Ö÷¼ü¡¢±í¸ñºÍ±í¸ñÖ®¼ä»¥Ïà²Î¿¼µÄ¹ØÏµµÈµÈ£¬¶¼ÊÇÔÚ¿ªÊ¼µÄʱºòËù±ØÐë¹æ»®ºÃµÄ¡£
£±¡¢½¨±í¸ñ£º
Create TABLE table_name(
column1 DATATYPE [NOT NULL] [NOT NULL PRIMARY KEY],
column2 DATATYPE [NOT NULL],
...£©
˵Ã÷£º¡¡
DATATYPE --ÊÇ×ÊÁϵĸñʽ£¬Ïê¼û±í¡£
NUT NULL --¿É²»¿ÉÒÔÔÊÐí×ÊÁÏÓпյģ¨ÉÐδÓÐ×ÊÁÏÌîÈ룩¡£
PRIMARY KEY --ÊDZ¾±íµÄÖ÷¼ü¡£
£²¡¢¸ü¸Ä±í¸ñ¡¡
Alter TABLE table_name
ADD COLUMN column_name DATATYPE
˵Ã÷£ºÔö¼ÓÒ»¸öÀ¸Î»£¨Ã»ÓÐɾ³ýij¸öÀ¸Î»µÄÓï·¨¡£
Alter TABLE table_name
ADD PRIMARY KEY (column_name)
˵Ã÷£º¸ü¸Ä±íµÃµÄ¶¨Òå°Ñij¸öÀ¸Î»ÉèΪÖ÷¼ü¡£
Alter TABLE table_name
Drop PRIMARY KEY (column_name)
˵Ã÷£º°ÑÖ÷¼üµÄ¶¨Òåɾ³ý¡£
£³¡¢½¨Á¢Ë÷Òý¡¡
Create INDEX index_name ON table_name (column_name)
˵Ã÷£º¶Ôij¸ö±í¸ñµÄÀ¸Î»½¨Á¢Ë÷ÒýÒÔÔö¼Ó²éѯʱµÄËÙ¶È¡£
£´¡¢É¾³ý¡¡
Drop table_name
Drop 
Ïà¹ØÎĵµ£º
ÈçºÎ²é¿´SQL Server²¹¶¡°æ±¾ [http://www.cnblogs.com/yitian/articles/1285021.html]
1¡¢ÓÃIsql»òÕßSQL²éѯ·ÖÎöÆ÷µÇ¼µ½SQL Server£¬Èç¹ûÊÇÓÃIsql£¬ÇëÔÚcmd´°¿ÚÊäÈëisql -U sa,È»ºóÊäÈëÃÜÂ룬½øÈ룻Èç¹ûÊÇÓÃSQL²éѯ·ÖÎöÆ÷£¬Çë´Ó³ÌÐòÖÐÆô¶¯£¬ÊäÈësaºÍÃÜÂ루Ҳ¿ÉÒÔÓÃwindowsÑéÖ¤£©¡£
2¡¢ÔÚISQLÖÐÊäÈ ......
ÄÜ¼à¿ØSQL ServerÊý¾Ý¿âÔËÐеÄÇé¿ö£¬¶Ô·þÎñÆ÷À´Ëµ¶¼ÊÇÒ»¼þ·Ç³£ÖØÒªµÄÊ£¬ÏÂÃæ¿ªÊ¼½éÉÜ¡£
Microsoft SQL Server 2005 ÌṩÁËһЩ¹¤¾ßÀ´¼à¿ØÊý¾Ý¿â¡£·½·¨Ö®Ò»ÊǶ¯Ì¬¹ÜÀíÊÓͼ¡£¶¯Ì¬¹ÜÀíÊÓͼ (DMV) ºÍ¶¯Ì¬¹ÜÀíº¯Êý (DMF) ·µ»ØµÄ·þÎñÆ÷״̬ÐÅÏ¢¿ÉÓÃÓÚ¼à¿Ø·þÎñÆ÷ʵÀýµÄÔËÐÐ×´¿ö¡¢Õï¶ÏÎÊÌâºÍÓÅ»¯ÐÔÄÜ¡£
³£¹æ·þÎñÆ÷¶¯Ì¬¹ÜÀí¶ÔÏó°ü ......
ÒªÇ󣺲éѯÿ¸öÀÏʦËù´ø±ÏÒµÉè¼ÆµÄ»ã×ÜÇé¿ö£¬±ÏÒµÉè¼ÆÑ§Éú·Ö±¾¿Æ¡¢×¨¿Æ£¬ÔºÍâ¡¢ÔºÄÚ£¬ÒªÇóµÃµ½µÄ½á¹ûÐÎʽÈçÏ£º
½ÌʦÃû ÔºÄÚ±¾¿Æ Ô°ÄÚר¿Æ ÔºÍâ±¾¿Æ ÔºÍâר¿Æ ºÏ¼Æ
Ïà¹ØµÄ±íÓУºÑ§Éú±í£¨°üº¬Ñ§Éú²ã´Î£©¡¢½Ìʦ±í£¨½ÌʦÃû£©¡¢Ñ§Éú¿ÎÌâ±í£¨Ñ§Éú½Ìʦ¶ÔÓ¦¹ØÏµÒÔ¼°ÔºÄÚÔºÍâÐÅÏ¢£©¡£
SQLÓï¾äÈçÏ£º
select
  ......
³£ÓÃSQLÓï¾äÊéд¼¼ÇÉ
×÷Õߣº À´Ô´£ºjavaeye²©¿Í ·¢²¼Õߣºadmin
ʱ¼ä£º2009-05-11 10:07:41 µã»÷£º2010
SQL½á¹¹»¯²éѯ×Ö·û´®µÄ¸Äд£¬ÊÇʵÏÖÊý¾Ý¿â²éѯÐÔÄÜÌáÉýµÄ×îÏÖʵ¡¢×îÓÐЧµÄÊֶΣ¬ÓÐʱÉõÖÁÊÇΨһµÄÊֶΣ¬±ÈÈçÔÚ²»ÔÊÐí´ó·ù¶ÈÐÞ¸ÄÏÖÓÐÊý¾Ý¿â½á¹¹µÄÇé¿öÏ¡£
ͨ¹ ......
1¡¢²éѯÈýÃŹ¦¿Î¶¼ÔÚ80·ÖÒÔÉϵÄͬѧÐÕÃû(Ò»ÌõsqlÓï¾ä)
name kecheng fenshu
ÕÅÈý ÓïÎÄ 78
ÕÅÈý Êýѧ 81
ÕÅÈý  ......