Ôٴλ¶ÓÄúÀ´µ½SQL£¨½á¹¹»¯²éѯÓïÑÔ£©»ù´¡ÏµÁн̡̳£±¾ÎĽ«½éÉÜÊý¾Ý¿â¶¨ÒåÓïÑÔ£¨DDL£©ÓÃÓÚ´´½¨Êý¾Ý¿âºÍ±í¸ñÒÔ¼°Ð޸ıí¸ñ½á¹ûµÄÖ¸Áî¡£
µ±ÄãʹÓÃÕâЩָÁîʱһ¶¨ÒªÐ¡ÐÄ¡ª¡ªËüºÜÈÝÒ×ɾȥÄãµÄÊý¾Ý¿âÖеÄÖ÷Òª½á¹¹ÁîÄú¶ªÊ§Êý¾Ý¡£ËùÒÔ£¬ÔÚÄú¿ªÊ¼ÐÞ¸ÄÊý¾Ý¿â֮ǰ£¬ÄúÐèÒªÖªµÀÊý¾Ý¿âÊÇʲô¡£
--------------------------------------------------------------------------------
Êý¾Ý¿âÖ®¼äµÄ²îÒì
±¾ÎÄÖеÄÑùÆ·²éѯϵͳ×ñÑSQL92 ISO±ê×¼¡£²¢²»ÊÇËùÓеÄÊý¾Ý¿â¶¼×ñѸñê×¼£¬ÓÐЩÊý¾Ý¿â×öÁ˸Ľø£¬Õâ»á²úÉý²»¿ÉÔ¤ÁϵĽá¹û¡£Èç¹ûÄã²»ÄÜÈ·¶¨ÄãµÄÊý¾Ý¿âÊÇ·ñÖ§³Ö¸Ã±ê×¼£¬Çë²Î¿¼ÏàÓ¦µÄÎĵµ¡£
--------------------------------------------------------------------------------
´´½¨Êý¾Ý¿â
ΪÁË´´½¨±í¸ñ£¬ÄãÊ×ÏÈÐèÒªÐèÒª´´½¨Ò»¸ö¿ÉÒÔÈÝÄɱí¸ñµÄÊý¾Ý¿â¡£SQLÓÃÓÚ´´½¨Êý¾Ý¿âµÄ»ù±¾Óï¾äÊÇ£º
CREATE DATABASE dbname;
ÄãµÄÊý¾Ý¿âÓû§±ØÐëÓн¨Á¢Êý¾Ý¿âµÄÊʵ±È¨ÏÞ¡£Èç¹ûÓëÄãÓйصÄÓû§²»ÄÜ·¢³öÓÃÓÚ´´½¨ÐÅÊý¾Ý¿âµÄÃüÁҪÇóÊý¾Ý¿â¹ÜÀíԱΪÄ㽨Á¢Êý¾Ý¿â£¬ÄãÒ²×÷Ϊ¹ÜÀíÔ±µÇ¼Ȼºó½¨Á¢Êý¾Ý¿â²¢ÉèÖÃȨÏÞ¡£
¾Ù¸öÀý×Ó£¬ÓÃCREATEÖ¸ÁîΪһ¸öÓ¦ÓóÌÐò½¨Á¢Ò»¸öÊý¾Ý¿âÓÃÓÚÏÔʾһ¸öĿ¼£º
CREATE DATABASE Catalog;
Õâ¸øÄãÒ»¸öÓÃÓÚÔÚ²éѯʱÓëÆäËü±í¸ñÇø·ÖµÄ±í¸ñÃû×Ö¡£ÏÂÒ»²½ÊÇ´´½¨ÓÃÓÚÊäÈëËüµÄ±í¸ñ¡£
´´½¨±í¸ñ
ÈçÄãËùÖª£¬±í¸ñÊÇÓÐÈô¸É¸öÀ¸Ä¿Ëù×é³É¡£µ±´´½¨±í¸ñʱ£¬Äã¿ÉÒÔ¶¨ÒåÀ¸Ä¿²¢·ÖÅä×Ö¶ÎÊôÐÔ¡£±í¸ñ½¨Á¢ºó£¬¿ÉÒÔÓÃALTER±í¸ñÖ¸ÁîÀ´ÐÞ¸ÄËü£¬ÎÒÃÇÉÔºó½«Ìáµ½ÕâÒ»µã¡£
Äã¿ÉÒÔÓÃÏÂÃæÕâÌõÖ¸ÁîÀ´´´½¨Êý¾Ý¿â£¬ÃüÁîÐеIJÎÊýΪ±í¸ñÃû×Ö¡¢À¸Ä¿Ãû×Ö£¬»¹ÓÐÿһÀ¸µÄÊý¾ÝÀàÐÍ¡£
CREATE TABLE table_name
(column1 data_type, column2 data_type, column3 data_type);
²»Í¬µÄÊý¾Ý¿âÌṩÉ̵ıê×¼²î±ðºÜ´ó¡£ÄãµÄ°ïÖúÎĵµÖÐÓ¦¸ÃÓÐÒ»¶ÎÏêϸ˵Ã÷ÈçºÎʹÓÃÿһÖÖÊý¾Ý¡¢½ÓÊܺÎÖÖ²ÎÊý¡£ÎªÁËͨÓã¬ÎÒÔÚ±íAÖÐÁгöÁËһЩ³£ÓõÄÊý¾ÝÀàÐÍ¡£
±íA
Êý¾ÝÀàÐÍ
Ó÷¨
Ïêϸ˵Ã÷
Char
Char(8)
Ëü°üº¬ÁËÒ»¸ö¹Ì¶¨³¤¶ÈµÄ×Ö·û´®£¬ÆäÖµ³£³£ÊÇ×Ö·û´®³¤¶È¡£
Varchar
Varchar(128)
Ëü°üº¬ÁËÒ»¸ö³¤¶È²»´óÓÚÖ¸¶¨ÖµµÄ³¤¶È¿É±äµÄ×Ö·û´®¡£
Int
Int(32)
ÕâÊÇÒ»¸ö²»´óÓÚÖ¸¶¨ÖµµÃÕûÊý£¬Ò²×öNumber»òInteger¡£
Decimal
Decimal(12,2)
ÕâÊÇÒ»¸ö×ÜλÊýºÍСÊýµãºóλÊý²»´óÓÚÖ¸¶¨ÖµµÃСÊý£¬Ò²±»³ÆÎªNumeric»òNumber¡£
Binary
Binary
ÓÃÓÚ´æ´¢¶þ½øÖƶÔÏó£¬ÔÚÊý¾Ý¿âÖÐËüÒ»°ã²»¿É·Ö½âºÍÏÔʾ£¬Ò²³ÆÎªRaw»òBlob¡£
Boolean
Boolean
ÓÃÀ´Ö»ÊÇÕæ»ò¼Ù£¬Ò²³ÉΪBit»òByte¡£
[1] [2] [3] ÏÂÒ»Ò³