指定字段的值不能为空
NOT NULL ---此字段值禁止为空
NULL ---默认值
CREATE TABLE tbl_name(
字段名称 字段类型 NOT NULL
);
mysql> CREATE TABLE testNNULL(-> id INT,-> username VARCHAR(20) NOT NULL-> );Query OK, 0 rows affected (0.11 sec)
mysql> INSERT testNNULL(id,username) VALUES(NULL,'AAA');mysql> INSERT testNNULL(username) VALUES('BBB');mysql> INSERT testNNULL(id) VALUES(11); --不给非空字段赋值时,会提示错误ERROR 1364 (HY000): Field 'username' doesn't have a default valuemysql> INSERT testNNULL(id,username) VALUES(11,NULL); --给给非空字段赋值NULL时,会提示错误ERROR 1048 (23000): Column 'username' cannot be nullmysql> SELECT * FROM testNNULL;+------+----------+| id | username |+------+----------+| NULL | AAA || NULL | BBB |+------+----------+2 rows in set (0.01 sec)