1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 CHAR(10) NOT NULL, c2 CHAR(10) NOT NULL, c3 CHAR(10) NOT NULL, PRIMARY KEY(c1,c2,c3));
3
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
4
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
5
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
6
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
7
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
8
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
9
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
10
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
11
ERROR 23000: Duplicate entry 'abc-abc-abc' for key 'PRIMARY'
12
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
13
ERROR 23000: Duplicate entry 'abc-abc-def' for key 'PRIMARY'
14
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
15
ERROR 23000: Duplicate entry 'abc-def-def' for key 'PRIMARY'
26
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL, c2 VARCHAR(10) NOT NULL, c3 VARCHAR(10) NOT NULL, PRIMARY KEY(c1,c2,c3));
27
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
28
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
29
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
30
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
31
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
32
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
33
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
34
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
35
ERROR 23000: Duplicate entry 'abc-abc-abc' for key 'PRIMARY'
36
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
37
ERROR 23000: Duplicate entry 'abc-abc-def' for key 'PRIMARY'
38
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
39
ERROR 23000: Duplicate entry 'abc-def-def' for key 'PRIMARY'
40
SELECT hex(c1),hex(c2),hex(c3) FROM t1;
41
hex(c1) hex(c2) hex(c3)
50
CREATE TABLE t1(c1 BINARY(10) NOT NULL, c2 BINARY(10) NOT NULL, c3 BINARY(10) NOT NULL, PRIMARY KEY(c1,c2,c3));
51
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
52
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
53
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
54
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
55
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
56
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
57
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
58
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
59
ERROR 23000: Duplicate entry 'abc-abc-abc' for key 'PRIMARY'
60
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
61
ERROR 23000: Duplicate entry 'abc-abc-def' for key 'PRIMARY'
62
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
63
ERROR 23000: Duplicate entry 'abc-def-def' for key 'PRIMARY'
64
SELECT hex(c1),hex(c2),hex(c3) FROM t1;
65
hex(c1) hex(c2) hex(c3)
66
61626300000000000000 61626300000000000000 61626300000000000000
67
61626300000000000000 61626300000000000000 64656600000000000000
68
61626300000000000000 64656600000000000000 61626300000000000000
69
61626300000000000000 64656600000000000000 64656600000000000000
70
64656600000000000000 61626300000000000000 61626300000000000000
71
64656600000000000000 61626300000000000000 64656600000000000000
72
64656600000000000000 64656600000000000000 61626300000000000000
74
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL, c2 VARBINARY(10) NOT NULL, c3 VARBINARY(10) NOT NULL, PRIMARY KEY(c1,c2,c3));
75
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
76
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
77
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
78
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
79
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
80
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
81
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
82
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
83
ERROR 23000: Duplicate entry 'abc-abc-abc' for key 'PRIMARY'
84
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
85
ERROR 23000: Duplicate entry 'abc-abc-def' for key 'PRIMARY'
86
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
87
ERROR 23000: Duplicate entry 'abc-def-def' for key 'PRIMARY'