简单讲一下C语言连接MySQL数据库

来源：互联网发布：股票赢家软件编辑：程序博客网时间：2024/05/30 19:35

1.首先你得将MySQL安装上
apt-get install mysql-server
(mysql -uroot -p 登陆测试)

2.安装链接库
apt-get install libmysqlclient-dev

3.进行数据库的创建,例如:
create table t1(a int, name varchar(10));
insert into t1 values(1,"Jack");
insert into t1 values(2,"Smith");
insert into t1 values(3,"Bruce");

4.进行c语言代码的编写
#include <stdio.h>
#include <stdlib.h>

#include "mysql.h"

int main()
{
   MYSQL m_conn;
   int ret;

   mysql_init(&m_conn);
   if(mysql_real_connect(&m_conn, "localhost","root","******","Jack",0,NULL,0))
   {
//insert
printf("coneect mysql successful");
ret = mysql_query(&m_conn, "insert into t1 values(10,'Tony')");
if(!res)
{
     printf("insert %lu rows\n",(unsigned long)mysql_affected_rows(&m_conn));
}
else
{
     printf("insert error\n");
}

//delete
char* deleteData = "delete from t1 where a=3";
        res = mysql_real_query(&m_conn, deleteData,(unsigned int)strlen(deleteData));
        if(!res)
{
    printf("delete successful");
}
else
{
    printf("delete error\n");
}

//show all data
        MYSQL_ROW row;
MYSQL_RES *res;
int t;
char *allData = "select * from t1";
res = mysql_real_query(&m_conn, allData, (unsigned int)strlen(allData));

res = mysql_store_result(&m_conn); //
    while(row=mysql_fetch_row(res))
{
    for(t=0; t<mysql_num_fields(res); t++)
    {
  printf("%s\t",row[t]);
     }
    printf("\n");
}

mysql_close(&m_conn);
    }
   return 0;
}

4.编译时注意加上链接库啥的
gcc -I/usr/include/mysql mysqlTest.c -L/usr/lib/mysql -lmysqlclient -o mysqlTest
./mysqlTest

0 0