[c/c++] c 操作mysql数据库 - bluefrog - 博客园
[c/c++] c 操作mysql数据库
输出mysql版本
1 #include <my_global.h> 2 #include <mysql.h> 3 #include <stdlib.h> 4 #include <stdio.h> 5 6 int main(int argc,char **argv) { 7 printf("mysql client version:%s\n",mysql_get_client_info()); 8 return 0; 9 }编译
gcc version.c -o version $(mysql_config --cflags --libs)结果
$ ./version mysql client version:5.1.63
创建DB
1 #include <my_global.h> 2 #include <mysql.h> 3 #include <stdio.h> 4 #include <stdlib.h> 5 6 int main(int argc,char **argv) { 7 MYSQL *conn; 8 9 conn = mysql_init(NULL); 10 if(conn == NULL) { 11 printf("Error %u:%s\n",mysql_errno(conn),mysql_error(conn)); 12 exit(EXIT_FAILURE); 13 } 14 15 // host user password 16 if(mysql_real_connect(conn,"localhost","root","admin",NULL,0,NULL,0) == NULL) { 17 printf("Error %u:%s\n",mysql_errno(conn),mysql_error(conn)); 18 exit(EXIT_FAILURE); 19 } 20 21 char* sql = "CREATE DATABASE IF NOT EXISTS test_cdb"; 22 //char* sql = "CREATE database test_cdb"; 23 if(mysql_query(conn,sql)) { 24 printf("Error %u:%s\n",mysql_errno(conn),mysql_error(conn)); 25 exit(EXIT_FAILURE); 26 } 27 28 mysql_close(conn); 29 30 exit(EXIT_SUCCESS); 31 }创建Table
1 #include <my_global.h> 2 #include <mysql.h> 3 #include <stdio.h> 4 #include <stdlib.h> 5 6 int main(int argc,char **argv) { 7 MYSQL *conn; 8 9 conn = mysql_init(NULL); 10 // host user password dbname 11 if(mysql_real_connect(conn,"localhost","root","admin","test_cdb",0,NULL,0) == NULL) { 12 printf("Error %u:%s",mysql_errno(conn),mysql_error(conn)); 13 exit(EXIT_FAILURE); 14 } 15 16 char* sql = "CREATE TABLE IF NOT EXISTS test(name VARCHAR(25));"; 17 if(mysql_query(conn,sql)) { 18 printf("Error %u:%s",mysql_errno(conn),mysql_error(conn)); 19 exit(EXIT_FAILURE); 20 } 21 sql = "INSERT INTO test VALUES('test1')"; 22 if(mysql_query(conn,sql)) { 23 printf("Error %u:%s",mysql_errno(conn),mysql_error(conn)); 24 exit(EXIT_FAILURE); 25 } 26 27 mysql_close(conn); 28 exit(EXIT_SUCCESS); 29 }查询
1 #include <my_global.h> 2 #include <mysql.h> 3 #include <stdio.h> 4 #include <stdlib.h> 5 6 int main(int argc,char **argv) { 7 MYSQL *conn; 8 MYSQL_RES *result; 9 MYSQL_ROW row; 10 MYSQL_FIELD *field; 11 12 int num_fields; 13 int i; 14 int j = 0; 15 16 conn = mysql_init(NULL); 17 if(mysql_real_connect(conn,"localhost","root","admin","test_cdb",0,NULL,0) == NULL) { 18 printf("Error %u:%s",mysql_errno(conn),mysql_error(conn)); 19 exit(EXIT_FAILURE); 20 } 21 22 char* sql = "SELECT * FROM test"; 23 if(mysql_query(conn,sql)) { 24 printf("Error %u:%s",mysql_errno(conn),mysql_error(conn)); 25 exit(EXIT_FAILURE); 26 } 27 result = mysql_store_result(conn); 28 num_fields = mysql_num_fields(result); // 记录项数 29 30 while((row = mysql_fetch_row(result))) { 31 // for(int i = 0; i < num_fields;i++) { // allowed c99 mode 32 for(i = 0; i < num_fields;i++) { 33 if(j == 0) { 34 // struct ? 35 while(field = mysql_fetch_field(result)) { 36 printf("%s ",field->name); 37 } 38 printf("\n"); 39 } 40 printf("%s ",row[i]? row[i] : "NULL"); 41 } 42 printf("\n"); 43 j++; 44 } 45 mysql_free_result(result); 46 47 mysql_close(conn); 48 exit(EXIT_SUCCESS); 49 }
