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