MySQL使用入门

最新推荐文章于 2025-07-03 20:56:03 发布

原创最新推荐文章于 2025-07-03 20:56:03 发布 · 377 阅读

CC 4.0 BY-SA版权

create table students
(
    id int unsigned not null auto_increment primary key,
    name char(8) not null,
    sex char(4) not null,
    age tinyint unsigned not null,
    tel char(13) null default "-"
);

mysql> describe students;
+-------+---------------------+------+-----+---------+----------------+
| Field | Type                | Null | Key | Default | Extra          |
+-------+---------------------+------+-----+---------+----------------+
| id    | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| name  | char(8)             | NO   |     | NULL    |                |
| sex   | char(4)             | NO   |     | NULL    |                |
| age   | tinyint(3) unsigned | NO   |     | NULL    |                |
| tel   | char(13)            | YES  |     | -       |                |
+-------+---------------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

参考文献：

http://www.cnblogs.com/mr-wid/archive/2013/05/09/3068229.html