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

MySQLµÄcµ÷ÓÃ


1. ¸½¼ÓÏîÒ»¶¨ ¼ÓÉÏlibmysql.lib¡£
2. include Ò»¶¨¼ÓÉÏ mysqlµÄinclude£¨ÒòΪҪÅÜÕâ¹Ø¼üÒ»¾ä
#include <mysql.h>£©
3  lib Ò»¶¨¼ÓÉÏ mysqlµÄlib
 
ºÃÁËÏÂÃæÊÇʵÀýºÍphpº¯Êý»ù±¾Ò»ÑùµÄ¡£±¾È˲»¿ÉÄܸøÄã·­ÒëÎĵµ£¬º¯Êý²»¶®×Ô¼º¿´¡£
#include
<windows.h>//ÓÃÕâ¸ö·½±ã£¬°üº¬winsock.hËùÒÔ°üº¬winsockÒ²¿ÉÒÔ
#include <iostream>
#include <mysql.h>
using namespace std;
int main( int argc, char * argv[] )
{
//ÕâÀàÐͱð´íÁË£¬¾ßÌå¿´Îĵµ
 MYSQL mysql;
 MYSQL *pdata;
 MYSQL_RES
*result;   
 MYSQL_ROW
row;   
 char sqlcommand[80];
 mysql_init(&mysql);//Ò»¸ö³õʼ»¯
 mysql_options(&mysql,MYSQL_READ_DEFAULT_GROUP,"Gamer");
//¿ØÖÆÁ´½ÓÐÐΪµÄ
 pdata=mysql_real_connect(&mysql,"localhost","root","123456","gamer",0,NULL,0);
//Êý¾Ý¿âÁ´½Ó
 if(pdata)
 {
  cout<<"connect
successful!!"<<endl;
 }
 if(mysql_select_db(pdata,"gamerdata"))
 {
  cout<<"select_db
successful!!"<<endl;
 }
//È»ºóÑ¡ÔñÊý¾Ý¿âÁË£¬µ±È»ÓÃsqlÒ»Ñù£¬º¯Êý¿´×Å·½±ãµã
 sprintf(sqlcommand,"select * from
gamerdata");   
 
 mysql_query(pdata,sqlcommand);
//Õâ¾ä¸ÉʲôµÄ²»ÓÃÎÒ·Ñ´½ÉàÁË
 result =
mysql_use_result(pdata);
//»ñÈ¡¼Ç¼¼¯
 row = mysql_fetch_row(result);
//°´Êý×鷽ʽ°ÑÊý¾Ý·Åµ½rowÖУ¬µ±Ç°ÐеÄ
//¿´ËùÓÐÐмӸöÑ­»·¾ÍºÃ£¬Óαê×Ô¼º»áÅÜ£¬²»ÀÍ´ó¼Ò·ÑÐÄ¡£
 cout<<row[1];
//¿ÉÒÔÊä³öÁË£¬´ó¹¦¸æ³É
 mysql_close(pdata);
//±ðÍüÁË¿ªµÆ£¬ÍüÁ˹صÆ
}


Ïà¹ØÎĵµ£º

ÔÙ´ÎÔâÓölinuxÏÂmySqlÖÐÎÄÂÒÂëÎÊÌâ

С½á£º
Ê×ÏÈÒªÕÒµ½mySqlµÄÅäÖÃÎļþ
my.cnf
È»ºóÒª¸Ä¶ÔµØ·½
[client]ºÍ[mysqld]ÏÂͬʱ¼ÓÉÏdefault-character-set=utf8
È»ºó¼ÇµÃÐèÒªÖØÆôMySql.ÇÒ±£Ö¤¿Í»§¶ËµÄÁ¬½Ó·½Ê½Ò²ÊÇutf8.
Ԥף×Ô¼ºÐµÄÒ»Ä꣬¼ªÏéÈçÒ⣬ÐÄÏëʳɣ¡ ......

mysqlË÷ÒýÏê½â,Õª×Ô¡¶MySQL 5ȨÍþÖ¸ÄÏ¡·

mysqlË÷ÒýÏê½â,Õª×Ô¡¶MySQL 5ȨÍþÖ¸ÄÏ¡·
        ±¾ÎĽéÉÜÁËÊý¾Ý¿âË÷Òý£¬¼°ÆäÓÅ¡¢È±µã¡£Õë¶ÔMySQLË÷ÒýµÄÌØµã¡¢Ó¦ÓýøÐÐÁËÏêϸµÄÃèÊö¡£·ÖÎöÁËÈçºÎ±ÜÃâMySQLÎÞ·¨Ê¹Óã¬ÈçºÎʹÓÃEXPLAIN·ÖÎö²éѯÓï¾ä£¬ÈçºÎÓÅ»¯MySQLË÷ÒýµÄÓ¦Óᣱ¾ÎÄÕª×Ô¡¶MySQL 5ȨÍþÖ¸ÄÏ¡·(3rd)µÄ8.9½Ú¡£(2007.07.0 ......

ѧcµÄºÜ¶à

cѧµÄÈ˺ܶࡣµ«Ê®Ö®°Ë¾ÅÊǰëͰˮ¡£»òÕßдµÃºÜËÀ¡£Ò²ÐíÎÒÕâ»°ÓÐµãÆ«¼¤¡£µ«ÊÇÎÒ¸ø³öÒ»¸ö±ê×¼°É¡£ÄãÄÜд³öÏñlinuxÄں˴úÂëÕâÑùµÄ´úÂëÂð£¿ÆäʵÈκÎÒ»ÃÅÓïÑԵľ«Ë裬ÔÚÓÚÔËÓá£ËùÒÔÔÚѧϰ֮ǰ×îºÃÎÊÒ»ÎÊÎÒΪʲҪѧÕâÃÅÓïÑÔ¡£Èç¹ûÊÇΪѧ¶øÑ§£¬Ñ§µ½×îºóÓÖÊǰëͰˮ¡£»¹ÕæµÄ²»È翴С˵À´µÃ´Ì¼¤¡£Ã»ÓÐÄ¿µÄ¸ÉÊÂÇ飬±¾Éí¾ÍÊÇÒ»ÖÖÀË·Ñ¡£ ......

extern C µÄ×÷ÓÃ

extern "C" ÊÇ C++ ±àÒëÆ÷Ö§³ÖµÄÒ»ÖÖÁ´½Óָʾ·û£¨linkage directive£©£¬Ëü±íʾÓÉÆäÉùÃ÷µÄº¯ÊýʹÓà C ÓïÑԵķ½Ê½±àÒëºÍÁ´½Ó¡£
C ºÍ C++ ¶Ôº¯Êý±àÒëºó²úÉúµÄ·ûºÅÃûÊDz»Ò»ÑùµÄ¡£¼ÙÉèÒ»¸öº¯ÊýµÄÔ­ÐÍΪ:
void foo(int x, int y);
ÓÉ C ±àÒëÆ÷±àÒëºó²úÉúµÄ·ûºÅÃûΪ _foo£¬¶ø C++ ÓÉÓÚÖ§³ÖÖØÔØµÄÐèÒª£¬±àÒëºóµÄ·ûºÅà ......

»ùÓÚSphinx+MySQLÈ«ÎļìË÷¼Ü¹¹Éè¼Æ

ǰÑÔ£º
±¾ÎIJûÊöµÄÊÇÒ»¿î¾­¹ýÉú²ú»·¾³¼ìÑéµÄǧÍò¼¶Êý¾ÝÈ«ÎļìË÷£¨ËÑË÷ÒýÇæ£©¼Ü¹¹¡£±¾ÎÄÖ»Áгöǰ¼¸ÕµÄÄÚÈݽÚÑ¡£¬²»ÌṩȫÎÄÄÚÈÝ¡£
ÔÚDELL PowerEdge 6850·þÎñÆ÷£¨ËÄ¿Å64 λInter Xeon MP 7110N´¦ÀíÆ÷ / 8GBÄڴ棩¡¢RedHat AS4 Linux²Ù×÷ϵͳ¡¢MySQL 5.1.26¡¢MyISAM´æ´¢ÒýÇæ¡¢key_buffer=1024M»·¾³ÏÂʵ²â£¬µ¥±í1000ÍòÌõ¼Ç ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ