没有合适的资源?快使用搜索试试~ 我知道了~
sql查询测试数据
3星 · 超过75%的资源 需积分: 50 24 下载量 120 浏览量
2017-08-07
14:50:56
上传
评论
收藏 3KB TXT 举报
温馨提示
试读
3页
是我博客里题目的sql测试数据
资源推荐
资源详情
资源评论
CREATE TABLE J_TEACHER (
tno int NOT NULL PRIMARY KEY,
tname varchar(20) NOT NULL
);
INSERT INTO J_TEACHER(tno,tname)VALUES(1,'张老师');
INSERT INTO J_TEACHER(tno,tname)VALUES(2,'王老师');
INSERT INTO J_TEACHER(tno,tname)VALUES(3,'李老师');
INSERT INTO J_TEACHER(tno,tname)VALUES(4,'赵老师');
INSERT INTO J_TEACHER(tno,tname)VALUES(5,'刘老师');
INSERT INTO J_TEACHER(tno,tname)VALUES(6,'向老师');
INSERT INTO J_TEACHER(tno,tname)VALUES(7,'李文静');
INSERT INTO J_TEACHER(tno,tname)VALUES(8,'叶平');
CREATE TABLE J_STUDENT(
sno int NOT NULL PRIMARY KEY,
sname varchar(20) NOT NULL,
sage datetime NOT NULL,
ssex char(2) NOT NULL
);
INSERT INTO J_STUDENT(sno,sname,sage,ssex) VALUES(1,'张三','1980-1-23','男');
INSERT INTO J_STUDENT(sno,sname,sage,ssex) VALUES(2,'李四','1982-12-12','男');
INSERT INTO J_STUDENT(sno,sname,sage,ssex) VALUES(3,'张飒','1981-9-9','男');
INSERT INTO J_STUDENT(sno,sname,sage,ssex) VALUES(4,'莉莉','1983-3-23','女');
INSERT INTO J_STUDENT(sno,sname,sage,ssex) VALUES(5,'王弼','1982-6-21','男');
INSERT INTO J_STUDENT(sno,sname,sage,ssex) VALUES(6,'王丽','1984-10-10','女');
INSERT INTO J_STUDENT(sno,sname,sage,ssex) VALUES(7,'刘香','1980-12-22','女');
CREATE TABLE J_COURSE(
tno int NOT NULL PRIMARY KEY,
tname varchar(20) NOT NULL
);
INSERT INTO J_TEACHER(tno,tname)VALUES(1,'张老师');
INSERT INTO J_TEACHER(tno,tname)VALUES(2,'王老师');
INSERT INTO J_TEACHER(tno,tname)VALUES(3,'李老师');
INSERT INTO J_TEACHER(tno,tname)VALUES(4,'赵老师');
INSERT INTO J_TEACHER(tno,tname)VALUES(5,'刘老师');
INSERT INTO J_TEACHER(tno,tname)VALUES(6,'向老师');
INSERT INTO J_TEACHER(tno,tname)VALUES(7,'李文静');
INSERT INTO J_TEACHER(tno,tname)VALUES(8,'叶平');
CREATE TABLE J_STUDENT(
sno int NOT NULL PRIMARY KEY,
sname varchar(20) NOT NULL,
sage datetime NOT NULL,
ssex char(2) NOT NULL
);
INSERT INTO J_STUDENT(sno,sname,sage,ssex) VALUES(1,'张三','1980-1-23','男');
INSERT INTO J_STUDENT(sno,sname,sage,ssex) VALUES(2,'李四','1982-12-12','男');
INSERT INTO J_STUDENT(sno,sname,sage,ssex) VALUES(3,'张飒','1981-9-9','男');
INSERT INTO J_STUDENT(sno,sname,sage,ssex) VALUES(4,'莉莉','1983-3-23','女');
INSERT INTO J_STUDENT(sno,sname,sage,ssex) VALUES(5,'王弼','1982-6-21','男');
INSERT INTO J_STUDENT(sno,sname,sage,ssex) VALUES(6,'王丽','1984-10-10','女');
INSERT INTO J_STUDENT(sno,sname,sage,ssex) VALUES(7,'刘香','1980-12-22','女');
CREATE TABLE J_COURSE(
资源评论
- 枫羽2018-03-17数据很多很不错
- Mr_Xie_2018-09-264个表没多少跳数据。。坑了
K_122
- 粉丝: 10
- 资源: 18
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功