dml.sql

来自「对于移动数据库而言」· SQL 代码 · 共 19 行

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);