输入可执行程序的名字和数据库的名字进入该程序,比如 ./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;
--