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