create table t16(
id int,
name char(6),
sex enum('male','female') not null default 'male'
);
insert into t16(id,name) values(1,'egon');
如果设置了不能传空而传空,则会使用默认值“male”
from oldboy egon~
create table t16(
id int,
name char(6),
sex enum('male','female') not null default 'male'
);
insert into t16(id,name) values(1,'egon');
如果设置了不能传空而传空,则会使用默认值“male”
from oldboy egon~
转载于:https://www.cnblogs.com/FlFtFw/p/9538092.html