2 DROP TABLE IF EXISTS t1;
4 CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
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) NOT NULL PRIMARY KEY);
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) NOT NULL PRIMARY KEY);
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) NOT NULL PRIMARY KEY);
23 INSERT INTO t1 (c1) VALUES('abc');
24 INSERT INTO t1 (c1) VALUES('def');
25 INSERT IGNORE INTO t1 (c1) VALUES('abc');