mysql ÓÐûÓÐsqlserverµÄ¡¡¹æÔò¹¦ÄÜ
mysql ÓÐûÓÐsqlserverµÄ¡¡¹æÔò¹¦ÄÜ ±ÈÈçsqlserverµÄ¹æÔòÈçÏ create rule [IsSpecial] as @ in ('y','n') Ëû¿ÉÒÔÖ¸¶¨×ֶεÄÖµ¡¡µÄ¡¡È¡Öµ·¶Î§
ÓÃÔ¼Êø¿ÉÒÔʵÏÖ mysql ÖÐûÓÐÕâ¸öRULEµÄ¹¦ÄÜ¡£ ²»¹ýÄã¿ÉÒÔʹÓà ENUM ÀàÐÍÀ´ÊµÏÖÀàËÆ¹¦ÄÜ¡£ ¸Ðл¥ÉÏ¡¡ ĿǰmysqlÖÐûÓÐÕâ¸ö£¬Äã¿ÉÒÔ°Ñ×ֶεÄÊý¾ÝÀàÐͶ¨ÒåΪenum¾Í¿ÉÒÔʵÏÖÁË È磺 SQL code: create table tb_test (id int, flag enum('y','n')); mysqlÓÐÕýÔò±í´ïʽ ö¾ÙÀàÐÍ like×Ö¶Î ÎÞcheck mysql 5Ö»ÓÐÍâ¼üÔ¼Êø£¬Ã»ÓÐÖµÔ¼Êø¹¦ÄÜ¡£ ÒýÓà ÓÃÔ¼Êø¿ÉÒÔʵÏÖ
Ïà¹ØÎÊ´ð£º
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓᣠÊý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
MySQLÈëÃÅ ¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿ ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£ È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html ¾ÍÕÒÒ»±¾ºÜ»ù´ ......
»·¾³£ºwin2003 apache2 resin3 php5 mysql5 mysql´íÎóÀï³öÏÖÕâ¸ö£¬·þÎñÆ÷Ö±½ÓËÀµ½ÄÇÀï¡£ InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_log ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5 ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......