📄 郑洋 课程设计数据库.txt
字号:
//jianli de shenqing biao
create table sqbiao1
(
bumensq char(10),
zcsq char(5),
name char(15),
numsq char(5),
mjsq char(10),
zfjf char(5)
);
//jianli de ti jiao shenqing biao
create table tjsqbiao1
(
bumensq char(10),
zcsq char(5),
name char(15),
numsq char(5),
mjsq char(10),
zfjf char(5)
);
//jianli kong fang wenjian
create table kfwenjian1
(
fangh char(10),
mianj char(10),
zdjifen char(5),
zjin char(10)
);
insert
into kfwenjian1
values('001','100','6','100');
insert
into kfwenjian1
values('002','110','7','105');
insert
into kfwenjian1
values('003','90','5','90');
insert
into kfwenjian1
values('004','120','8','110');
insert
into kfwenjian1
values('005','100','6','100');
insert
into kfwenjian1
values('006','130','9','120');
insert
into kfwenjian1
values('007','150','12','140');
insert
into kfwenjian1
values('008','100','6','100');
//jianli yifen fang wenjian
create table yffwenjian1
(name char(15),
bumen char(10),
zc char(5),
num char(5),
zffs char(5),
fangh char(10),
mianj char(10)
);
//diao fang biao
create table dfbiao
(
bumendf char(10),
zcdf char(5),
numdf char(5),
zfjf char(5),
yfmj char(10),
yfangh char(10),
yqmj char(10)
);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -