SQL-基础SQL语言-建表和插入数据
2021/9/18 19:10:07
本文主要是介绍SQL-基础SQL语言-建表和插入数据,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
--创建Student表-- create table Student ( Sno char(10) primary key, Sname varchar(20), Ssex char(2), Sage smallint, Sdept varchar(20) ); --创建Course表-- create table Course ( Cno char(10) primary key, Cname varchar(20), Cpno char(10), Ccredit smallint ); --创建SC表-- create table SC ( Sno char(10), Cno char(10), Grade smallint, primary key(Sno,Cno) ); --001性别女,专业计算机科学 insert into Student values('001','MuHuai','f',20,'JiSuanJi'); --002性别男,专业音乐 insert into Student values('002','木槐','m',19,'YinYue'); insert into Student values('003','LinGui','f',20,'ShengWu'); insert into Student values('004','林鬼','m',18,'ShuXue'); insert into Student values('005','Niki','f',18,'JiSuanJi'); insert into Student values('006','Charles','m',18,'YingYu'); insert into Student values('007','Smith','m',19,'YingYu'); insert into Student values('008','PiPe','m',21,'ShuXue'); insert into Student values('009','烟斗','f',19,'ShengWu'); insert into Student values('010','gong','m',21,'China'); insert into Student values('011','shang','f',19,'China'); insert into Student values('012','jue','f',21,'China'); insert into Student values('013','zhi','m',18,'China'); insert into Student values('014','yu','m',20,'China'); insert into Student values('015','contton','f',2000,'China'); --课程艺术C01 insert into Course values('C01','HuaHua','AC01',3); insert into Course values('C02','TiYu','AC02',2); insert into Course values('C03','ZhengZhi','AC03',10); insert into Course values('C04','YuWen','AC04',10); insert into Course values('C05','SiXiang','AC05',3); insert into Course values('C06','XiJu','AC06',6); insert into Course values('C07','ShuXue','AC07',3); insert into Course values('C08','YingYu','AC08',2); insert into Course values('C09','ShengWu','AC09',4); insert into Course values('C10','WuLi','AC10',5); --001学生C01课程 insert into SC values('001','C01',97); insert into SC values('001','C02',86); insert into SC values('002','C03',67); insert into SC values('002','C02',98); insert into SC values('003','C04',35); insert into SC values('003','C03',63); insert into SC values('004','C02',56); insert into SC values('004','C04',78); insert into SC values('005','C06',97); insert into SC values('005','C04',26); insert into SC values('006','C03',92); insert into SC values('006','C02',87); insert into SC values('007','C07',100); insert into SC values('007','C02',14); insert into SC values('008','C08',100); insert into SC values('008','C03',38); insert into SC values('009','C10',89); insert into SC values('009','C05',59); insert into SC values('010','C02',96); insert into SC values('010','C01',94); insert into SC values('011','C02',74); insert into SC values('011','C03',86); insert into SC values('012','C09',0); insert into SC values('012','C10',0); insert into SC values('013','C08',100); insert into SC values('013','C04',93); insert into SC values('014','C03',73); insert into SC values('014','C07',69); insert into SC values('015','C10',100); insert into SC values('015','C09',0); insert into SC values('001','C03',0); insert into SC values('002','C06',91); insert into SC values('003','C10',0); insert into SC values('004','C03',100); insert into SC values('005','C10',0); insert into SC values('006','C10',100); insert into SC values('007','C10',0);
这篇关于SQL-基础SQL语言-建表和插入数据的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-06-26结对编程到底难不难?答案在这里
- 2024-06-19《2023版Java工程师》课程升级公告
- 2024-06-15matplotlib作图不显示3D图,怎么办?
- 2024-06-1503-Loki 日志监控
- 2024-06-1504-让LLM理解知识 -Prompt
- 2024-06-05做软件测试需要懂代码吗?
- 2024-06-0514-ShardingSphere的分布式主键实现
- 2024-06-03为什么以及如何要进行架构设计权衡?
- 2024-05-31全网首发第二弹!软考2024年5月《软件设计师》真题+解析+答案!(11-20题)
- 2024-05-31全网首发!软考2024年5月《软件设计师》真题+解析+答案!(21-30题)