MySQL创建表格

创建user表

创建语句：

mysql> create table user(id int unsigned auto_increment  primary key, name varchar(10));Query OK, 0 rows affected (0.00 sec)

结果：

mysql> desc user;+-------+------------------+------+-----+---------+----------------+| Field | Type             | Null | Key | Default | Extra          |+-------+------------------+------+-----+---------+----------------+| id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment || name  | varchar(10)      | YES  |     | NULL    |                |+-------+------------------+------+-----+---------+----------------+2 rows in set (0.00 sec)