没有合适的资源?快使用搜索试试~ 我知道了~
数据库系统概论 王珊 萨师宣 模式 create schema ch3; drop schema ch3; create schema ch3; use ch3; show tables;
资源推荐
资源详情
资源评论
模式
create schema ch3;
drop schema ch3;
create schema ch3;
use ch3;
show tables;
基本表
CREATE TABLE Student
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20) UNIQUE,
Ssex CHAR(2),
Sage SMALLINT,
Sdept CHAR(20)
);
show tables;
desc student;
show create table student;
create schema ch3;
drop schema ch3;
create schema ch3;
use ch3;
show tables;
基本表
CREATE TABLE Student
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20) UNIQUE,
Ssex CHAR(2),
Sage SMALLINT,
Sdept CHAR(20)
);
show tables;
desc student;
show create table student;
drop table student;
INSERT INTO `student` VALUES ('200215121', '李勇', '男', '20', 'CS');
INSERT INTO `student` VALUES ('200215122', '刘晨', '女', '19', 'CS');
INSERT INTO `student` VALUES ('200215123', '王敏', '女', '18', 'MA');
INSERT INTO `student` VALUES ('200215125', '张立', '男', '19', 'IS');
delete from student;
INSERT INTO `student` VALUES ('200215121', '李勇', '男', '20', 'CS'),
('200215122', '刘晨', '女', '19', 'CS'),
('200215123', '王敏', '女', '18', 'MA'),
('200215125', '张立', '男', '19', 'IS');
CREATE TABLE Course
(Cno CHAR(4) PRIMARY KEY,
Cname CHAR(40),
Cpno CHAR(4),
Ccredit SMALLINT,
FOREIGN KEY (Cpno) REFERENCES Course(Cno)
);
INSERT INTO `course` VALUES ('1', '数据库', '5', '4');
INSERT INTO `course` VALUES ('2', '数学', null, '2');
INSERT INTO `student` VALUES ('200215121', '李勇', '男', '20', 'CS');
INSERT INTO `student` VALUES ('200215122', '刘晨', '女', '19', 'CS');
INSERT INTO `student` VALUES ('200215123', '王敏', '女', '18', 'MA');
INSERT INTO `student` VALUES ('200215125', '张立', '男', '19', 'IS');
delete from student;
INSERT INTO `student` VALUES ('200215121', '李勇', '男', '20', 'CS'),
('200215122', '刘晨', '女', '19', 'CS'),
('200215123', '王敏', '女', '18', 'MA'),
('200215125', '张立', '男', '19', 'IS');
CREATE TABLE Course
(Cno CHAR(4) PRIMARY KEY,
Cname CHAR(40),
Cpno CHAR(4),
Ccredit SMALLINT,
FOREIGN KEY (Cpno) REFERENCES Course(Cno)
);
INSERT INTO `course` VALUES ('1', '数据库', '5', '4');
INSERT INTO `course` VALUES ('2', '数学', null, '2');
剩余30页未读,继续阅读
资源评论
liuxiaotongdaizi
- 粉丝: 0
- 资源: 5
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功