Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ºÜÓÐÄѶȵÄ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µÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

MYSQL ÈçºÎÐÞ¸ÄBLOBÀàÐ͵ÄÊý¾Ý?

ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿

¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......

mysql ÔõÑù²ÅÄܶÔͬһÕűí²éѯºóÔÙ¸üÐÂ?

Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
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ÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......

MySQL´íÎó - PHP / »ù´¡±à³Ì

ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿

ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ

¿ÉÒÔÓÃÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ