MySQL入门必看表的建立代码3例

CREATE TABLE XS(xuehao char(6) NOT NULL PRIMARY KEY,xinmin char(8) NOT NULL,zhuanyemin char(10) NOT NULL,xinbie tinyint(1) NOT NULL DEFAULT 1,csrq date NOT NULL,zxf tinyint NULL,zp blob NULL,bz text NULL)character set=gb2312;Query OK, 0 rows affected (0.28 sec)

mysql> DESC XS;+------------+------------+------+-----+---------+-------+| Field      | Type       | Null | Key | Default | Extra |+------------+------------+------+-----+---------+-------+| xuehao     | char(6)    | NO   | PRI | NULL    |       || xinmin     | char(8)    | NO   |     | NULL    |       || zhuanyemin | char(10)   | NO   |     | NULL    |       || xinbie     | tinyint(1) | NO   |     | 1       |       || csrq       | date       | NO   |     | NULL    |       || zxf        | tinyint(4) | YES  |     | NULL    |       || zp         | blob       | YES  |     | NULL    |       || bz         | text       | YES  |     | NULL    |       |+------------+------------+------+-----+---------+-------+8 rows in set (0.02 sec)