insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID)
insert插入语句
原创
©著作权归作者所有:来自51CTO博客作者goot2012的原创作品,请联系作者获取转载授权,否则将追究法律责任
insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID)
values('张强',12,1,12,12,'dd',1)
--正确
go
insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID)
values('张强',12,1,12,12,'dd')--少量一个值,插入数据的值应该对应起来,不能插入半行数据
go
insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID)
values('张强',12,1,12,12,'dd','哦也!我错了')--注意事项2:每个数据值的数据类型、精度和小数位数必须与相应的列匹配;
go
insert into dbo.TeacherInfo(id,TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID)
values(1,'张强',12,1,12,12,'dd',1)--注意事项3:不能为标识列指定值,因为它的数字是自动增长的;
go
insert into dbo.TeacherInfo(TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID)
values(12,1,12,12,'dd',1)--注意事项4:如果在设计表的时候就指定了某列不允许为空,则必须插入数据;
go
insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID)
values('张强',12,1,12,12,'dd',100)--注意事项5:插入的数据项,要求符合检查约束的要求
select * from dbo.DepartInfo
--delete from dbo.TeacherInfo where DepartID=100
go
insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID)
values('张强',12,1,default,12,'dd',1)--注意事项6:具有缺省值的列,可以使用DEFAULT(缺省)关键字来代替插入的数值
go
insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID)
values('张强',12,1,12,12,'dd',1)
insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID)
values('张强',12,1,12,12,'dd',1)
insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID)
values('张强',12,1,12,12,'dd',1)
insert into dbo.DepartInfo(DepartName,DepartCount,DepartNote) values('计算机工程系',1,'计算机')
insert into dbo.DepartInfo(DepartName,DepartCount,DepartNote) values('信息工程系',1,'计算机')
insert into dbo.DepartInfo(DepartName,DepartCount,DepartNote) values('jinji工程系',1,'计算机')
insert into dbo.DepartInfo(DepartName,DepartCount,DepartNote) values('jijian工程系',1,'计算机')
上一篇:select查询
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
hibernate插入数据库默认值
<?xml version="1.0" encoding="utf-8"?><!DOCTYPE hibernate-mapping PUBLIC "-//H.dtd"><!
java 数据库 开发工具 hibernate xml -
达梦数据库TIMESTAMP对应java字段 达梦数据库insert
集成pom.xml<!-- 达梦数据库 --><dependency> <groupId>com.dameng</groupId> <artifactId>Dm8JdbcDriver18</artifactId> <version>8.1.1.49</version>
spring boot 达梦数据库 IDENTITY_INSERT hibernate sql