c++Á¬½Ómysql³ö´í(¼±°¡)
#include <winsock2.h>
#include <iostream>
#include <mysql.h>
using namespace std;
int main(char **args){
MYSQL mysql;
mysql_init(&mysql);
if (mysql_real_connect(&mysql,"localhost","root","ok","test",3306,0,0))
{
cout < <"ok" < <endl;
return 0;
}
else
{
int i = mysql_errno(&mysql);
constchar * s = mysql_error(&mysql);
cout < < s < <endl;
}
}
error:´íÎó:1:fatal error C1083: Cannot open include file: 'mysql_com.h': No such file or directory¡£
e:\×ÊÁÏ\c++\1\1\mysql.h 41
mysql_com.hÊÇmysql.hÄÚ²¿#includeµ÷ÓõÄ,ÇëÎÊÏÂÕâ¸öÎÊÌâÒªÔõô´¦ÀíÄØ???
#include <mysql.h>ÒÔ¼°'mysql_com.h'µÈÆäËü.hËùÔÚµÄĿ¼Äã¿´ÊÇ·ñÔÚÔÚvcÖÐÁË
¹¤¾ß->Ñ¡Ôñ->Ŀ¼
Õâ¸ö
vcÊÇʲô?
º¹£¬LZ²»ÖªµÀVCÊÇʲô£¬Äã¼ÈÈ»#include <winsock2.h> £¬Ó¦¸ÃÊÇwindowsƽ̨ÁË
ÕÒ²»µ½Í·Îļþ£¬Èç¹ûÈ·ÈÏ´æÔڵϰ£¬¿ÉÄÜÊÇ·¾¶²»ÔÚ±àÒëÆ÷°üº¬Â·¾¶ÏÂÃæ£¬Ìí¼Óһϣº
1.VCµÄ»°£¬TOOLS-OPTION-DIRECTORY-INCLUDE:Ìí¼ÓÄãµÄ·¾¶
2.LINUX,UNIXÏ£¬Ò»°ãÔÚmakefileÖÐÌí¼ÓÄãµÄ·¾¶¼´¿É
ÔÚ°üº¬mysql.h֮ǰ°üº¬my_global.h¡£
ÎÒÊÇÓÃvs2005¿ª·¢µÄ°¡¡£ÒªÈçºÎÌí¼ÓÄØ£¿¶øÇÒÎÒÏÖÔÚÖ»ÓÐmysql.hÎļþ¡£mysql.hÄÚ²¿µÄincludeÎļþÎÒ¶¼Ã»ÓС£ÄÇЩÊDz»ÊÇÒªÔÙÈ¥µ¥¶ÀÏÂÔØÄØ£¿»¹ÊÇÀà¿âÀï±¾À´¾ÍÓУ¿
{
Ïà¹ØÎÊ´ð£º
ÓÃc/c++¶¨Î»É¾³ýÒ»ÐеÄÎÊÌâ¡£
ÎÊÌâ±³¾°£º
ËùÐèÊý¾ÝÏ൱´ó¡£aÓëbÎļþ¾ùΪһ×éÎļþ£¨a1£¬a2¡£¬b1£¬b2¡£©£¬aÎļþÓÐ×î´óÊý¾ÝÐÐÊý£¨Èç5000£©£¬ÒÔÐеÄÐÎʽ£¬´ÓaÎļþÖжÁÈ¡Êý¾Ý£¬½«aÖв»ÄÜ´¦ÀíµÄÊý¾Ý·ÅÔÚbÎ ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ
Ö§³Ö£¬¼ì² ......