数据库:zhang
表:people
表字段:name(varchar)、age(int)、sex(varchar)、grade(varchar)
1、插入数据
#include <stdio.h>
#include <stdlib.h>
#include <mysql.h>
int main()
{
MYSQL mysql;
MYSQL_RES *res = NULL;
MYSQL_ROW row;
char query_str[200];
int rc, i, fields;
int rows;
if (mysql_init(&mysql) == NULL) //分配和初始化MYSQL对象
{
printf("mysql_init(): %s\n", mysql_error(&mysql));
return -1;
}
/**尝试与运行在主机上的MySQL数据库引擎建立连接
* localhost为数据库连接的主机
* root为mysql用户名
* 123456为mysql的密码
* zhang为连接到的数据库名称
* 后面为默认参数
*/
if (mysql_real_connect(&mysql,"localhost","root","123456","zhang",0,NULL,0) == NULL)
{
printf("mysql_real_connect(): %s\n", mysql_error(&mysql));
return -1;
}
printf("Connected MySQL successful! \n");
//往表中插入数据
//sprintf(query_str, "insert into people values ('FFFF', 30, 'woman', '85')");
//往表中插入数据,数据为变量的写法
sprintf(query_str, "insert into people values ('%s', '%d', '%s', '%s')", "FFFF", 30, "woman", "85");
rc = mysql_real_query(&mysql, query_str, strlen(query_str));
if (0 != rc) {
printf("mysql_real_query(): %s\n", mysql_error(&mysql));
return -1;
}
sprintf(query_str, "select * from people");
rc =