论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2011-11-30 15:05 |只看该作者 |倒序浏览

本帖最后由 canigreen 于 2011-11-30 15:11 编辑

编译参数为：gcc -o my mysql.c -I /usr/local/mysql/include/mysql/ -L /usr/local/mysql/lib/mysql/ -lmysqlclient
编译的时候会出现错误，确认过，指针类型是一样的，但不知道为什么会出现错误，C语言代码在后面：

[root@XXXX work]# gcc -o my mysql.c -I /usr/local/mysql/include/mysql/ -L /usr/local/mysql/lib/mysql/ -lmysqlclient
mysql.c: In function ‘main’:
mysql.c:40: warning: assignment from incompatible pointer type

复制代码

执行输入会出来非常多的其它信息，不知道怎么回事，还希望在行的人能指点一二，感激不尽：
执行程序后输出结果如下，除了前三段记录是要的，其它的都是多出来的，不知道是从哪儿来的，C语言代码在后面：

Connected...
mysql_num_fields is 5
2 1 feeds 5d8745cd7e10fa00731a1bed9759ab1afed18437 2011-11-22 00:08:56 oXic</ord
4 3 feeds ea5f71be6fdc143c790f72248799da5f1a22e0d7 2011-11-22 00:16:29 o
6 4 feeds a6a2400c7efb15111352c1912eb3f43caadf56b5 2011-11-25 19:12:56 tion>
<collation name="geostd8_general_ci" id="92" order="Georgian" flag="primary"/>
<collation name="geostd8_bin" id="93" order="Binary" flag="binary"/>
</charset>
<charset name="binary">
<description>Binary pseudo charset</description>
<collation name="binary" id="63" order="Binary">
<flag>primary</flag>
<flag>compiled</flag>
</collation>
</charset>
<charset name="cp932">
<family>Japanese</family>
<description>SJIS for Windows Japanese</description>
<alias>ms_cp932</alias>
<alias>sjis_cp932</alias>
<alias>sjis_ms</alias>
<collation name="cp932_japanese_ci" id="95" order="Japanese">
<flag>primary</flag>
<flag>compiled</flag>
</collation>
<collation name="cp932_bin" id="96" order="Binary">
<flag>binary</flag>
<flag>compiled</flag>
</collation>
</charset>
<charset name="eucjpms">
<family>Japanese</family>
<description>UJIS for Windows Japanese</description>
<alias>eucjpms</alias>
<alias>eucJP_ms</alias>
<alias>ujis_ms</alias>
<alias>ujis_cp932</alias>
<collation name="eucjpms_japanese_ci" id="97" order="Japanese">
<flag>primary</flag>
<flag>compiled</flag>
</collation>
<collation name="eucjpms_bin" id="98" order="Japanese">
<flag>binary</flag>
<flag>compiled</flag>
</collation>
</charset>
</charsets>
The number of no is :18
代码如下：

复制代码

#include "stdio.h"
#include "stdlib.h"
#include "mysql.h"
#include "string.h"
int main()
{
MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW *row;
/* MYSQL_FIELD *field; */
int j;
int no;
char *query;
int r,t;
/* Connect to mysql */
mysql_init(&mysql);
if(!mysql_real_connect(&mysql,"localhost","root","1352456","redminedb",0,NULL,0))
{
printf("Error connecting to databases:\n%si\n",mysql_error(&mysql));
return 1;
}
else
printf("Connected...\n");
query="select * from tokens";
t=mysql_real_query(&mysql,query,(unsigned int)strlen(query));
if(t)
{
printf("Error making query:%s\n",mysql_error(&mysql));
return 1;
}
res=mysql_store_result(&mysql);
j=mysql_num_fields(res);
no=0;
printf("mysql_num_fields is %d\n",j);
while(row=mysql_fetch_row(res))
{
for(t=0;t<=j;t++)
{
printf("%s\t",row[t]);
no++;
}
printf("\n");
}
printf("The number of no is :%d\n",no);
mysql_close(&mysql);
return 0;
}

复制代码

mysql, 异常

文库|博客

canigreen

白手起家

论坛徽章:: 0

2楼 [报告]

发表于 2011-11-30 15:15 |只看该作者

[root@xxxx work]# ./my
Connected...
mysql_num_fields is 5
2 1 feeds 5d8745cd7e10fa00731a1bed9759ab1afed18437 2011-11-22 00:08:56
4 3 feeds ea5f71be6fdc143c790f72248799da5f1a22e0d7 2011-11-22 00:16:29
6 4 feeds a6a2400c7efb15111352c1912eb3f43caadf56b5 2011-11-25 19:12:56
The number of no is :15

复制代码

测试出来了，原来是数组越界了，不好意思，多了一个“=”号
但是编译的时候，还是会提示出错，希望有经验的人指导一下，谢谢：

[root@xxxx work]# gcc -o my mysql.c -I /usr/local/mysql/include/mysql/ -L /usr/local/mysql/lib/mysql/ -lmysqlclient
mysql.c: In function ‘main’:
mysql.c:40: warning: assignment from incompatible pointer type

复制代码

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

jeung

丰衣足食

论坛徽章:: 0

3楼 [报告]

发表于 2011-11-30 15:31 |只看该作者

回复 2# canigreen

再加个-lz试试
手册上这么写的

CFG=/usr/local/mysql/bin/mysql_config
sh -c "gcc -o progname `$CFG --cflags` progname.c `$CFG --libs`"

复制代码

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

canigreen

白手起家

论坛徽章:: 0

4楼 [报告]

发表于 2011-11-30 15:38 |只看该作者

回复 3# jeung

感谢您的回复，加了还是一样的丫：

[root@xxxx work]# gcc -o my mysql.c -I /usr/local/mysql/include/mysql/ -L /usr/local/mysql/lib/mysql/ -lmysqlclient -lz
mysql.c: In function ‘main’:
mysql.c:41: warning: assignment from incompatible pointer type
[root@xxxx work]# CFG=/usr/local/mysql/bin/mysql_config
[root@xxxx work]# sh -c "gcc -o progname `$CFG --cflags` progname.c `$CFG --libs`"
gcc: progname.c: No such file or directory
[root@xxxx work]# sh -c "gcc -o progname `$CFG --cflags` mysql.c `$CFG --libs`"
mysql.c: In function ‘main’:
mysql.c:41: warning: assignment from incompatible pointer type
[root@xxxx work]# sh -c "gcc -o progname `$CFG --cflags` mysql.c `$CFG --libs` -lz"
mysql.c: In function ‘main’:
mysql.c:41: warning: assignment from incompatible pointer type
[root@xxxx work]# sh -c "gcc -o progname `$CFG --cflags` mysql.c `$CFG --libs` -lz -lmysqlclient"
mysql.c: In function ‘main’:
mysql.c:41: warning: assignment from incompatible pointer type
[root@xxxx work]#