用下面的语句创建一个表:
create table student(num smallint primary key check (num > 10), name char(8) not null),约束num的值要大于10,为什么insert student set num = 5会插入成功呢??
create table student(num smallint primary key check (num > 10), name char(8) not null),约束num的值要大于10,为什么insert student set num = 5会插入成功呢??
--不会追加进去,你执行一下如下SQL,试一下insert student (num,name) select 5,'a'