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