显示创建表的语句
语法:
show create table 表名
mysql> use bs_ky_blog
Database changed
mysql> show tables;
+----------------------+
| Tables_in_bs_ky_blog
+----------------------+
| bg_category
| bg_post
| bg_user
+----------------------+
3 rows in set (0.00 sec)
mysql> show create table bg_post;
显示表结构:
语法:
describe 表名
mysql> describe bg_post;
删除表
语法:
drop table [ if exists] 表名1,表名2...
mysql> drop table stu1;
Query OK, 0 rows affected (0.03 sec)
mysql> drop table if exists stu;
Query OK, 0 rows affected (0.01 sec)