1
DROP TABLE IF EXISTS m2;
2
CREATE TABLE m2(c1 CHAR(1) NULL, c2 CHAR(5) NOT NULL, c3 CHAR(255) NULL, c4 CHAR(4) NOT NULL PRIMARY KEY, c5 CHAR(30) NOT NULL UNIQUE KEY);
9
`c1` char(1) DEFAULT NULL,
10
`c2` char(5) NOT NULL,
11
`c3` char(255) DEFAULT NULL,
12
`c4` char(4) NOT NULL,
13
`c5` char(30) NOT NULL,
15
UNIQUE KEY `c5` (`c5`)
16
) ENGINE=ENGINE DEFAULT CHARSET=latin1
20
CREATE TABLE m2(c1 VARCHAR(1) NULL, c2 VARCHAR(5) NOT NULL, c3 VARCHAR(255) NULL, c4 VARCHAR(4) NOT NULL PRIMARY KEY, c5 VARCHAR(30) NOT NULL UNIQUE KEY);
26
m2 CREATE TABLE `m2` (
27
`c1` varchar(1) DEFAULT NULL,
28
`c2` varchar(5) NOT NULL,
29
`c3` varchar(255) DEFAULT NULL,
30
`c4` varchar(4) NOT NULL,
31
`c5` varchar(30) NOT NULL,
33
UNIQUE KEY `c5` (`c5`)
34
) ENGINE=ENGINE DEFAULT CHARSET=latin1
38
CREATE TABLE m2(c1 BINARY(1) NULL, c2 BINARY(5) NOT NULL, c3 BINARY(255) NULL, c4 BINARY(4) NOT NULL PRIMARY KEY, c5 BINARY(30) NOT NULL UNIQUE KEY);
44
m2 CREATE TABLE `m2` (
45
`c1` binary(1) DEFAULT NULL,
46
`c2` binary(5) NOT NULL,
47
`c3` binary(255) DEFAULT NULL,
48
`c4` binary(4) NOT NULL,
49
`c5` binary(30) NOT NULL,
51
UNIQUE KEY `c5` (`c5`)
52
) ENGINE=ENGINE DEFAULT CHARSET=latin1
56
CREATE TABLE m2(c1 VARBINARY(1) NULL, c2 VARBINARY(5) NOT NULL, c3 VARBINARY(255) NULL, c4 VARBINARY(4) NOT NULL PRIMARY KEY, c5 VARBINARY(30) NOT NULL UNIQUE KEY);
62
m2 CREATE TABLE `m2` (
63
`c1` varbinary(1) DEFAULT NULL,
64
`c2` varbinary(5) NOT NULL,
65
`c3` varbinary(255) DEFAULT NULL,
66
`c4` varbinary(4) NOT NULL,
67
`c5` varbinary(30) NOT NULL,
69
UNIQUE KEY `c5` (`c5`)
70
) ENGINE=ENGINE DEFAULT CHARSET=latin1