1 echo CREATE TABLE t1(f1 int,f2 int,primary key(f1));
3 echo CREATE TABLE t2(f3 int,f4 int,primary key(f3));
5 echo CREATE TABLE t3(f5 int,f6 int,foreign key(f5) references t1(f1),foreign key(f6) references t2(f3) );
7 echo INSERT INTO t1 values(1,10);
8 Statement Executed: Rows Affected = 1
9 echo INSERT INTO t1 values(2,20);
10 Statement Executed: Rows Affected = 1
11 echo INSERT INTO t2 values(3,30);
12 Statement Executed: Rows Affected = 1
13 echo INSERT INTO t2 values(4,40);
14 Statement Executed: Rows Affected = 1
15 echo INSERT INTO t3 values(1,3);
16 Statement Executed: Rows Affected = 1
17 echo INSERT INTO t3 values(1,4);
18 Statement Executed: Rows Affected = 1
19 echo INSERT INTO t3 values(2,3);
20 Statement Executed: Rows Affected = 1
21 echo INSERT INTO t3 values(2,4);
22 Statement Executed: Rows Affected = 1
23 echo INSERT INTO t3 values(2,4);
24 Statement Executed: Rows Affected = 1
25 echo INSERT INTO t3 values(1,5);
26 Statement execute failed with error -35
27 echo SELECT * FROM t1;
28 ---------------------------------------------------------
30 ---------------------------------------------------------
34 echo SELECT * FROM t2;
35 ---------------------------------------------------------
37 ---------------------------------------------------------
41 echo SELECT * FROM t3;
42 ---------------------------------------------------------
44 ---------------------------------------------------------
52 Statement Executed: Rows Affected = 5
54 Statement Executed: Rows Affected = 2
56 Statement Executed: Rows Affected = 2
57 echo SELECT * FROM t1;
58 ---------------------------------------------------------
60 ---------------------------------------------------------
62 echo SELECT * FROM t2;
63 ---------------------------------------------------------
65 ---------------------------------------------------------
67 echo SELECT * FROM t3;
68 ---------------------------------------------------------
70 ---------------------------------------------------------