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);
//±ðÍüÁË¿ªµÆ£¬ÍüÁ˹صÆ
}
Ïà¹ØÎĵµ£º
Ò»°ã¸³Ó踡µãÁеÄÖµ±»ËÄÉáÎåÈëµ½Õâ¸öÁÐËùÖ¸¶¨µÄÊ®½øÖÆÊý¡£Èç¹ûÔÚÒ»¸öFLOAT(8, 1)µÄÁÐÖд洢1. 2 3 4 5 6£¬Ôò½á¹ûΪ1. 2¡£Èç¹û½«ÏàͬµÄÖµ´æÈëFLOAT(8, 4) µÄÁÐÖУ¬Ôò½á¹ûΪ1. 2 3 4 6¡£Õâ±íʾӦ¸Ã¶¨Òå¾ßÓÐ×㹻λÊýµÄ¸¡µãÁÐÒÔ±ãµÃµ½¾¡¿ÉÄܾ«È·µÄÖµ¡£Èç¹ûÏ뾫ȷµ½Ç§·ÖÖ®Ò»£¬ÄǾͲ»Òª¶¨Òåʹ¸ÃÀà ......
ÍøÉÏÓÐºÃ¶àÆªÎÄÕ½²ÈçºÎÅäÖÃ.vimrcÎļþÀ´ÊµÏÖVIMÀïÒ»¼ü±àÒ룬¿´ÁËһϱȽϸ´ÔÓ¡£ÎÒÒ»°ãûÓÐʲô´óµÄ³ÌÐòҪд£¬Ò»°ãµÄС³ÌÐòµ¥¸öCÎļþ¾Í¸ãµàÁË£¬ËùÒÔ¼ò»¯ÁËÒ»ÏÂÍøÉϵÄÅäÖã¬ÔÚ.vimrcÀï¼ÓÉÏÁ½ÐоÍÂú×ãÎÒµÄÐèÇóÁË¡£
set makeprg=gcc\ -Wall\ -o\ %<\ %
map <F7> :make<CR ......
Mysql Explain Ïê½â
ת×ÔITPUBhttp://www.itpub.net/viewthread.php?tid=1034410&extra=page%3D1%26amp%3Bfilter%3Ddigest&page=1
Ò».Óï·¨
explain < table_name >
ÀýÈç: explain select * from t3 where id=3952602;
¶þ.explainÊä³ö½âÊÍ
+----+-------------+-------+-------+-------------------+--- ......
×ªÔØ×Ô£ºhttp://www.cnblogs.com/chio/archive/2007/11/26/972152.html
CRTÔÏÈÊÇÖ¸Microsoft¿ª·¢µÄC Runtime Library£¬ÓÃÓÚ²Ù×÷ϵͳµÄ¿ª·¢¼°ÔËÐС£ºóÀ´ÔÚ´Ë»ù´¡ÉÏ¿ª·¢ÁËC++ Runtime Library£¬ËùÒÔÏÖÔÚCRTÊÇÖ¸Microsoft¿ª·¢µÄC/C++ Runtime Library¡£ÔÚVCµÄCRT/SRCĿ¼Ï£¬¿ÉÒÔ¿´µ½CRTµÄÔ´Â룬²»½öÓÐCµÄ£¬Ò²ÓÐC++µ ......
½ñÌìΪÁ˳¹µ×¸ã¶¨Ò»¸ö¹ØÓÚcÖÐÊý×é³õʼ»¯ºÍÉùÃ÷²»Í¬Çé¿öÏ£¬±ÈÈçÖ»ÉùÃ÷Ò»¸öÊý×échar str[20];ÄÇôÕâstrÀïÃæÊÇʲôÄÚÈÝÄØ£¿ÎÒÓÃvc6++£¬debugÏ¿´µ½¶¼ÊÇ-56¶öascÂ룬ºóÀ´Çë½ÌÁËÒ»¸ö»ªÎªµÄ´óÅ££¬Ëû˵ °´ÕÕÀíÂÛÀ´ËµÀïÃæµÄÄÚÈݶ¼ÊÇÓпÉÄܵģ¬ÕâºÍ½Ð×ö“ÔàÄÚ´æ”»òÕß½Ð×ö“Ò°Êý×锡£ºÃÁ˵ÚÒ»¸öÎÊÌâ¸ã¶®ÁË¡£
......