mysqlÊý¾Ý¿â enumÀàÐÍÎÊÌâ
Óиö×Ö¶ÎÊÇenumÀàÐ͵쬴´½¨±íµÄʱºòĬÈϸøÁ˼¸¸öÖµ
create tb_test(
id bigint,
filed_test enum('aa','bb') DEFAULT NULL;
)
ÎÒÏÖÔÚÏëÐÞ¸ÄÍùenumÀï±ßÔö¼ÓÒ»¸öÖµ'cc'£¬ÇëÎÊsqlÓï¾äÔõôд£¿£¿£¿£¿
alt tb_test modify filed_test enum('aa','bb','cc') DEFAULT NULL;
ÕâÑùд±¨´í£¬Çë´óÏÀÖ¸µã£¡
лл£¬ÎÒÔÎÁË alt д´í¡£
лл£¬ÎÒÔÎÁË alt д´í¡£
Ïà¹ØÎÊ´ð£º
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......
ÎÒÏÖÔÚÏëÓÃJSPʵÏÖQQÓÊÏäÀïµÄ¶¨Ê±·¢ËÍ£¬ÎÒÏëͨ¹ýÊý¾Ý¿â½øÐж¨Ê±²åÈëÊý¾Ý¡£
µ«²»ÖªµÀÈçºÎʵÏÖ£¬»òÕß´ó¼ÒÓиüºÃµÄ·½·¨£¬²»Ò»¶¨ËµÊÇÊý¾Ý¿â¡£
Çë´ó¼Ò¸øµãÒâ¼û£¬°ÝлÀ²¡£
quataz¶¨Ê±Æ÷×é¼þÊǸöºÜºÃµÄ½â¾ö·½°¸¡£
È ......
×î½ü³öÏÖÒ»¸öºÜÆæ¹ÖµÄÎÊÌ⣬ÓÃADOÁ¬½ÓMYSQL£¬½«Á¬½ÓOPENµÄʱºò£¬Èç¹ûMYSQLÆô¶¯Ê±¾ÍÁ¬½Ó´íÎó£¬Í¬Ê±×Ô¶¯¹Ø±ÕMYSQL·þÎñ£»ÈôMYSQLûÓÐÆô¶¯¾Í¿ÉÒÔÕý³£OPEN¡£
Ò²¾ÍÊÇÿÁ½´ÎÔËÐбØÈ»»á³ö´íÒ»´Î£¬µ«Ã¿Á½´ÎÔËÐÐÒ²±ØÈ»³É¹¦Ò»´ ......