mysqlµ¥ÕűíÓÐûÓÐ˵ÏÞÖÆ×î¶àinsert¶àÉÙÌõµÄ
RT,ÓÐûÓÐÕâ¸öÏÞÖÆ£¬ÀýÈçijÌìÎÒÒªinsert¸ö¼¸°ÙÍò»òÕßÉÏǧÍòÌõÊý¾Ý£¬»á²»»áÓÐÏÞÖÆ»òÕß±ÀÀ£¡£
innodb ÔòûÓУ¬ÊÜÄãµÄÎļþϵͳºÍ´ÅÅÌ´óСÏÞÖÆ¡£
myisam 2^32 ¸ö¼Ç¼¡£(~4.295E+09) Èç¹û²»¹»Ä㻹¿ÉÒÔÉèÖÃÏàÓ¦ÅäÖòÎÊýÒÔ´ïµ½ (2^32)^2 (1.844E+19) , µ±È»Í¬ÑùÊܵ½ÄãµÄÎļþϵͳµÄÏÞÖÆ¡£
ÓиöÔö¼Ó±íÐÐÊýÉÏÏßµÄ
ÀàËÆadd rows
¼È²»Ì«ÇåÁË
Ïà¹ØÎÊ´ð£º
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º
Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ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 ......
select * from table where '123456789' like '%'+×ֶαí+'%'
Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......
ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿
¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......