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

MySQL´íÎóDLL

MYSQL Õâ¸ö´íÎóÔõô½â¾ö°¡¡£¡£ÇóÖú

Õâ¸ö´íÎó¸ãÎÒµÄDZ̳ÂÛ´ò²»¿ªÇÒIISµ¼³£Ò²²»ÖªÊDz»ÊÇÒòΪËûÒýÆðµÄ

ʼþÀàÐÍ:        ´íÎó
ʼþÀ´Ô´:        MySQL
ʼþÖÖÀà:        ÎÞ
ʼþ ID:        100
ÈÕÆÚ:                2009-12-23
ʼþ:                4:35:36
Óû§:                N/A
¼ÆËã»ú:        HX110
ÃèÊö:
ʼþ ID ( 100 )µÄÃèÊö(ÔÚ×ÊÔ´( MySQL )ÖÐ)ÎÞ·¨ÕÒµ½¡£±¾µØ¼ÆËã»ú¿ÉÄÜûÓбØÒªµÄ×¢²áÐÅÏ¢»òÏûÏ¢ DLL ÎļþÀ´´ÓÔ¶³Ì¼ÆËã»úÏÔʾÏûÏ¢¡£Äú¿ÉÄÜ¿ÉÒÔʹÓà /AUXSOURCE= ±êʶÀ´¼ìË÷´ÊÃèÊö£»²é¿´°ïÖúºÍÖ§³ÖÒÔÁ˽âÏêϸÐÅÏ¢¡£ÏÂÁÐÐÅÏ¢ÊÇʼþµÄÒ»²¿·Ö: Cannot find or open table video/pv_collectrules from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
how you can resolve the problem.

½ö´Ó´íÎóÌáʾÉÏÀ´¿´£¬ÊÇÄãµÄ±íÖеÄibdataÊý¾ÝÎļþÕÒ²»µ½¶ÔÓ¦µÄÄÚÈÝ¡£

µÚÒ»²½£ºÏȼì²éÒ»ÏÂÄãµ


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

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

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

ÓÃPHPÅÅÐòmysqlÎÊÌâ

²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ