C语言操作mysql增删改查

数据库：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 =