MySQL编程删除某个元组

mysql> use test;
Database changed
mysql> select * from student;
+------+------+
| Id   | name |
+------+------+
|   29 | Mike |
|   12 | Lili |
+------+------+
2 rows in set (0.00 sec)

mysql> quit
Bye
[root@localhost ~]#

源文件mysql.c如下：

 1 #include <stdio.h>
 2 #include <stdlib.h>
 3 #include <string.h>
 4 #include <unistd.h>
 5 #include <sys/types.h>
 6 #include <dirent.h>
 7 #include "/usr/local/mysql/include/mysql.h"
 8 
 9 const char* host = "127.0.0.1";
10 MYSQL* mysql;
11 const char* user = "root";
12 const char* password = "";
13 
14 int main(int argc ,char **argv)
15 {
16         int t, r;
17 
18         mysql = mysql_init(mysql);
19         mysql = mysql_real_connect(mysql, host, user, password, "test", 0, NULL, 0);
20 
21         if (!mysql)
22         {
23                 perror("MySQL connect error!\n");
24                 return EXIT_FAILURE;
25         }
26 
27         if (mysql_query(mysql, "delete from student where Id=29"))  // 删除Id=29的那个元组
28         {
29                 perror("MySQL query error!\n");
30                 return EXIT_FAILURE;
31         }
32 
33         mysql_close(mysql);
34 
35         return 0;
36 }

[root@localhost ~]# gcc mysql.c -g -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient
[root@localhost ~]# ./a.out

mysql> use test;
Database changed
mysql> select * from student;
+------+------+
| Id   | name |
+------+------+
|   12 | Lili |
+------+------+
1 row in set (0.00 sec)

mysql> quit
Bye
[root@localhost ~]#