1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 CHAR(10) NULL COMMENT 'This is a CHAR column');
9
`c1` char(10) DEFAULT NULL COMMENT 'This is a CHAR column'
10
) ENGINE=ENGINE DEFAULT CHARSET=latin1
14
CREATE TABLE t1(c1 VARCHAR(10) NULL COMMENT 'This is a VARCHAR column');
20
t1 CREATE TABLE `t1` (
21
`c1` varchar(10) DEFAULT NULL COMMENT 'This is a VARCHAR column'
22
) ENGINE=ENGINE DEFAULT CHARSET=latin1
26
CREATE TABLE t1(c1 BINARY(10) NULL COMMENT 'This is a BINARY column');
32
t1 CREATE TABLE `t1` (
33
`c1` binary(10) DEFAULT NULL COMMENT 'This is a BINARY column'
34
) ENGINE=ENGINE DEFAULT CHARSET=latin1
38
CREATE TABLE t1(c1 VARBINARY(10) NULL COMMENT 'This is a VARBINARY column');
44
t1 CREATE TABLE `t1` (
45
`c1` varbinary(10) DEFAULT NULL COMMENT 'This is a VARBINARY column'
46
) ENGINE=ENGINE DEFAULT CHARSET=latin1