如果一个字段没有插入值,可以默认插入一个指定的值
- mysql> create table stu19(
- -> name varchar(20) not null default '姓名不详',
- -> addr varchar(50) not null default '地址不详'
- -> );
- Query OK, 0 rows affected (0.05 sec)
- mysql> insert into stu19(name) values ('tom');
- Query OK, 1 row affected (0.00 sec)
- mysql> insert into stu19 values (default,default);
- Query OK, 1 row affected (0.00 sec)
- mysql> select * from stu19;
- +----------+----------+
- | name | addr |
- +----------+----------+
- | tom | 地址不详 |
- | 姓名不详 | 地址不详 |
- +----------+----------+
- 2 rows in set (0.00 sec)
复制代码小结: default关键字用来插入默认值
|
|