mysql> create table t_user(
-> id int,
-> username varchar(255),
-> password varchar(255) not null );
mysql> insert into t_user(id,username) values(1,‘wangwu’);
ERROR 1364 (HY000): Field ‘password’ doesn’t have a default value
±---------±-------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±---------±-------------±-----±----±--------±------+
| id | int | YES | | NULL | |
| username | varchar(255) | YES | | NULL | |
| password | varchar(255) | NO | | NULL | |
±---------±-------------±-----±----±--------±------+
mysql> insert into t_user(id,username,password) values(1,‘wangwu’,‘wsx’);
Query OK, 1 row affected (0.11 sec)