在新建表的时候,可以设置表内列的值是否为空,使用NULL 和NOT NULL
eg:创建表tb2,设置属性name 不允许为空,age 无符号可以为空
CREATE TABKE tb2(
name VARCHAR(20) NOT NULL,
age TINYINT UNSIGNED NULL
);
显示一下tb2的列,
SHOW COLUMNS FROM tb2;
+----------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------------------+------+-----+---------+-------+
| name | varchar(20) | NO | | NULL | |
| age | tinyint(3) unsigned | YES | | NULL | |
+----------+---------------------+------+-----+---------+-------+