MySql DDL 之 TABLE

1）在数据库中创建一个数据表
样例：
CREATE TABLE IF NOT EXISTS table_name (
field1 datatype,
field2 datatype,
field3 datatype
)[CHARACTER SET 字符集 COLLATE 校对规则];
实战：
2）选择相应的数据库
eg: use databases_name;
3）查看当前数据库
SELECT DATABASE();
4）创建表
mysql> CREATE TABLE IF NOT EXISTS user(
-> id int,
-> name varchar(20),
-> password varchar(20),
-> birthday date
-> );
Query OK, 0 rows affected (0.01 sec)
mysql>
mysql>
mysql> SHOW TABLES;
±----------------+
| Tables_in_mydb1 |
±----------------+
| user |
±----------------+
1 row in set (0.00 sec)
5）查看数据库中的表
SHOW TABLES;
实战（创建一个员工表）：
mysql> CREATE TABLE IF NOT EXISTS employee(
-> id int,
-> name varchar(20),
-> gender varchar(20),
-> birthday date,
-> entry_date date,
-> job varchar(20),
-> salary float(8,2),
-> resume text
-> );
Query OK, 0 rows affected (0.02 sec)
6）查看数据库中已经创建好的表
mysql> SHOW TABLES;
±----------------+
| Tables_in_mydb1 |
±----------------+
| employee |
| user |
±----------------+
2 rows in set (0.00 sec)
7）查看新建表中的字段内容
mysql> SHOW CREATE TABLE USER;
±------±-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
±------±-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| USER | CREATE TABLE user (
id int(11) DEFAULT NULL,
name varchar(20) DEFAULT NULL,
password varchar(20) DEFAULT NULL,
birthday date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
±------±-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

来源：
http://www.360doc.com/content/20/0123/21/57605256_887628439.shtml