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Êý¾ÝÎļþÕÒ²»µ½¶ÔÓ¦µÄÄÚÈÝ¡£
µÚÒ»²½£ºÏȼì²éÒ»ÏÂÄãµ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÎÒ¿ª·¢ASP.netʱ
²åÈëÍâÎÄÂÒÂë
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......