<span style="color: rgb(0, 0, 0);">mysql> insertintomytable(content) values('programmer');<br>Query OK, 1 row affected, 1 warning (0.00 sec)mysql> select* frommytable;<br>+----+------+------------+| id | name | content |<br>+----+------+------------+| 1 | | programmer |<br>+----+------+------------+1 row in set (0.00 sec)</span>
执行成功,name的值自动转为”
在严格模式下执行
1
<span style="color: rgb(0, 0, 0);">mysql> insertintomytable(content) values('programmer');ERROR 1364 (HY000): Field 'name'doesn't have a defaultvalue</span>
执行失败,提示字段name不能为null值
2.自增长字段插入”值测试
对id字段插入”值
在非严格模式下执行
1
<span style="color: rgb(0, 0, 0);">mysql> insertintomytable(id,name,content) value('','fdipzone','programmer');<br>Query OK, 1 row affected, 1 warning (0.00 sec)mysql> select* frommytable;<br>+----+----------+------------+| id | name | content |<br>+----+----------+------------+| 1 | fdipzone | programmer |<br>+----+----------+------------+1 row in set (0.00 sec)</span>