C语言MySQL 基础操作（添加、查询和删除）

MySQL 之数据添加

/*练习mysql数据库的查询*/ 
#include <stdio.h> 
#include <string.h> 
#include "/usr/local/mysql/include/mysql.h" 
 
 
int main() 
{ 
	MYSQL mysql; 
	MYSQL_RES *res; 
	MYSQL_ROW row; 
	char *query; 
	int flag, t; 
	mysql_init(&mysql); 
	if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "test", 0, NULL, 0)) { 
		printf("Failed to connect to Mysql!\n"); 
		return 0; 
	}else { 
		printf("Connected to Mysql successfully!\n"); 
	} 
	query = "select * from student"; 
	/*查询，成功则返回0*/ 
	flag = mysql_real_query(&mysql, query, (unsigned int)strlen(query)); 
	if(flag) { 
		printf("Query failed!\n"); 
		return 0; 
	}else { 
		printf("[%s] made...\n", query); 
	} 
 
 
	/*mysql_store_result讲全部的查询结果读取到客户端*/ 
	res = mysql_store_result(&mysql); 
	/*mysql_fetch_row检索结果集的下一行*/ 
	while(row = mysql_fetch_row(res)) { 
		/*mysql_num_fields返回结果集中的字段数目*/ 
		for(t=0; t<mysql_num_fields(res); t++) 
		{ 
			printf("%s\t", row[t]); 
		} 
		printf("\n"); 
	} 
	mysql_close(&mysql); 
	return 0; 
} 

编译：gcc -o mysqlselect -I /usr/local/include/mysql/ -L /usr/local/mysql/lib -lmysqlclient mysqlselect.c

执行：./mysqlselect

结果展示：

[root@iZ94qvmp90hZ c]# gcc -o mysqlselect -I /usr/local/include/mysql/ -L /usr/local/mysql/lib -lmysqlclient mysqlselect.c 
[root@iZ94qvmp90hZ c]# ls -a 
.   a.out       hello.c      mysqlselect.c  testmysql.c 
..  datatype.c  mysqlselect  testmysql      testmysql.o 
[root@iZ94qvmp90hZ c]# ./mysqlselect 
Connected to Mysql successfully! 
[select * from student] made... 
1	1	 
2	2	 
3	3	 

MySQL 之插入

/*练习mysql数据库的数据添加*/   
#include <stdio.h>   
#include <string.h>   
#include "/usr/local/mysql/include/mysql.h"   
   
   
int main()   
{   
    MYSQL mysql;   
    MYSQL_RES *res;   
    MYSQL_ROW row;   
    char *query;   
    int flag, t;   
    mysql_init(&mysql);   
    if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "test", 0, NULL, 0)) {   
        printf("Failed to connect to Mysql!\n");   
        return 0;   
    }else {   
        printf("Connected to Mysql successfully!\n");   
    }   
    query = "insert into student(id,name) values(4,'5')";   
    /*插入，成功则返回0*/   
    flag = mysql_real_query(&mysql, query, (unsigned int)strlen(query));   
    if(flag) {   
        printf("Insert data failure!\n");   
        return 0;   
    }else {   
        printf("Insert data success!\n");   
    }   
   
   
    mysql_close(&mysql);   
    return 0;   
}   

编译：gcc -o mysqlinsert -I /usr/local/include/mysql/ -L /usr/local/mysql/lib -lmysqlclient mysqlinsert.c

执行：./mysqlinsert

结果展示：

[root@iZ94qvmp90hZ c]# gcc -o mysqlinsert -I /usr/local/include/mysql/ -L /usr/local/mysql/lib -lmysqlclient mysqlinsert.c 
[root@iZ94qvmp90hZ c]# ls -a 
.   a.out       hello.c      mysqlinsert.c  mysqlselect.c  testmysql.c 
..  datatype.c  mysqlinsert  mysqlselect    testmysql      testmysql.o 
[root@iZ94qvmp90hZ c]# ./mysqlinsert 
Connected to Mysql successfully! 
Insert data success! 

MySQL 之删除

/*练习mysql数据库的删除*/   
#include <stdio.h>   
#include <string.h>   
#include "/usr/local/mysql/include/mysql.h"   
   
int main()   
{   
    MYSQL mysql;   
    MYSQL_RES *res;   
    MYSQL_ROW row;   
    char *query;   
    int flag, t;   
    mysql_init(&mysql);   
    if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "test", 0, NULL, 0)) {   
        printf("Failed to connect to Mysql!\n");   
        return 0;   
    }else {   
        printf("Connected to Mysql successfully!\n");   
    }   
    query = "delete from student  where log_id=1";   
    /*删除，成功则返回0*/   
    flag = mysql_real_query(&mysql, query, (unsigned int)strlen(query));   
    if(flag) {   
        printf("Delete data failure!\n");   
        return 0;   
    }else {   
        printf("Delete data success!\n");   
    }   
   
    mysql_close(&mysql);   
    return 0;   
}   

编译：gcc -o mysqldelete -I /usr/local/include/mysql/ -L /usr/local/mysql/lib -lmysqlclient mysqldelete.c

执行：./mysqldelete

执行结果：

[root@iZ94qvmp90hZ c]# gcc -o mysqldelete -I /usr/local/include/mysql/ -L /usr/local/mysql/lib -lmysqlclient mysqldelete.c 
[root@iZ94qvmp90hZ c]# ./mysqldelete 
Connected to Mysql successfully! 
Delete data success!