2
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1(c1 CHAR(10) NOT NULL, c2 CHAR(10) NOT NULL, c3 CHAR(10) NOT NULL, PRIMARY KEY(c1,c2,c3));
5
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
6
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
7
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
8
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
9
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
10
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
11
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
13
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
15
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
17
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
21
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL, c2 VARCHAR(10) NOT NULL, c3 VARCHAR(10) NOT NULL, PRIMARY KEY(c1,c2,c3));
22
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
23
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
24
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
25
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
26
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
27
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
28
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
30
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
32
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
34
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
36
SELECT hex(c1),hex(c2),hex(c3) FROM t1;
38
CREATE TABLE t1(c1 BINARY(10) NOT NULL, c2 BINARY(10) NOT NULL, c3 BINARY(10) NOT NULL, PRIMARY KEY(c1,c2,c3));
39
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
40
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
41
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
42
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
43
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
44
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
45
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
48
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
50
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
52
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
54
SELECT hex(c1),hex(c2),hex(c3) FROM t1;
56
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL, c2 VARBINARY(10) NOT NULL, c3 VARBINARY(10) NOT NULL, PRIMARY KEY(c1,c2,c3));
57
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
58
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
59
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
60
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
61
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
62
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
63
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
65
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
67
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
69
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');