2
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1(c1 CHAR(10) NULL UNIQUE);
5
INSERT INTO t1 (c1) VALUES('abc');
6
INSERT INTO t1 (c1) VALUES('def');
7
INSERT IGNORE INTO t1 (c1) VALUES('abc');
10
CREATE TABLE t1(c1 VARCHAR(10) NULL UNIQUE);
11
INSERT INTO t1 (c1) VALUES('abc');
12
INSERT INTO t1 (c1) VALUES('def');
13
INSERT IGNORE INTO t1 (c1) VALUES('abc');
16
CREATE TABLE t1(c1 BINARY(10) NULL UNIQUE);
17
INSERT INTO t1 (c1) VALUES('abc');
18
INSERT INTO t1 (c1) VALUES('def');
19
INSERT IGNORE INTO t1 (c1) VALUES('abc');
22
CREATE TABLE t1(c1 VARBINARY(10) NULL UNIQUE);
23
INSERT INTO t1 (c1) VALUES('abc');
24
INSERT INTO t1 (c1) VALUES('def');
25
INSERT IGNORE INTO t1 (c1) VALUES('abc');