mysql5.5创建学⽣情况表_SQL创建⼀个学⽣信息表CREATE TABLE Student
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20) UNIQUE,
Ssex CHAR(2),
Sage SMALLINT,java中switch的格式
Sdept CHAR(20)汇编语言教程书免费下载
);
insert into student values('201215121','李勇','男',20,'CS');
insert into student values('201215122','刘晨','⼥',19,'CS');
中文16进制转换insert into student values('201215123','王敏','⼥',18,'MA');
insert into student values('201215125','张⽴','男',19,'IS');
insert into student values('201215126','李⼀平','男',18,'IS');
insert into student values('201215127','张琴','⼥',19,'CS');
insert into student values('201215128','王⽅','⼥',20,'MA');
insert into student values('201215129','黄林林','男',21,'IS');
CREATE TABLE Course
(Cno CHAR(4) PRIMARY KEY,
Cname CHAR(40),
Cpno CHAR(4),
Ccredit SMALLINT,
);
insert into course values('1','数据库','5',4);
百度高级编辑器insert into course values('2','数学',null,2);
insert into course values('3','信息系统','1',4);
insert into course values('4','操作系统','6',3);
mysql面试题学生表insert into course values('5','数据结构','7',4);
hbase的使用场景insert into course values('6','数据处理',null,2);
insert into course values('7','C语⾔','6',4);
CREATE TABLE SC
(Sno CHAR(9),
Cno CHAR(4),
Grade SMALLINT,
PRIMARY KEY (Sno,Cno))
insert into sc values('201215121','4',98); insert into sc values('201215121','5',89); insert into sc values('201215121','6',95); insert into sc values('201215121','7',93); insert into sc values('201215122','2',90); insert into sc values('201215122','3',80); insert into sc values('201215122','4',85); insert into sc values('201215122','6',92); insert into sc values('201215123','1',90); insert into sc values('201215123','2',84); insert into sc values('201215123','3',91); insert into sc values('201215123','4',90); insert into sc values('201215123','5',80); insert into sc values('201215123','6',78); insert into sc values('201215123','7',65); insert into sc values('201215128','1',78); insert into sc values('201215128','2',82); insert into sc values('201215128','3',77); insert into sc values('201215128','4',79); insert into sc values('201215128','5',92); insert into sc values('201215128','6',98); insert into sc values('201215128','7',50); insert into sc values('201215125','1',67); insert into sc values('201215125','2',71); insert into sc values('201215125','3',90); insert into sc values('201215126','4',81); insert into sc values('201215126','5',90); insert into sc values('201215126','6',56); insert into sc values('201215126','7',89); insert into sc values('201215127','1',81); insert into sc values('201215127','2',72);
insert into sc values('201215127','6',50); insert into sc values('201215127','7',96);

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。