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
(2,20,100);
10 Statement Executed
: Rows Affected
= 1
11 echo INSERT INTO t1 VALUES
(3,30,300);
12 Statement Executed
: Rows Affected
= 1
13 echo INSERT INTO t2 VALUES
(1,1000,10);
14 Statement Executed
: Rows Affected
= 1
15 echo INSERT INTO t2 VALUES
(1,1000,20);
16 Statement Executed
: Rows Affected
= 1
17 echo INSERT INTO t2 VALUES
(2,1000,20);
18 Statement Executed
: Rows Affected
= 1
19 echo INSERT INTO t2 VALUES
(3,1000,30);
20 Statement Executed
: Rows Affected
= 1
21 echo DELETE FROM t1 WHERE f1
=1;
22 Statement execute failed with error
-35