ºÜÓÐÄѶȵÄmysqlÎÊÌ⣬ÄѵÀÊÇMYSQLµÄBUG¡£
ÎÒÔÚÆô¶¯MYSQLºó£¬ÔÚÃüÁîÐÐÖ´ÐÐselect * from user; user±íÖ»ÓÐID£¬NAME2¸ö×ֶΣ¬È»ºóϵͳ¾Íwindows¾ÍÌáʾ£¬MYSQLD.EXEÓöµ½µ½´íÎó£¬È»ºóMYSQL¾Í×Ô¶¯Í£Ö¹ÁË¡£ÖØÐÂÆô¶¯ºó£¬Èç¹û²»Ö´ÐÐÕâ¾äSQL¾ÍûÎÊÌ⣬ֻҪִÐоÍÓÐͬÑùµÄºó¹û¡£ÎҲ鿴ÁË´íÎóÈÕÖ¾£¬±È½ÏÄÑ¿´¶®£¬´íÎóÈÕÖ¾ÈçÏ£º
091208 20:26:13 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions.
091208 20:26:13 InnoDB: highest supported file format is Barracuda.
091208 20:26:14 InnoDB Plugin 1.0.4 started; log sequence number 47932
091208 20:26:14 [Note] Event Scheduler: Loaded 0 events
091208 20:26:14 [Note] C:\Program Files\MySQL\MySQL Server 5.4\bin\mysqld: ready for connections.
Version: '5.4.3-beta-community' socket: '' port: 3306 MySQL Community Server (GPL)
InnoDB: Error: trying to access update undo rec field 4294967040 in index "GEN_CLUST_INDEX" of table "aa"."user"
InnoDB: but index has only 4 fields
InnoDB: Submit a detailed bug report to http://bugs.mysql.com
InnoDB: Run also CHECK TABLE "aa"."user"
InnoDB: n_fields = 14837, i = 13, ptr 03C95657
InnoDB: Error: trying to access update undo rec for table aa/user
InnoDB: but the table id in the undo record is wrong
InnoDB: Submit a detailed bug report to http://bugs.mysql.com
InnoDB: Run
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿
¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......
Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
You can't specify target table 'a_table' for update in from clause
ÍêÕûSQLÓï¾äÊÇ
UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......