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-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
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 ......