Mysql C代码示例

编译：

 g++ -o m sql.cpp -I /usr/include/mysql -L/usr/lib64/mysql -l mysqlclient -lpthread -lstdc++ -ldl -lrt

cpp代码：

#include <stdio.h>
#include <mysql.h>
#include <string.h>
int main(int argc, const char *argv[])
{
    MYSQL           mysql;
    MYSQL_RES       *res = NULL;
    MYSQL_ROW       row;
    char            *query_str = NULL;
    int             rc, i, fields;
    int             rows;
    if (NULL == mysql_init(&mysql)) {
        printf("mysql_init(): %s\n", mysql_error(&mysql));
        return -1;
    }
    if (NULL == mysql_real_connect(&mysql,
                "localhost",
                "root",
                "passwd",
                "dbname",
                0,
                NULL,
                0)) {
        printf("mysql_real_connect(): %s\n", mysql_error(&mysql));
        return -1;
    }
    printf("1. Connected MySQL successful! \n");
    query_str = "select * from t_user";
    rc = mysql_real_query(&mysql, query_str, strlen(query_str));
    if (0 != rc) {
        printf("mysql_real_query(): %s\n", mysql_error(&mysql));
        return -1;
    }
    res = mysql_store_result(&mysql);
    if (NULL == res) {
         printf("mysql_restore_result(): %s\n", mysql_error(&mysql));
         return -1;
    }
    rows = mysql_num_rows(res);
    printf("The total rows is: %d\n", rows);
    fields = mysql_num_fields(res);
    printf("The total fields is: %d\n", fields);
    while ((row = mysql_fetch_row(res))) {
        for (i = 0; i < fields; i++) {
            printf("%s\t", row[i]);

        }

        printf("\n");
    }
    mysql_close(&mysql);
    return 0;
}

插入可以参考：

res=mysql_query(&my_con,"INSERT INTO telephone (Name,Age,Gender,TEL) VALUES('Emma',20,'Female','10086')");
if(!res)
{
       printf("Inserted %lu rows\n",(unsigned long)mysql_affected_rows(&my_con));
}else
{
       fprintf(stderr,"Insert error %d: %s\n",mysql_errno(&my_con),mysql_error(&my_con));

}

mysql的函数可以参考：https://blog.csdn.net/lihaidong1991/article/details/79388871

mysql存储过程的C调用参考：https://www.cnblogs.com/cy163/archive/2008/10/16/1312277.html

这里抄几行：

5.3、调用存储过程

       //call

       strcpy(query,"call querystudent (1,@ret,@ out_name,@ out_age)");

       printf("query sql=[%s]\n",query);

    ret= mysql_real_query(&mysql,query,(unsigned int)strlen(query));

5.4、查询结果集并保存

mysql_query(&mysql, "SELECT @ret,@ out_name,@ out_age ");

 

       //get result

       if (ret)

    {

              printf("Error exec query: %s\n",mysql_error(&mysql));

    }

    else

       {

              printf("[%s] exec...\n", query);

    }

 

       results = mysql_store_result(&mysql);

5.5、获取查询结果

while((record = mysql_fetch_row(results))) {

              printf("[%s]-[%s]-[%s]\n", record[0], record[1],record[2]);

       }

一般存储过程只会有一行的返回结果，^_^.