1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 CHAR(10) NOT NULL, c2 CHAR(10) NULL, c3 CHAR(10) NULL, PRIMARY KEY (c1), UNIQUE (c2));
3
INSERT INTO t1 (c1,c2,c3) VALUES('a','e','abc');
4
INSERT INTO t1 (c1,c2,c3) VALUES('b','d','abc');
5
INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc');
6
INSERT INTO t1 (c1,c2,c3) VALUES('d','b','abc');
7
INSERT INTO t1 (c1,c2,c3) VALUES('e','a','abc');
8
INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';
9
INSERT INTO t1 (c1,c2,c3) VALUES('a','a','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';
18
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL, c2 VARCHAR(10) NULL, c3 VARCHAR(10) NULL, PRIMARY KEY (c1), UNIQUE (c2));
19
INSERT INTO t1 (c1,c2,c3) VALUES('a','e','abc');
20
INSERT INTO t1 (c1,c2,c3) VALUES('b','d','abc');
21
INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc');
22
INSERT INTO t1 (c1,c2,c3) VALUES('d','b','abc');
23
INSERT INTO t1 (c1,c2,c3) VALUES('e','a','abc');
24
INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';
25
INSERT INTO t1 (c1,c2,c3) VALUES('a','a','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';
34
CREATE TABLE t1(c1 BINARY(10) NOT NULL, c2 BINARY(10) NULL, c3 BINARY(10) NULL, PRIMARY KEY (c1), UNIQUE (c2));
35
INSERT INTO t1 (c1,c2,c3) VALUES('a','e','abc');
36
INSERT INTO t1 (c1,c2,c3) VALUES('b','d','abc');
37
INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc');
38
INSERT INTO t1 (c1,c2,c3) VALUES('d','b','abc');
39
INSERT INTO t1 (c1,c2,c3) VALUES('e','a','abc');
40
INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';
41
INSERT INTO t1 (c1,c2,c3) VALUES('a','a','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';
42
SELECT hex(c1),hex(c2),hex(c3) FROM t1;
43
hex(c1) hex(c2) hex(c3)
44
61000000000000000000 65000000000000000000 61626364656667000000
45
62000000000000000000 64000000000000000000 61626300000000000000
46
63000000000000000000 63000000000000000000 61626364656667000000
47
64000000000000000000 62000000000000000000 61626300000000000000
48
65000000000000000000 61000000000000000000 61626300000000000000
50
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL, c2 VARBINARY(10) NULL, c3 VARBINARY(10) NULL, PRIMARY KEY (c1), UNIQUE (c2));
51
INSERT INTO t1 (c1,c2,c3) VALUES('a','e','abc');
52
INSERT INTO t1 (c1,c2,c3) VALUES('b','d','abc');
53
INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc');
54
INSERT INTO t1 (c1,c2,c3) VALUES('d','b','abc');
55
INSERT INTO t1 (c1,c2,c3) VALUES('e','a','abc');
56
INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';
57
INSERT INTO t1 (c1,c2,c3) VALUES('a','a','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';