69,379
社区成员
发帖
与我相关
我的任务
分享
const char* MysqlHost = "localhost";
const char* MysqlUser = "root";
const char* MysqlPass = "";
const char* MysqlDB = "mysql";
const char* MysqlTable = "user";
//初始化mysql结构
MYSQL* mysql = mysql_init(NULL);
if (mysql == NULL)
{
fprintf(stderr,"init mysql failed!");
return -1;
}
//连接mysql数据库
mysql = mysql_real_connect(mysql, MysqlHost, MysqlUser, MysqlPass, MysqlDB, 0, NULL, 0);
if (mysql == NULL)
{
fprintf(stderr,"connect to mysql server failed!");
return -1;
}
//存放sql语句
char sql[4096];
sprintf(sql, "select * from %s")", MysqlTable);
//执行mysql语句
int r = mysql_query(mysql, sql);
if (r != 0)
{
fprintf(stderr,"sql query failed!%s", mysql_error(mysql));
}
//后面用fetch_row等函数得到结果,具体的去查手册。