SQLµÄÊý¾ÝÀàÐ;ö¶¨ÁËÒ»¸ö×ֶεÄÄÚÈÝÔÚÊý¾Ý¿âÖлᱻÈçºÎ´¦Àí¡¢´æ´¢ºÍÏÔʾ¡£SQL92¶¨ÒåÁ˱ê×¼µÄÊý¾ÝÀàÐÍ£¬Ä¿µÄÊǸøÊý¾Ý¿âÖÆÔìÉ̽¨Á¢×Ô¼ºµÄÊý¾ÝÀàÐÍÌṩÀ¶Í¼¡£ÔÚÇ°ÃæµÄÎÄÕÂÖУ¬ÎÒÃǽéÉÜÁËһЩ³£ÓõÄÊý¾ÝÀàÐÍ£¬ÕâЩÊý¾ÝÀàÐÍ·ÖΪËÄ´óÀࣺ
´®ÐÐ
ÊýÖµ
ÈÕÆÚʱ¼ä
Çø¼äÐÍ
±¾ÎĽ«ÏòÄã¸ÅÊöÕâЩÊý¾ÝÀàÐÍÔÚÊý¾Ý¿âÖÐÊÇÈçºÎʹÓõģ¬È»ºó×ÅÖØ½âÊÍ´®ÐÐÊý¾ÝÀàÐÍ¡£ÕâЩÐÅÏ¢¿ÉÒÔ×÷ΪÓÐÓõIJο¼£¬»òÕß×÷Ϊ¹ØÓÚij¸öÊý¾Ý¿âÖÆÔìÉ̾ßÌå²úÆ·ÖÐÊý¾ÝÀàÐ͵ı³¾°ÖªÊ¶¡£
ʹÓÃÊý¾ÝÀàÐÍ
µ±ÄãÔÚÊý¾Ý¿âÖд´½¨ÁËÒ»¸ö±í¸ñ£¬Äã¾Í¶¨ÒåÁËÿÁеÄÃû×ÖÒÔ¼°ÒªÊäÈëµ½ÕâЩÁÐÖеÄÄÚÈݵÄÊý¾ÝÀàÐÍ¡£´ÓÏÈǰµÄÎÄÕÂÖнèÓÃÒ»¸öÀý×Ó£º
CREATE TABLE Products
(prod_id INT(16)AUTO_INCREMENT, prod_color VARCHAR(20),
prod_descr VARCHAR(255), prod_size DECIMAL(8,2),
UNIQUE (`prod_id`));
ÔÚÒÔÉϵIJéѯÖУ¬¶¨ÒåÐÐprod_color VARCHAR(20)·¢³öÖ¸ÁîÒª´´½¨Ò»¸öÁУ¬Ãû×ÖÊÇprod_color£¬Êý¾ÝÀàÐÍÊÇVARCHAR£¬³¤¶ÈΪ20¡£
ÄãµÄÊý¾Ý¿âʹÓúÍÿ¸öÀàÐÍÏà¹ØµÄÃèÊö·ûÀ´Çø±ðÊý¾ÝÀàÐÍ¡£ÀýÈ磬VARCHARÊý¾ÝÀàÐ͵ÄÃèÊö·ûËùº¬µÄÐÅÏ¢½«ËüÇø±ðΪ´®ÐÐÊý¾ÝÐÍ£¬Ëü°üº¬ËùÓеĴ®×Ö·û£¬Æä³¤¶ÈÊǿɱäµÄ¡£Êý¾Ý¿âÀïÁе͍Ò廹°üº¬ÁËÆäËûÐÅÏ¢£¬ÀýÈç¶ÔÓ¦ÓÚÊý¾ÝÀàÐ͵ÄÌØ¶¨³¤¶È¡£
ÈçǰËùÊö£¬Ã¿¸öÊý¾Ý¿âÖÆÔìÉ̶¼Ï£ÍûÔÚSQL92¶¨ÒåµÄ±ê×¼ÉϽ¨Á¢×Ô¼ºµÄÊý¾ÝÀàÐÍ¡£ÕâÑùÿ¸öÊý¾Ý¿âÔÚ¶¨ÒåÊý¾ÝÀàÐÍʱ¶¼Äܹ»É趨×Ô¼ºËùÐèÒªµÄ×î´óÈÝÁ¿ÏÞÖÆºÍÆäËûÊôÐÔ¡£Ðí¶àÊý¾Ý¿âʹÓõÄÊý¾ÝÀàÐÍÃû×ÖºÍÕâÀïÁгöÀ´µÄÒ»Ñù£¬¾¡¹ÜÿÖÖµÄʵÏÖ·½·¨¶¼ÓÐ΢СµÄ²î±ð¡£ÒªÈ·¶¨Ìض¨Êý¾ÝÀàÐÍʹÓ÷½·¨µÄϸ½Ú×îºÃµÄ·½·¨»¹ÊDzéÔÄÊý¾Ý¿âÖÆÔìÉ̵ÄÎĵµ¡£
ÒѾ˵¹ýÁË£¬Ï£Íû¶Ô±ê×¼×Ö·û´®Êý¾ÝÀàÐÍÓиü¶àµÄÁ˽â¾ÍÍùÏ¿´¡£
´®
ÓÐÁ½ÖÖÖ÷ÒªµÄ´®ÐÐÊý¾ÝÀàÐÍ£º×Ö·ûºÍλ¡£´®ÐÐʹÓÃÊý¾Ý¿âÀïÓÉSQL_TEXTËù¶¨ÒåµÄ×Ö·û¡£SQL_92±ê׼ͬʱ»¹ÌṩÁËNATIONAL CHARACTER£¨¹ú¼Ò×Ö·û¼¯£©ºÍNATIONAL CHARACTER VARYING£¨¹ú¼Ò×Ö·û¼¯±äÌ壩£¬ÕâÁ½Õß¶¼ÄÜʹÓÿɶ¨Òå×Ö·û¼¯¡£ºóÕߵĴ¦Àí·½·¨ºÍCHARACTERÒÔ¼°CHARACTER VARYINGÀàÐÍÒ»Ñù¡£
CHARACTER | CHAR
ʹÓ÷½·¨£ºCHARACTER(clength) | CHAR(clength)
CHARACTERºÍCHARÕâÁ½¸ö¹Ø¼ü×ÖÊÇÏàͬµÄ¡£
CHARACTERÀàÐÍÒ»¸öÍ»³öµÄÌØµãÊÇËüÃÇÄܹ»°üº¬Õâ¸ö×Ö·û¡£
CHARACTER ÀàÐͰüº¬Á˹̶¨³¤¶ÈµÄ´®×Ö·û£¨À´×ÔSQL_TEXTµÄÓïÑÔ¼¯£©£¬clength¡£
×Ö·ûÔÚÖµµÄ³¤¶ÈСÓÚclengthʱÆðÌî³ä×÷Óá£Õâ±íʾCHARACTER×ֶεij¤¶ÈÊǹ̶¨µÄ¡£
Äã¿ÉÒÔ°ÑCHARACTERµÄÊý¾ÝÀàÐÍ×ֶκÍÏàͬÀàÐÍµÄÆäËûÔÊÐí²»Í¬³¤¶ÈµÄ×ֶαȽϣ¬»òÕߺÍCHARACTER VARYING Êý¾ÝÀàÐͱȽϡ£
ÓÐЩÊý¾Ý¿âÔÊÐíºÍÊýÖµÊý¾ÝÀàÐͱȽϡ£
CHARACTER VARYING | CHAR VARYING | VARCHAR
ʹÓ÷½·¨£ºCHARACTER VARYING(maxlength) | CHAR VARYING(maxlength) | VARCHAR(maxlength)
CHARACTER VARYING£¬CHAR VARYING£¬ºÍVARCHARÕ⼸¸ö¹Ø¼ü×ÖÊÇÏàͬµÄ¡£
ÕâЩÀàÐÍÄÜÈÝÄÉ×î´ó³¤¶ÈµÄ×Ö·û´®£¬maxlength¡£
Êý¾Ý¿â°Ñ×ֶεij¤¶È×÷ΪֵµÄʵ¼Ê³¤¶È¡£
Äã¿ÉÒÔ°ÑÕâЩÊý¾ÝÀàÐ͵Ä×ֶκÍÏàͬÀàÐÍµÄÆäËûÔÊÐí²»Í¬×î´ó³¤¶ÈµÄ×ֶαȽϡ£
BIT
ʹÓ÷½·¨£ºBIT(blength)
ÕâÖÖÀàÐͰüº¬ÁË´øÓг¤¶ÈµÄλ×Ö·û£¨1ºÍ0£©£¬blength¡£ÀýÈ磬Èç¹ûÎÒÃÇʹÓÃBIT(2)£¬Ñù±¾Öµ½«Îª¡°01¡±¡£
ÓеÄÊý¾Ý¿â»áÔÚ´®µÄ¿ªÍ·²åÈë¿Õ룬ÆäµÄÔò»áÌî³äËüÃÇÒÔ·ûºÍ¹Ì¶¨³¤¶ÈµÄÒªÇó¡£
λ×Ö·ûÊÇ´®£¬²»ÊÇÕûÊý¡£
[1] [2] ÏÂÒ»Ò³