VC6.0 向MySQL插入数据时 报错

Question

我的代码：
#include "stdio.h"

#include "Winsock2.h"
#include "mysql.h"
#include "iostream"
#include "string"
#define HOST_IP 127.0.0.1
#define HOST_PORT 3389
struct conn_info
{
char *host;
char *user;
char *password;
char *db;
};
MYSQL *mysql_conn_setup(conn_info con)
{
MYSQL *mysql = mysql_init(NULL);
if(!mysql_real_connect(mysql,con.host,con.user,con.password,con.db,8083,NULL,0))
{
printf("Connection error :%s/n",mysql_error(mysql));
exit(1);
}

return mysql;
}

MYSQL_RES*mysql_conn_sqlQuery(MYSQL*mysql,char*sql_Query)
{
if(mysql_query(mysql,sql_Query))
{
printf("MySQL query error:%s/n",mysql_error(mysql));
exit(1);
}
return mysql_use_result(mysql);
}

#pragma comment(lib,"libmySQL.lib")
void main()
{
MYSQL*conn;
MYSQL_RES*res;
MYSQL_ROW row;
char sql_query[100];
memset(sql_query,'\0',100);
sprintf(sql_query,"show tables");
struct conn_info info;
info.host = "localhost";
info.user = "root";
info.password = "";
info.db = "mysql";
conn = mysql_conn_setup(info);
res = mysql_conn_sqlQuery(conn,sql_query);
printf("mysql all tables: \n");
while ((row = mysql_fetch_row(res))!= NULL)
{
printf("%s \n",row[0]);
}
mysql_free_result(res);

    MYSQL *mysql = mysql_init(NULL);

    char sql[1024] ;
//  sql = /'INSERT INTO smart (id,times,message) VALUES('num2',20160889,'dhasjdhsjhda')/';
    sprintf(sql,"INSERT INTO smart (id,times,message) VALUES('num7',sysdate(),'d')");

    **if(mysql_query(mysql,sql))//此处报错**
    {
        //printf("fail");
    }



  mysql_close(conn);

}

---------------------------------错误信息----------------------------------
C:\Program Files (x86)\Microsoft Visual Studio\MyProjects\rrrrrr\rrrrrr.cpp(124) : error C2664: 'mysql_query' : cannot convert parameter 1 from 'struct st_mysql ** ' to 'struct st_mysql *'
Types pointed to are unrelated; conversion requires reinterpret_cast, C-style cast or function-style cast
执行 cl.exe 时出错.

Answer 1

把你的sql语句单独拿出来在数据库执行，看看能不能成功，
错误提示的是函数调用的参数类型不匹配

有需要可以参考：
MySQL insert用法详解 http://www.data.5helpyou.com/article421.html