创建表

create table 表名

create table if not exists 表名

mysql> create database company;
Query OK, 1 row affected (0.00 sec)
mysql> use company;
Database changed
mysql> create table if not exists t_dept(
-> deptno int,
-> dname varchar(20),
-> loc varchar(40));
Query OK, 0 rows affected (0.20 sec)
mysql> show tables;
+-------------------+
/ Tables_in_company /
+-------------------+
/ t_dept /
+-------------------+
1 row in set (0.00 sec)
mysql>

显示当前库下的所有表