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');
8
INSERT INTO t1 (c1) VALUES('abc');
11
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
12
INSERT INTO t1 (c1) VALUES('abc');
13
INSERT INTO t1 (c1) VALUES('def');
15
INSERT INTO t1 (c1) VALUES('abc');
18
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
19
INSERT INTO t1 (c1) VALUES('abc');
20
INSERT INTO t1 (c1) VALUES('def');
22
INSERT INTO t1 (c1) VALUES('abc');
25
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
26
INSERT INTO t1 (c1) VALUES('abc');
27
INSERT INTO t1 (c1) VALUES('def');
29
INSERT INTO t1 (c1) VALUES('abc');