志在指尖
用双手敲打未来

sql创建数据库的脚本下载以及增删改查语句查阅-志在指尖

sql创建数据库的脚本下载以及增删改查语句查阅-志在指尖

第一次更新sql,在这里讲一下 使用sql数据库脚本的时候 请先创建一个名为“students”的数据库 然后再执行sql数据库脚本

 

sql增删改查语句

sql增删改查语句

insert into areaInfo VALUES('5801','大英县')
insert into areaInfo VALUES('5802','船山区')
insert into areaInfo VALUES('5803','船山区')
insert into areaInfo VALUES('5804','船山区')
insert into schoolInfo VALUES('0001','大英一中','5801')
insert into schoolInfo VALUES('0002','大英一中','5802')
insert into schoolInfo VALUES('0003','船山中学','5803')
insert into schoolInfo VALUES('0004','船山中学','5804')
insert into stuInfo(schId,stuIdentity,stuName,stuPwd,ClassId,stuSex,applyNum,examNum,stuId,remark) values('0001','510295','张三','123456','01','男','null','null','null','null')
insert into stuInfo(schId,stuIdentity,stuName,stuPwd,ClassId,stuSex,applyNum,examNum,stuId,remark) values('0002','510225','张四','123456','02','女','null','null','null','null')
insert into stuInfo(schId,stuIdentity,stuName,stuPwd,ClassId,stuSex,applyNum,examNum,stuId,remark) values('0002','510595','张五','123456','03','男','null','null','null','null')
insert into stuInfo(schId,stuIdentity,stuName,stuPwd,ClassId,stuSex,applyNum,examNum,stuId,remark) values('0001','514295','张六','123456','04','男','null','null','null','null')
insert into stuInfo(schId,stuIdentity,stuName,stuPwd,ClassId,stuSex,applyNum,examNum,stuId,remark) values('0001','510295','张七','123456','05','女','null','null','null','null')
insert into stuInfo(schId,stuIdentity,stuName,stuPwd,ClassId,stuSex,applyNum,examNum,stuId,remark) values('0002','512295','张八','123456','06','男','null','null','null','null')
insert into stuInfo(schId,stuIdentity,stuName,stuPwd,ClassId,stuSex,applyNum,examNum,stuId,remark) values('0002','510655','张九','123456','07','女','null','null','null','null')
insert into stuInfo(schId,stuIdentity,stuName,stuPwd,ClassId,stuSex,applyNum,examNum,stuId,remark) values('0001','516295','张十','123456','08','男','null','null','null','null')
insert into stuInfo(schId,stuIdentity,stuName,stuPwd,ClassId,stuSex,applyNum,examNum,stuId,remark) values('0001','517295','张十一','123456','09','男','null','null','null','null')
insert into stuInfo(schId,stuIdentity,stuName,stuPwd,ClassId,stuSex,applyNum,examNum,stuId,remark) values('0001','518895','张十二','123456','10','男','null','null','null','null')
update areaInfo set areaName='大英' where areaName='大英县'
update schoolInfo set schName='大英二中' where schName='大英一中'
update stuInfo set stuName='张十三' where stuName='张三'
delete from stuInfo where stuName='张十三'
CREATE TABLE [dbo].[ceshiInfo]([csId][char](4) primary key not null,csName varchar(20)not null)
insert into ceshiInfo(csId,csName) values ('1234','测试一')
insert into ceshiInfo(csId,csName) values ('1235','测试二')
delete from ceshiInfo

以上有sql的插入语句(insert)更新语句(update)以及删除语句(delete)

数据库脚本点击下方官方下载按钮即可下载,使用过后记得回来给我好评哟!谢谢


未经允许不得转载:IT技术网站 » sql创建数据库的脚本下载以及增删改查语句查阅-志在指尖
分享到: 更多 (0)

评论 抢沙发

评论前必须登录!

 

志在指尖 用双手敲打未来

登录/注册IT技术大全

热门IT技术

C#基础入门   SQL server数据库   系统SEO学习教程   WordPress小技巧   WordPress插件   脚本与源码下载