1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 BIT NULL) COMMENT = 'This table has a BIT column';
9
`c1` bit(1) DEFAULT NULL
10
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a BIT column'
14
CREATE TABLE t1(c1 TINYINT NULL) COMMENT = 'This table has a TINYINT column';
20
t1 CREATE TABLE `t1` (
21
`c1` tinyint(4) DEFAULT NULL
22
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a TINYINT column'
26
CREATE TABLE t1(c1 SMALLINT NULL) COMMENT = 'This table has a SMALLINT column';
32
t1 CREATE TABLE `t1` (
33
`c1` smallint(6) DEFAULT NULL
34
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a SMALLINT column'
38
CREATE TABLE t1(c1 MEDIUMINT NULL) COMMENT = 'This table has a MEDIUMINT column';
44
t1 CREATE TABLE `t1` (
45
`c1` mediumint(9) DEFAULT NULL
46
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a MEDIUMINT column'
50
CREATE TABLE t1(c1 INT NULL) COMMENT = 'This table has a INT column';
56
t1 CREATE TABLE `t1` (
57
`c1` int(11) DEFAULT NULL
58
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a INT column'
62
CREATE TABLE t1(c1 INTEGER NULL) COMMENT = 'This table has a INTEGER column';
68
t1 CREATE TABLE `t1` (
69
`c1` int(11) DEFAULT NULL
70
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a INTEGER column'
74
CREATE TABLE t1(c1 BIGINT NULL) COMMENT = 'This table has a BIGINT column';
80
t1 CREATE TABLE `t1` (
81
`c1` bigint(20) DEFAULT NULL
82
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a BIGINT column'
86
CREATE TABLE t1(c1 REAL NULL) COMMENT = 'This table has a REAL column';
92
t1 CREATE TABLE `t1` (
93
`c1` double DEFAULT NULL
94
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a REAL column'
98
CREATE TABLE t1(c1 DOUBLE NULL) COMMENT = 'This table has a DOUBLE column';
102
SHOW CREATE TABLE t1;
104
t1 CREATE TABLE `t1` (
105
`c1` double DEFAULT NULL
106
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a DOUBLE column'
110
CREATE TABLE t1(c1 FLOAT NULL) COMMENT = 'This table has a FLOAT column';
114
SHOW CREATE TABLE t1;
116
t1 CREATE TABLE `t1` (
117
`c1` float DEFAULT NULL
118
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a FLOAT column'
122
CREATE TABLE t1(c1 DECIMAL NULL) COMMENT = 'This table has a DECIMAL column';
126
SHOW CREATE TABLE t1;
128
t1 CREATE TABLE `t1` (
129
`c1` decimal(10,0) DEFAULT NULL
130
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a DECIMAL column'
134
CREATE TABLE t1(c1 NUMERIC NULL) COMMENT = 'This table has a NUMERIC column';
138
SHOW CREATE TABLE t1;
140
t1 CREATE TABLE `t1` (
141
`c1` decimal(10,0) DEFAULT NULL
142
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a NUMERIC column'
146
CREATE TABLE t1(c1 DATE NULL) COMMENT = 'This table has a DATE column';
150
SHOW CREATE TABLE t1;
152
t1 CREATE TABLE `t1` (
153
`c1` date DEFAULT NULL
154
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a DATE column'
158
CREATE TABLE t1(c1 TIME NULL) COMMENT = 'This table has a TIME column';
162
SHOW CREATE TABLE t1;
164
t1 CREATE TABLE `t1` (
165
`c1` time DEFAULT NULL
166
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a TIME column'
170
CREATE TABLE t1(c1 DATETIME NULL) COMMENT = 'This table has a DATETIME column';
174
SHOW CREATE TABLE t1;
176
t1 CREATE TABLE `t1` (
177
`c1` datetime DEFAULT NULL
178
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a DATETIME column'
182
CREATE TABLE t1(c1 TIMESTAMP NULL) COMMENT = 'This table has a TIMESTAMP column';
186
SHOW CREATE TABLE t1;
188
t1 CREATE TABLE `t1` (
189
`c1` timestamp NULL DEFAULT NULL
190
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a TIMESTAMP column'
194
CREATE TABLE t1(c1 YEAR NULL) COMMENT = 'This table has a YEAR column';
198
SHOW CREATE TABLE t1;
200
t1 CREATE TABLE `t1` (
201
`c1` year(4) DEFAULT NULL
202
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a YEAR column'
206
CREATE TABLE t1(c1 TINYBLOB NULL) COMMENT = 'This table has a TINYBLOB column';
210
SHOW CREATE TABLE t1;
212
t1 CREATE TABLE `t1` (
214
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a TINYBLOB column'
218
CREATE TABLE t1(c1 BLOB NULL) COMMENT = 'This table has a BLOB column';
222
SHOW CREATE TABLE t1;
224
t1 CREATE TABLE `t1` (
226
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a BLOB column'
230
CREATE TABLE t1(c1 MEDIUMBLOB NULL) COMMENT = 'This table has a MEDIUMBLOB column';
234
SHOW CREATE TABLE t1;
236
t1 CREATE TABLE `t1` (
238
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a MEDIUMBLOB column'
242
CREATE TABLE t1(c1 LONGBLOB NULL) COMMENT = 'This table has a LONGBLOB column';
246
SHOW CREATE TABLE t1;
248
t1 CREATE TABLE `t1` (
250
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a LONGBLOB column'
254
CREATE TABLE t1(c1 TINYTEXT NULL) COMMENT = 'This table has a TINYTEXT column';
258
SHOW CREATE TABLE t1;
260
t1 CREATE TABLE `t1` (
262
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a TINYTEXT column'
266
CREATE TABLE t1(c1 TEXT NULL) COMMENT = 'This table has a TEXT column';
270
SHOW CREATE TABLE t1;
272
t1 CREATE TABLE `t1` (
274
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a TEXT column'
278
CREATE TABLE t1(c1 MEDIUMTEXT NULL) COMMENT = 'This table has a MEDIUMTEXT column';
282
SHOW CREATE TABLE t1;
284
t1 CREATE TABLE `t1` (
286
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a MEDIUMTEXT column'
290
CREATE TABLE t1(c1 LONGTEXT NULL) COMMENT = 'This table has a LONGTEXT column';
294
SHOW CREATE TABLE t1;
296
t1 CREATE TABLE `t1` (
298
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a LONGTEXT column'