C语言调用mysql数据库API实现简单的mysql客户端的功能

最新推荐文章于 2021-01-21 17:44:52 发布

readyao

最新推荐文章于 2021-01-21 17:44:52 发布

阅读量1.2k

点赞数

分类专栏：数据库-MySql 文章标签： mysql客户端

本文链接：https://blog.csdn.net/Linux_ever/article/details/50654396

版权

输入可执行程序的名字和数据库的名字进入该程序，比如 ./mysql_test3 ch11

(ch11是数据库的名字)

下面是输入命令的输出结果：

mysql_init ok...
mysql_real_connect ok...
mysql> show tables;
-------------------------------------------------------------
Tables_in_ch11 
---------------------------------------------------------------
food 
medicine 
product 
t 
t1 
t2 
teacher 
mysql> create table tttttt(id int, name varchar(20));
create ok
mysql> show tables;
-------------------------------------------------------------
Tables_in_ch11 
---------------------------------------------------------------
food 
medicine 
product 
t 
t1 
t2 
teacher 
tttttt 
mysql> desc tttttt;
-------------------------------------------------------------
Field   Type    Null    Key     Default         Extra 
---------------------------------------------------------------
id      int(11)         YES             (null)   
name    varchar(20)     YES             (null)   
mysql> insert into tttttt values(1, "linux_ever");
mysql> select * from tttttt;
-------------------------------------------------------------
id      name 
---------------------------------------------------------------
1       linux_ever 
mysql> drop table tttttt;
drop ok
mysql> show tables;
--