📄 dml.sql
字号:
alter table DEPT disable constraint FK_DEPT_EMP;
alter table EMP disable constraint FK_EMP_DEPT;
insert into dept values(1,'Admin',1);
insert into dept values(2,'Engineer',3);
insert into emp values(1,'Mike',1);
insert into emp values(2,'Kate',1);
insert into emp values(3,'John',2);
insert into emp values(4,'Chen',2);
insert into emp values(5,'Qiao',2);
insert into emp values(6,'Nancy',2);
insert into emp values(7,'Linc',2);
insert into emp values(8,'Lee',2);
alter table EMP enable constraint FK_EMP_DEPT;
alter table DEPT enable constraint FK_DEPT_EMP;
insert into users values(1,'chen','chen');
insert into AccessNumber values(1,'dept',1);
insert into AccessNumber values(1,'emp',4);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -