1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 BIT NULL);
3 CREATE INDEX i1 ON t1(c1);
10 `c1` bit(1) DEFAULT NULL,
12 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
16 CREATE TABLE t1(c1 TINYINT NULL);
17 CREATE INDEX i1 ON t1(c1);
23 t1 CREATE TABLE `t1` (
24 `c1` tinyint(4) DEFAULT NULL,
26 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
30 CREATE TABLE t1(c1 SMALLINT NULL);
31 CREATE INDEX i1 ON t1(c1);
37 t1 CREATE TABLE `t1` (
38 `c1` smallint(6) DEFAULT NULL,
40 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
44 CREATE TABLE t1(c1 MEDIUMINT NULL);
45 CREATE INDEX i1 ON t1(c1);
51 t1 CREATE TABLE `t1` (
52 `c1` mediumint(9) DEFAULT NULL,
54 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
58 CREATE TABLE t1(c1 INT NULL);
59 CREATE INDEX i1 ON t1(c1);
65 t1 CREATE TABLE `t1` (
66 `c1` int(11) DEFAULT NULL,
68 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
72 CREATE TABLE t1(c1 INTEGER NULL);
73 CREATE INDEX i1 ON t1(c1);
79 t1 CREATE TABLE `t1` (
80 `c1` int(11) DEFAULT NULL,
82 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
86 CREATE TABLE t1(c1 BIGINT NULL);
87 CREATE INDEX i1 ON t1(c1);
93 t1 CREATE TABLE `t1` (
94 `c1` bigint(20) DEFAULT NULL,
96 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
100 CREATE TABLE t1(c1 REAL NULL);
101 CREATE INDEX i1 ON t1(c1);
105 SHOW CREATE TABLE t1;
107 t1 CREATE TABLE `t1` (
108 `c1` double DEFAULT NULL,
110 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
114 CREATE TABLE t1(c1 DOUBLE NULL);
115 CREATE INDEX i1 ON t1(c1);
119 SHOW CREATE TABLE t1;
121 t1 CREATE TABLE `t1` (
122 `c1` double DEFAULT NULL,
124 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
128 CREATE TABLE t1(c1 FLOAT NULL);
129 CREATE INDEX i1 ON t1(c1);
133 SHOW CREATE TABLE t1;
135 t1 CREATE TABLE `t1` (
136 `c1` float DEFAULT NULL,
138 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
142 CREATE TABLE t1(c1 DECIMAL NULL);
143 CREATE INDEX i1 ON t1(c1);
147 SHOW CREATE TABLE t1;
149 t1 CREATE TABLE `t1` (
150 `c1` decimal(10,0) DEFAULT NULL,
152 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
156 CREATE TABLE t1(c1 NUMERIC NULL);
157 CREATE INDEX i1 ON t1(c1);
161 SHOW CREATE TABLE t1;
163 t1 CREATE TABLE `t1` (
164 `c1` decimal(10,0) DEFAULT NULL,
166 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
170 CREATE TABLE t1(c1 DATE NULL);
171 CREATE INDEX i1 ON t1(c1);
175 SHOW CREATE TABLE t1;
177 t1 CREATE TABLE `t1` (
178 `c1` date DEFAULT NULL,
180 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
184 CREATE TABLE t1(c1 TIME NULL);
185 CREATE INDEX i1 ON t1(c1);
189 SHOW CREATE TABLE t1;
191 t1 CREATE TABLE `t1` (
192 `c1` time DEFAULT NULL,
194 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
198 CREATE TABLE t1(c1 TIMESTAMP NULL);
199 CREATE INDEX i1 ON t1(c1);
203 SHOW CREATE TABLE t1;
205 t1 CREATE TABLE `t1` (
206 `c1` timestamp NULL DEFAULT NULL,
208 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
212 CREATE TABLE t1(c1 YEAR NULL);
213 CREATE INDEX i1 ON t1(c1);
217 SHOW CREATE TABLE t1;
219 t1 CREATE TABLE `t1` (
220 `c1` year(4) DEFAULT NULL,
222 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
226 CREATE TABLE t1(c1 BIT NOT NULL);
227 CREATE INDEX i1 ON t1(c1);
231 SHOW CREATE TABLE t1;
233 t1 CREATE TABLE `t1` (
234 `c1` bit(1) NOT NULL,
236 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
240 CREATE TABLE t1(c1 TINYINT NOT NULL);
241 CREATE INDEX i1 ON t1(c1);
245 SHOW CREATE TABLE t1;
247 t1 CREATE TABLE `t1` (
248 `c1` tinyint(4) NOT NULL,
250 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
254 CREATE TABLE t1(c1 SMALLINT NOT NULL);
255 CREATE INDEX i1 ON t1(c1);
259 SHOW CREATE TABLE t1;
261 t1 CREATE TABLE `t1` (
262 `c1` smallint(6) NOT NULL,
264 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
268 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
269 CREATE INDEX i1 ON t1(c1);
273 SHOW CREATE TABLE t1;
275 t1 CREATE TABLE `t1` (
276 `c1` mediumint(9) NOT NULL,
278 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
282 CREATE TABLE t1(c1 INT NOT NULL);
283 CREATE INDEX i1 ON t1(c1);
287 SHOW CREATE TABLE t1;
289 t1 CREATE TABLE `t1` (
290 `c1` int(11) NOT NULL,
292 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
296 CREATE TABLE t1(c1 INTEGER NOT NULL);
297 CREATE INDEX i1 ON t1(c1);
301 SHOW CREATE TABLE t1;
303 t1 CREATE TABLE `t1` (
304 `c1` int(11) NOT NULL,
306 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
310 CREATE TABLE t1(c1 BIGINT NOT NULL);
311 CREATE INDEX i1 ON t1(c1);
315 SHOW CREATE TABLE t1;
317 t1 CREATE TABLE `t1` (
318 `c1` bigint(20) NOT NULL,
320 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
324 CREATE TABLE t1(c1 REAL NOT NULL);
325 CREATE INDEX i1 ON t1(c1);
329 SHOW CREATE TABLE t1;
331 t1 CREATE TABLE `t1` (
332 `c1` double NOT NULL,
334 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
338 CREATE TABLE t1(c1 DOUBLE NOT NULL);
339 CREATE INDEX i1 ON t1(c1);
343 SHOW CREATE TABLE t1;
345 t1 CREATE TABLE `t1` (
346 `c1` double NOT NULL,
348 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
352 CREATE TABLE t1(c1 FLOAT NOT NULL);
353 CREATE INDEX i1 ON t1(c1);
357 SHOW CREATE TABLE t1;
359 t1 CREATE TABLE `t1` (
362 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
366 CREATE TABLE t1(c1 DECIMAL NOT NULL);
367 CREATE INDEX i1 ON t1(c1);
371 SHOW CREATE TABLE t1;
373 t1 CREATE TABLE `t1` (
374 `c1` decimal(10,0) NOT NULL,
376 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
380 CREATE TABLE t1(c1 NUMERIC NOT NULL);
381 CREATE INDEX i1 ON t1(c1);
385 SHOW CREATE TABLE t1;
387 t1 CREATE TABLE `t1` (
388 `c1` decimal(10,0) NOT NULL,
390 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
394 CREATE TABLE t1(c1 DATE NOT NULL);
395 CREATE INDEX i1 ON t1(c1);
399 SHOW CREATE TABLE t1;
401 t1 CREATE TABLE `t1` (
404 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
408 CREATE TABLE t1(c1 TIME NOT NULL);
409 CREATE INDEX i1 ON t1(c1);
413 SHOW CREATE TABLE t1;
415 t1 CREATE TABLE `t1` (
418 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
422 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
423 CREATE INDEX i1 ON t1(c1);
427 SHOW CREATE TABLE t1;
429 t1 CREATE TABLE `t1` (
430 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
432 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
436 CREATE TABLE t1(c1 YEAR NOT NULL);
437 CREATE INDEX i1 ON t1(c1);
441 SHOW CREATE TABLE t1;
443 t1 CREATE TABLE `t1` (
444 `c1` year(4) NOT NULL,
446 ) ENGINE=ENGINE DEFAULT CHARSET=latin1