|
|
看了一些老帖子，但还是没能搞定，总是提示：
undefined reference to '_mysql_init'
undefined reference to '_mysql_real_connection'
undefined reference to '_mysql_error'
undefined reference to '_mysql_real_query'
......
等等
我用的环境是：
WINDOWS XP SP2
cygwin
gcc3.4.4
MYSQL是windows版的5.0
用JAVA工作正常。
我编译是：
gcc -o main.exe main.c -I /usr/include/mysql -lmysqlclient
我已经把mysql下的include文件COPY到了/usr/include/mysql中
lib/opt下面的mysqlclient.lib也COPY到了/usr/lib下面。
请大家给点意见。多谢！
下面是源代码
源代码是COPY别的帖子的
#include <mysql/mysql.h>
#include <stdio.h>
int main(){
MYSQL *mysql;
MYSQL_RES *res;
MYSQL_ROW row;
char *query;
int t,r;
mysql_init(mysql);
if (!mysql_real_connect(mysql,"localhost","root",
"loveyou","spider",0,NULL,0))
{
printf( "Error connecting to database: %s\n",mysql_error(mysql));
}
else printf("Connected...\n");
query="select * from spider_work_unsite";
t=mysql_real_query(mysql,query,(unsigned int) strlen(query));
if (t)
{
printf("Error making query: %s\n",
mysql_error(mysql));
}
else printf("Query made...\n");
res=mysql_use_result(mysql);
for(r=0;r<=mysql_field_count(mysql);r++){
row=mysql_fetch_row(res);
if(row<0) break;
for(t=0;t<mysql_num_fields(res);t++){
printf("%s ",row[t]);
}
printf("\n");
}
mysql_close(mysql);
}
|
|
发表于 2020-1-6 17:30:01