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();
}
Á½·½Ã涼±£Ö¤ÁËÒÔºóÎÊÌâÓ¦¸Ã¾Í¿ÉÒԸ㶨ÁË£¬²»¹ýÎÒÏë²¢²»Ò»¶¨Ò»¶¨ÒªÊ¹Óãǣ£ˣ¬Äܱ£Ö¤Á½±ßµÄ±àÂë¸ñʽһÖÂÓ¦¸Ã¾ÍÐС£
Ïà¹ØÎĵµ£º
¿ÉÒԲο¼ÏÂÁÐÎÄÕÂ
http://www.mysqlperformanceblog.com/2010/03/23/too-many-connections-no-problem/
½áÂÛÈçÏ£º
£¨1£©mysqlĬÈÏ»á¸øsuperÓû§ÁôÒ»¸öÁ¬½Ó£¬Äã¿ÉÒÔÓÃÕâ¸öÔ¤ÁôµÄÁ¬½ÓÀ´µÇ¼£¬À´Ôö¼ÓÁ¬½ÓÊý£»µ«ÊÇÈç¹ûÁ¬½ÓµÄÓû§È«ÊÇsuperȨÏ޵ģ¬ÔòÕâ¸öÔ¤ÁôµÄÁ¬½Ó²»´æÔÚ¡£Õâʱ¿ÉÒÔÓÃÒÔϵÄÃüÁîÀ´ÉèÖÃÁ¬½ÓÊý£ºgdb -p $(cat ......
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& ......
ÔÚÉú²úÓ¦ÓÃÖУ¬Ä³Ì¨“Nginx+PHP+MySQL”½Ó¿ÚÊý¾Ý·þÎñÆ÷£¬°çÑݵĽÇÉ«Ê®·ÖÖØÒª£¬Èç¹û·þÎñÆ÷Ó²¼þ»òNginx¡¢MySQL·¢Éú¹ÊÕÏ£¬¶ø ¶Ìʱ¼äÄÚÎÞ·¨»Ö¸´£¬ºó¹û½«·Ç³£ÑÏÖØ¡£ÎªÁ˱ÜÃâµ¥µã¹ÊÕÏ£¬ÎÒÉè¼ÆÁË´ËÌ×·½°¸£¬±àдÁËfailover.sh½Å±¾£¬ÊµÏÖÁËË«»ú»¥±¸¡¢È«×Ô¶¯Çл»£¬¹ÊÕÏתÒÆʱ¼ä Ö»Ð輸ʮÃë¡£
Ò»¡¢Ë«»ú»¥±¸¡¢È«×Ô¶¯Çл»·½°¸ ......
¸ßÐÔÄÜMySqlѧϰ±Ê¼Ç
1.Õë¶ÔÓ¦Óý¨Á¢×Ô¼ºµÄË÷Òý
URL²éÕÒÀý×Ó
select * from tUrl where url='http://www.163.com';
ÒÔurl£¨×Ö·û´®£©×÷ÐÐΪË÷Òý»áʹµÃ×÷ΪË÷Òý½á¹¹µÄB-Tree±ä´ó£¬¿ÉÒÔÒƳýurlÁÐÉϵÄË÷Òý£¬²¢Ìí¼ÓÒ»¸öurl_crcË÷ÒýÁУ¬
ÏȽ¨Á¢±í£º
create tables tUrl(
......
ת×Ô http://www.supidea.com/post/mysql_design_database.aspx
MySQLÊý¾Ý¿âÉè¼ÆÔÔò
MySQL¶ÔÓÚ³ÉΪһ¸ö·Ç³£¿ìËÙµÄÊý¾Ý¿â·þÎñÆ÷ÓÐ×ŵ±Ö®ÎÞÀ¢µÄÃûÉù£¬ËüÒ²·Ç³£ÈÝÒ×ÉèÖúÍʹÓá£Ëæ×ÅËü×÷ΪÍøÕ¾ºó¶ËÊý¾Ý¿âµÃÉùÍûÈÕÔö£¬ÆäЧ¹ûÔÚÈ¥Ä꿪ʼÓÐÃ÷ ÏÔÌá¸ß¡£µ«ÊǺܶàMySQLÓû§¸ü¶àµØÖªµÀÈçºÎ´´½¨Ò»¸öÊý¾Ý¿â²¢±àд¶ÔËüµÄ²éѯ¡£¾ÍÏñ³ÉÇ ......