先贴出我的代码:mysql.cpp
今天在编译的时候遇到了几个问题,在百度上搜了大半天,中间还换了别的mysql版本试了下,最后在晚上找出原因了。
#include<stdio.h>
#include <string.h>
#include <mysql/mysql.h>
int main()
{
MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW row;
mysql_init(&mysql);
if(!mysql_real_connect(&mysql,"127.0.0.1","root","123456","mysql",3306,0,0)){
printf("mysql connect failed!\n");
}else{
printf("mysql connect success!\n");
}
if(mysql_real_query(&mysql,"select * from user",(unsigned long)strlen("select * from user"))){
printf("mysql query failed!\n");
}else{
printf("mysql query success!\n");
}
res=mysql_store_result(&mysql);
if(NULL==res){
printf("mysql store failed!\n");
}else{
printf("mysql store success!\n");
}
int rows=mysql_num_rows(res);
int fields=mysql_num_fields(res);
printf("共%d条记录,每条记录%d个字段\n",rows,fields);
FILE *fp;
fp=fopen("user.txt","w");
while(row=mysql_fetch_row(res))
{
for(int i=0;i<fields;i++){
fprintf(fp,"%s\t",row[i]);
}
fprintf(fp,"\n");
fprintf(fp,"\n");
}
fclose(fp);
mysql_free_result(res);
mysql_close(&mysql);
return 0;
}
今天在编译的时候遇到了几个问题,在百度上搜了大半天,中间还换了别的mysql版本试了下,最后在晚上找出原因了。
报错:致命错误,没有那个文件
解决方法:在gcc编译时需要链接库
gcc -o mysql mysql.cpp -I/usr/include/mysql -L/usr/lib64/mysql -lmysqlclient
一般情况下不需要中间的-L/usr/lib64/mysql的,因为我的是x86_64位系统,不加这句会提示在/usr/lib/lb中找不到lmysqlclient,其实应该在lib64中