1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 CHAR(10) NULL, c2 CHAR(10) NULL, c3 CHAR(10) NULL, UNIQUE(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') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg',c3='abcdefg';
11
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg';
12
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def') ON DUPLICATE KEY UPDATE c2='abcdefg',c3='abcdefg';
17
abcdefg abcdefg abcdefg
23
CREATE TABLE t1(c1 VARCHAR(10) NULL, c2 VARCHAR(10) NULL, c3 VARCHAR(10) NULL, UNIQUE(c1,c2,c3));
24
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
25
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
26
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
27
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
28
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
29
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
30
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
31
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg',c3='abcdefg';
32
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg';
33
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def') ON DUPLICATE KEY UPDATE c2='abcdefg',c3='abcdefg';
38
abcdefg abcdefg abcdefg
44
CREATE TABLE t1(c1 BINARY(10) NULL, c2 BINARY(10) NULL, c3 BINARY(10) NULL, UNIQUE(c1,c2,c3));
45
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
46
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
47
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
48
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
49
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
50
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
51
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
52
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg',c3='abcdefg';
53
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg';
54
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def') ON DUPLICATE KEY UPDATE c2='abcdefg',c3='abcdefg';
55
SELECT hex(c1),hex(c2),hex(c3) FROM t1;
56
hex(c1) hex(c2) hex(c3)
57
61626300000000000000 61626364656667000000 61626364656667000000
58
61626300000000000000 64656600000000000000 61626300000000000000
59
61626364656667000000 61626364656667000000 61626364656667000000
60
61626364656667000000 61626364656667000000 64656600000000000000
61
64656600000000000000 61626300000000000000 61626300000000000000
62
64656600000000000000 61626300000000000000 64656600000000000000
63
64656600000000000000 64656600000000000000 61626300000000000000
65
CREATE TABLE t1(c1 VARBINARY(10) NULL, c2 VARBINARY(10) NULL, c3 VARBINARY(10) NULL, UNIQUE(c1,c2,c3));
66
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
67
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
68
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
69
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
70
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
71
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
72
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
73
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg',c3='abcdefg';
74
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg';
75
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def') ON DUPLICATE KEY UPDATE c2='abcdefg',c3='abcdefg';
80
abcdefg abcdefg abcdefg