¹ØÓÚmysqlÊý¾Ý¿â²¢·¢·ÃÎʵÄÎÊÌâ
ÎÒÓÃphpÔÚÒ»¸öÒ³ÃæÖÐ×öÁ˸ö¼ÆÊýÆ÷£¬¾ÍÊǵ±Õâ¸öÒ³Ãæ±»·ÃÎÊʱ£¬ÎÒÈÃÊý¾Ý¿âÖеÄij¸ö×ֶεÄÖµ¼Ó1.Èç¹ûͬʱÓзdz£¶à·Ç³£¶àµÄÈË·ÃÎÊÕâ¸öÒ³Ãæ£¬ÄÇÊý¾Ý¿âÄÜ׼ȷִÐÐ+1µÄ²Ù×÷Â𣿣¿£¿Èç¹û²»ÄÜ£¬ÓÐʲô½â¾öµÄ°ì·¨Âð
û¹ØÏµ¡£MYSQL»á×Ô¶¯¼ÓËøµÄ£¬µÈÒ»¸ö update table1 set cnt=cnt=1 where id=xx; Ö´ÐÐÍêºó²ÅÖ´ÐÐÁíÍâÒ»¸ö¡£
×Ô¶¯¼ÏËø º¹
Ïà¹ØÎÊ´ð£º
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 ......
select * from table where '123456789' like '%'+×ֶαí+'%'
Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......