mysql> create table student(
-> id int,
-> name varchar(10),
-> gender char(1),
-> birthday date,
-> score double(5,2),
-> email varchar(64),
-> status tinyint#最后一行不用加逗号。
-> );
Query OK, 0 rows affected (0.02 sec)
mysql> desc student;#查看表格
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| name | varchar(10) | YES | | NULL | |
| gender | char(1) | YES | | NULL | |
| birthday | date | YES | | NULL | |
| score | double(5,2) | YES | | NULL | |
| email | varchar(64) | YES | | NULL | |
| status | tinyint(4) | YES | | NULL | |
+----------+-------------+------+-----+---------+-------+
7 rows in set (0.00 sec)
