1 echo CREATE TABLE t1(f1 int,f2 int,primary key(f1));
2 CREATE TABLE t1(f1 int,f2 int,primary key(f1));
3 echo CREATE TABLE t2(f3 int,f4 int,primary key(f4),foreign key(f3) references t1(f1));
4 CREATE TABLE t2(f3 int,f4 int,primary key(f4),foreign key(f3) references t1(f1));
5 echo CREATE TABLE t3(f5 int,f6 int,foreign key(f5) references t2(f4));
6 CREATE TABLE t3(f5 int,f6 int,foreign key(f5) references t2(f4));
7 echo INSERT INTO t1 values(1,10);
8 INSERT INTO t1 values(1,10);
9 echo INSERT INTO t1 values(2,20);
10 INSERT INTO t1 values(2,20);
12 echo INSERT INTO t2 values(1,100);
13 INSERT INTO t2 values(1,100);
14 echo INSERT INTO t2 values(1,200);
15 INSERT INTO t2 values(1,200);
16 echo INSERT INTO t2 values(2,300);
17 INSERT INTO t2 values(2,300);
19 echo INSERT INTO t3 values(100,1000);
20 INSERT INTO t3 values(100,1000);
21 echo INSERT INTO t3 values(100,1000);
22 INSERT INTO t3 values(100,1000);
23 echo INSERT INTO t3 values(200,1000);
24 INSERT INTO t3 values(200,1000);
25 echo INSERT INTO t3 values(200,1000);
26 INSERT INTO t3 values(200,1000);
28 echo SELECT * FROM t1;
30 echo SELECT * FROM t2;
32 echo SELECT * FROM t3;
35 echo INSERT INTO t2 values(3,100);
36 INSERT INTO t2 values(3,100);
38 echo INSERT INTO t3 values(400,1000);
39 INSERT INTO t3 values(400,1000);
41 echo SELECT * FROM t1;
43 echo SELECT * FROM t2;
45 echo SELECT * FROM t3;
48 echo UPDATE t3 SET f5=400 where f5=200;
49 UPDATE t3 SET f5=400 where f5=200;
50 echo UPDATE t1 SET f1=3 where f1=2;
51 UPDATE t1 SET f1=3 where f1=2;
52 echo UPDATE t2 SET f4=400 where f5=200;
53 UPDATE t2 SET f4=400 where f5=200;
55 echo UPDATE t3 SET f5=300 where f5=200;
56 UPDATE t3 SET f5=300 where f5=200;
58 echo SELECT * FROM t1;
60 echo SELECT * FROM t2;
62 echo SELECT * FROM t3;
65 echo DELETE FROM t1 WHERE f1=2;
66 DELETE FROM t1 WHERE f1=2;
67 echo DELETE FROM t2 where f4=200;
68 DELETE FROM t2 where f4=200;
70 echo DELETE FROM t3 WHERE f5=300;
71 DELETE FROM t3 WHERE f5=300;
72 echo SELECT * FROM t1;
74 echo SELECT * FROM t2;
76 echo SELECT * FROM t3;
78 echo DELETE FROM t2 where f4 IN(200,300,400);
79 DELETE FROM t2 where f4 IN(200,300,400);
80 echo DELETE FROM t1 WHERE f1=2;
81 DELETE FROM t1 WHERE f1=2;
83 echo SELECT * FROM t1;
85 echo SELECT * FROM t2;
87 echo SELECT * FROM t3;