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 д´í¡£
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
hql = "select left('adfsadfasgsadgagsda',2)";
¾ÍÓÃÕâ¾äÓï¾ä ÔÚÊý¾Ý¿âÖÐÖ´ÐÐ
µ«ÊÇÔÚjava´úÂëÖÐ ÓÃHibernate Ö´ÐÐ ¾Í²»ÄÜÖ´ÐÐ £¿
ÕâÊÇʲôÎÊÌ⣡£¡£¡
ÎÒÒѾ֪µÀÁË£¡
&n ......
ͨ¹ýODBCÁ¬½ÓMySQLÊý¾Ý¿â£¬Á¬½Ó³É¹¦£¬µ«²»ÄܲéѯÊý¾Ý£¬²»ÖªµÀΪʲô
'Á¬½ÓmysqlÊý¾Ý¿â
str = "dsn=test;driver={MySQL odbc 3.51 Driver};server=localhost;port=3306;uid=root;pwd=;database=officesyst ......