1 echo CREATE TABLE t1
(f1 int
,f2 int
,f3 int
,primary key
(f1
,f2
));
3 echo CREATE TABLE t2
(f1 int
,f2 int
,f3 int
,foreign key
(f1
,f3
) references t1
(f1
,f2
));
5 echo INSERT INTO t1 VALUES
(1,10,100);
6 Statement Executed
: Rows Affected
= 1
7 echo INSERT INTO t1 VALUES
(1,20,100);
8 Statement Executed
: Rows Affected
= 1
9 echo INSERT INTO t1 VALUES
(3,20,100);
10 Statement Executed
: Rows Affected
= 1
11 echo INSERT INTO t1 VALUES
(4,30,300);
12 Statement Executed
: Rows Affected
= 1
13 echo SELECT
* FROM t1
;
14 ---------------------------------------------------------
16 ---------------------------------------------------------
22 echo INSERT INTO t2 VALUES
(1,1000,10);
23 Statement Executed
: Rows Affected
= 1
24 echo INSERT INTO t2 VALUES
(1,1000,20);
25 Statement Executed
: Rows Affected
= 1
26 echo INSERT INTO t2 VALUES
(1,1000,10);
27 Statement Executed
: Rows Affected
= 1
28 echo INSERT INTO t2 VALUES
(4,1000,30);
29 Statement Executed
: Rows Affected
= 1
30 echo SELECT
* FROM t2
;
31 ---------------------------------------------------------
33 ---------------------------------------------------------
39 echo UPDATE t2 SET f1
=3,f3
=20 WHERE f1
=1;
40 Statement Executed
: Rows Affected
= 3
41 echo SELECT
* FROM t2
;
42 ---------------------------------------------------------
44 ---------------------------------------------------------
50 echo UPDATE t2 SET f3
=20 WHERE f1
=4;
51 Statement execute failed with error
-35