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 t2 VALUES
(1,10,100);
8 Statement execute failed with error
-35
9 echo INSERT INTO t2 VALUES
(2,20,10);
10 Statement execute failed with error
-35