MySQL之資料表的插入內容 空與非空（六）

標籤：sign   0.00   內容   err   char   ror   cte   ann   creat   

NULL與NOT NULL

mysql> CREATE TABLE tb2(
-> usename VARCHAR(20) NOT NULL,
-> age TINYINT UNSIGNED NULL(可以為空白)
-> );
Query OK, 0 rows affected (0.06 sec)

mysql> SHOW COLUMNS FROM tb2;
+---------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------------------+------+-----+---------+-------+
| usename | varchar(20) | NO | | NULL | |
| age | tinyint(3) unsigned | YES | | NULL | |
+---------+---------------------+------+-----+---------+-------+
2 rows in set (0.01 sec)

mysql>
mysql> INSERT tb2 VALUES(‘Tom‘, NULL);
Query OK, 1 row affected (0.03 sec)

mysql> SELECT * FROM tb2;
+---------+------+
| usename | age |
+---------+------+
| Tom | NULL |
+---------+------+
1 row in set (0.00 sec)

mysql> INSERT tb2 VALUES(NULL, 26);
ERROR 1048 (23000): Column ‘usename‘ cannot be null
mysql>

MySQL之資料表的插入內容 空與非空（六）