VCÖÐÓÃADO²Ù×÷MySqlÊý¾Ý¿âÖÐÎÄÎÊÌâ
ÎҵijÌÐòÊÇÓÃADOÀ´Á¬½ÓMysqÊý¾Ý¿âµÄ£¬ÕâÊÇÔÏÈдºÃÓÃÔÚMSSQLÉϵģ¬¸ÄÁËÏÂÁ¬½Ó×Ö·û´®£¬ËùÒÔÒ²¾ÍûÓÐÓÃMySql C++ APIÀ´ÖØÐÂдÁË¡£¸Õ¿ªÊ¼Ê¹ÓÃMySql£¬Óöµ½µÄÎÊÌâ×ÜÊÇÌرðµÄ¶à£¬ÏÖÔÚÓÖÓöµ½Ò»¸öÖ÷Òªsql×Ö·û´®ÖÐÓÐÖÐÎľͱ¨´íµÄÎÊÌ⣬ûÓÐÖÐÎÄÒ»ÇÐÕý³££¬ÕûÕûŪÁËÒ»¸öÉÏÎ磬ÔÚÍøÉÏÒ²ÕÒÁ˺ܶà×ÊÁÏ£¬·¢ÏÖÍøÉϺܶණÎ÷ȷʵÊÇÔÚÃÉÈË£¬°´ËûÃǵķ½·¨À´½á¹û¶¼ÊÇÒ»ÑùµÄ£¬»¹ÊÇ´íÎó¡£
ÏÖÔÚÖÕÓÚ°ÑÎÊÌâ¸ã¶¨ÁË£¬¹²ÏíÏÂ×Ô¼ºµÄѧϰ¾Ñé°É¡£
ÓÃADOÁ¬½ÓMySqlÊý¾Ý¿âÒªÏë±ÜÃâÖÐÎÄÂÒÂëµÈÎÊÌ⣬Ê×ÏÈÒª±£Ö¤Êý¾ÝÑ¡ÓõıàÂë¸ñʽΪGBK(ÕâÊÇÐí¶àÇ°±²Ãǽ¨ÒéµÄ£¬Õâ¸ö×Ö·û¼¯Ö§³ÖµÄ±È½Ï¶à)£¬¶øÇÒÔÚMySqlÖл¹¿ÉÒÔÉèÖñíµÄ£¬×ֶεıàÂë¸ñʽ¡£
Æä´Î£¬ÔÚAD£ÏÁ¬½Ó´úÂëÖÐ×ö±ØÒªµÄÉèÖ㬾ßÌåÉèÖÃÈçÏ£º
try
{
//ÉèÖÃADOʹÓõÄ×Ö·û¼¯
myConn->Execute("set character_set_connection=gbk",NULL,adCmdText);
myConn->Execute("set character_set_results=gbk",NULL,adCmdText);
myConn->Execute("set character_set_client=gbk",NULL,adCmdText);
myConn->Execute(_bstr_t(sqlText),NULL,adCmdText);
}
catch (_com_error e)
{
msg = e.ErrorMessage();
}
Á½·½Ã涼±£Ö¤ÁËÒÔºóÎÊÌâÓ¦¸Ã¾Í¿ÉÒԸ㶨ÁË£¬²»¹ýÎÒÏë²¢²»Ò»¶¨Ò»¶¨ÒªÊ¹Óãǣ£ˣ¬Äܱ£Ö¤Á½±ßµÄ±àÂë¸ñʽһÖÂÓ¦¸Ã¾ÍÐС£
Ïà¹ØÎĵµ£º
ÕâÁ½ÌìÕýÔÚ²âMYSQLµÄÐÔÄÜ£¬°´ÕÕMYSQLÎĵµÖÐÍƼöµÄÉèÖã¬ÐÞ¸ÄÁ˼¸¸öϵͳ±äÁ¿
innodb_buffer_pool_size=1G
innodb_log_file_size=250M
innodb_log_buffer_size=8M
½á¹ûMYSQL±ÀÁË¡£mysql¿Í»§¶ËÄܵǼ£¬µ«Ö»ÒªÖ´ÐÐÈκÎÃüÁmysqldÁ¢¿Ì±Àµô¡£
¿ªÊ¼»¹ÒÔΪÊÇinnodb_buffer_pool_sizeµÈ¼¸¸ö²ÎÊýÉèµÃÌ«´óÁË£¬¿ÉÊǵ÷ÕûÁ˼¸´Î¶ ......
MySQL Administrator ÊÇʲôÈí¼þ£¿
MySQL Administrator ÊÇÒ»¸öרÃÅÓÃÓÚ¹ÜÀí My SQL 4.X ºÍ 5.X My SQLÊý¾Ý¿âµÄÈí¼þ£¬¿ÉÒÔʹÓÃÕâ¸öÈí¼þ±¸·ÝMy SQLÊý¾Ý¿â£¬»¹ÔMy SQLÊý¾Ý¿â¡£
×¢£ºÈç¹ûÄãµÄÊý¾Ý¿âÊÇ MS SQL 2000 Êý¾Ý¿â£¬Çë²Î¿¼ÕâÀʹÓà MS SQL 2000 ÆóÒµ¹ÜÀíÆ÷¹ÜÀí
ÏÂÔØ MySQL Administrator Èí¼þ
http://61.139.76 ......
windows주
½â¾ö°ì·¨£º
1.¼ì²éÄãµÄMysqlĿ¼ÓÐûÓиøϵͳµÄSystemÓû§È¨ÏÞ¡£
2.ɾ³ýµôÄãµÄ %WINDOWS%/my.ini Îļþ¡£
3.¼ì²éÄãµÄ c:/my.cnf ÎļþÅäÖÃÊÇ·ñÕýÈ·¡£
ÐÞ¸Ä%windir%\my.ini£¬Ôö¼Ó
[mysqld]
#ÉèÖÃbasedirÖ¸ÏòmysqlµÄ°²×°Â·¾¶
basedir=D:\Program\Tools\mysql
datadir=D:\Program\Tools\mysql\data& ......
ÖÕÓÚÈ÷þÎñÆ÷ÿÌìÔçÉϱ¸·ÝÒ»´Î MySQL Êý¾Ý¿â²¢×Ô¶¯´ò°ü,ͬʱɾ³ý 5 ÌìÇ°µÄ±¸·ÝÎļþ. ·ÖÏíÈçÏÂ.
1. »·¾³: windows server 2003 + Apache 2.0 + PHP5 + MySQL 4.0.26 .
2. ¼ÙÉè PHP °²×°Ä¿Â¼Îª D:/php ,MySQL °²×°Ä¿Â¼Îª D:/mysql.
3. ÔÚ D:/php Ͻ¨Á¢Ä¿Â¼ WinRAR, °ÑÄã winrar °²×°Ä¿Â¼Ï嵀 WinRAR.exe ºÍ RARReg.KEY ¸´ ......