ºÜÓÐÄѶȵÄ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
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......