insert Table_1(name,address,grade,email)
select 'omnipotent',default,5,'sdf@df' union
select 'unambiguous',default,4,'dsfsd@df' union
select 'unequivocal',default,1,'dfdjf@iiii'
你如果有默认值的话不赋值就可以了,不用再写default
tryinsert Table_1(name,grade,email)
select 'omnipotent',5,'sdf@df' union
select 'unambiguous',4,'dsfsd@df' union
select 'unequivocal',1,'dfdjf@iiii'
select 'omnipotent',default,5,'sdf@df' union
select 'unambiguous',default,4,'dsfsd@df' union
select 'unequivocal',default,1,'dfdjf@iiii'
你如果有默认值的话不赋值就可以了,不用再写default
tryinsert Table_1(name,grade,email)
select 'omnipotent',5,'sdf@df' union
select 'unambiguous',4,'dsfsd@df' union
select 'unequivocal',1,'dfdjf@iiii'
select 'omnipotent',5,'sdf@df' union
select 'unambiguous',4,'dsfsd@df' union
select 'unequivocal',1,'dfdjf@iiii' 不写就行
select 'omnipotent',5,'sdf@df' union
select 'unambiguous',4,'dsfsd@df' union
select 'unequivocal',1,'dfdjf@iiii'
你的值都已经确定了
没有必要用default
select 'omnipotent',5,'sdf@df' union
select 'unambiguous',4,'dsfsd@df' union
select 'unequivocal',1,'dfdjf@iiii'
alter table Table_1 add defalut 默认值 for grade
如果确实设置了Default约束,则应该使用4,3,2楼的方法插入数据!
select 'omnipotent',5,'sdf@df' union
select 'unambiguous',4,'dsfsd@df' union
select 'unequivocal',1,'dfdjf@iiii'