1 DROP TABLE IF EXISTS t9;
2 CREATE TABLE t9(c1 CHAR(20) NOT NULL PRIMARY KEY);
9 `c1` char(20) NOT NULL,
11 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
12 ALTER TABLE t9 DROP PRIMARY KEY;
18 t9 CREATE TABLE `t9` (
19 `c1` char(20) NOT NULL
20 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
24 CREATE TABLE t9(c1 VARCHAR(20) NOT NULL PRIMARY KEY);
30 t9 CREATE TABLE `t9` (
31 `c1` varchar(20) NOT NULL,
33 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
34 ALTER TABLE t9 DROP PRIMARY KEY;
40 t9 CREATE TABLE `t9` (
41 `c1` varchar(20) NOT NULL
42 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
46 CREATE TABLE t9(c1 BINARY(20) NOT NULL PRIMARY KEY);
52 t9 CREATE TABLE `t9` (
53 `c1` binary(20) NOT NULL,
55 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
56 ALTER TABLE t9 DROP PRIMARY KEY;
62 t9 CREATE TABLE `t9` (
63 `c1` binary(20) NOT NULL
64 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
68 CREATE TABLE t9(c1 VARBINARY(20) NOT NULL PRIMARY KEY);
74 t9 CREATE TABLE `t9` (
75 `c1` varbinary(20) NOT NULL,
77 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
78 ALTER TABLE t9 DROP PRIMARY KEY;
84 t9 CREATE TABLE `t9` (
85 `c1` varbinary(20) NOT NULL
86 ) ENGINE=ENGINE DEFAULT CHARSET=latin1