1
DROP TABLE IF EXISTS t1;
2
CREATE TEMPORARY TABLE t1(c1 BIT NULL);
7
t1 CREATE TEMPORARY TABLE `t1` (
8
`c1` bit(1) DEFAULT NULL
9
) ENGINE=ENGINE DEFAULT CHARSET=latin1
13
CREATE TEMPORARY TABLE t1(c1 TINYINT NULL);
18
t1 CREATE TEMPORARY TABLE `t1` (
19
`c1` tinyint(4) DEFAULT NULL
20
) ENGINE=ENGINE DEFAULT CHARSET=latin1
24
CREATE TEMPORARY TABLE t1(c1 SMALLINT NULL);
29
t1 CREATE TEMPORARY TABLE `t1` (
30
`c1` smallint(6) DEFAULT NULL
31
) ENGINE=ENGINE DEFAULT CHARSET=latin1
35
CREATE TEMPORARY TABLE t1(c1 MEDIUMINT NULL);
40
t1 CREATE TEMPORARY TABLE `t1` (
41
`c1` mediumint(9) DEFAULT NULL
42
) ENGINE=ENGINE DEFAULT CHARSET=latin1
46
CREATE TEMPORARY TABLE t1(c1 INT NULL);
51
t1 CREATE TEMPORARY TABLE `t1` (
52
`c1` int(11) DEFAULT NULL
53
) ENGINE=ENGINE DEFAULT CHARSET=latin1
57
CREATE TEMPORARY TABLE t1(c1 INTEGER NULL);
62
t1 CREATE TEMPORARY TABLE `t1` (
63
`c1` int(11) DEFAULT NULL
64
) ENGINE=ENGINE DEFAULT CHARSET=latin1
68
CREATE TEMPORARY TABLE t1(c1 BIGINT NULL);
73
t1 CREATE TEMPORARY TABLE `t1` (
74
`c1` bigint(20) DEFAULT NULL
75
) ENGINE=ENGINE DEFAULT CHARSET=latin1
79
CREATE TEMPORARY TABLE t1(c1 DECIMAL NULL);
84
t1 CREATE TEMPORARY TABLE `t1` (
85
`c1` decimal(10,0) DEFAULT NULL
86
) ENGINE=ENGINE DEFAULT CHARSET=latin1
90
CREATE TEMPORARY TABLE t1(c1 DEC NULL);
95
t1 CREATE TEMPORARY TABLE `t1` (
96
`c1` decimal(10,0) DEFAULT NULL
97
) ENGINE=ENGINE DEFAULT CHARSET=latin1
101
CREATE TEMPORARY TABLE t1(c1 FIXED NULL);
104
SHOW CREATE TABLE t1;
106
t1 CREATE TEMPORARY TABLE `t1` (
107
`c1` decimal(10,0) DEFAULT NULL
108
) ENGINE=ENGINE DEFAULT CHARSET=latin1
112
CREATE TEMPORARY TABLE t1(c1 NUMERIC NULL);
115
SHOW CREATE TABLE t1;
117
t1 CREATE TEMPORARY TABLE `t1` (
118
`c1` decimal(10,0) DEFAULT NULL
119
) ENGINE=ENGINE DEFAULT CHARSET=latin1
123
CREATE TEMPORARY TABLE t1(c1 DOUBLE NULL);
126
SHOW CREATE TABLE t1;
128
t1 CREATE TEMPORARY TABLE `t1` (
129
`c1` double DEFAULT NULL
130
) ENGINE=ENGINE DEFAULT CHARSET=latin1
134
CREATE TEMPORARY TABLE t1(c1 REAL NULL);
137
SHOW CREATE TABLE t1;
139
t1 CREATE TEMPORARY TABLE `t1` (
140
`c1` double DEFAULT NULL
141
) ENGINE=ENGINE DEFAULT CHARSET=latin1
145
CREATE TEMPORARY TABLE t1(c1 DOUBLE PRECISION NULL);
148
SHOW CREATE TABLE t1;
150
t1 CREATE TEMPORARY TABLE `t1` (
151
`c1` double DEFAULT NULL
152
) ENGINE=ENGINE DEFAULT CHARSET=latin1
156
CREATE TEMPORARY TABLE t1(c1 FLOAT NULL);
159
SHOW CREATE TABLE t1;
161
t1 CREATE TEMPORARY TABLE `t1` (
162
`c1` float DEFAULT NULL
163
) ENGINE=ENGINE DEFAULT CHARSET=latin1
167
CREATE TEMPORARY TABLE t1(c1 DATE NULL);
170
SHOW CREATE TABLE t1;
172
t1 CREATE TEMPORARY TABLE `t1` (
173
`c1` date DEFAULT NULL
174
) ENGINE=ENGINE DEFAULT CHARSET=latin1
178
CREATE TEMPORARY TABLE t1(c1 TIME NULL);
181
SHOW CREATE TABLE t1;
183
t1 CREATE TEMPORARY TABLE `t1` (
184
`c1` time DEFAULT NULL
185
) ENGINE=ENGINE DEFAULT CHARSET=latin1
189
CREATE TEMPORARY TABLE t1(c1 TIMESTAMP NULL);
192
SHOW CREATE TABLE t1;
194
t1 CREATE TEMPORARY TABLE `t1` (
195
`c1` timestamp NULL DEFAULT NULL
196
) ENGINE=ENGINE DEFAULT CHARSET=latin1
200
CREATE TEMPORARY TABLE t1(c1 DATETIME NULL);
203
SHOW CREATE TABLE t1;
205
t1 CREATE TEMPORARY TABLE `t1` (
206
`c1` datetime DEFAULT NULL
207
) ENGINE=ENGINE DEFAULT CHARSET=latin1
211
CREATE TEMPORARY TABLE t1(c1 YEAR NULL);
214
SHOW CREATE TABLE t1;
216
t1 CREATE TEMPORARY TABLE `t1` (
217
`c1` year(4) DEFAULT NULL
218
) ENGINE=ENGINE DEFAULT CHARSET=latin1
222
CREATE TEMPORARY TABLE t1(c1 TINYBLOB NULL);
225
SHOW CREATE TABLE t1;
227
t1 CREATE TEMPORARY TABLE `t1` (
229
) ENGINE=ENGINE DEFAULT CHARSET=latin1
233
CREATE TEMPORARY TABLE t1(c1 BLOB NULL);
236
SHOW CREATE TABLE t1;
238
t1 CREATE TEMPORARY TABLE `t1` (
240
) ENGINE=ENGINE DEFAULT CHARSET=latin1
244
CREATE TEMPORARY TABLE t1(c1 MEDIUMBLOB NULL);
247
SHOW CREATE TABLE t1;
249
t1 CREATE TEMPORARY TABLE `t1` (
251
) ENGINE=ENGINE DEFAULT CHARSET=latin1
255
CREATE TEMPORARY TABLE t1(c1 LONGBLOB NULL);
258
SHOW CREATE TABLE t1;
260
t1 CREATE TEMPORARY TABLE `t1` (
262
) ENGINE=ENGINE DEFAULT CHARSET=latin1
266
CREATE TEMPORARY TABLE t1(c1 TINYTEXT NULL);
269
SHOW CREATE TABLE t1;
271
t1 CREATE TEMPORARY TABLE `t1` (
273
) ENGINE=ENGINE DEFAULT CHARSET=latin1
277
CREATE TEMPORARY TABLE t1(c1 TEXT NULL);
280
SHOW CREATE TABLE t1;
282
t1 CREATE TEMPORARY TABLE `t1` (
284
) ENGINE=ENGINE DEFAULT CHARSET=latin1
288
CREATE TEMPORARY TABLE t1(c1 MEDIUMTEXT NULL);
291
SHOW CREATE TABLE t1;
293
t1 CREATE TEMPORARY TABLE `t1` (
295
) ENGINE=ENGINE DEFAULT CHARSET=latin1
299
CREATE TEMPORARY TABLE t1(c1 LONGTEXT NULL);
302
SHOW CREATE TABLE t1;
304
t1 CREATE TEMPORARY TABLE `t1` (
306
) ENGINE=ENGINE DEFAULT CHARSET=latin1
310
CREATE TEMPORARY TABLE t1(c1 BIT NOT NULL);
313
SHOW CREATE TABLE t1;
315
t1 CREATE TEMPORARY TABLE `t1` (
317
) ENGINE=ENGINE DEFAULT CHARSET=latin1
321
CREATE TEMPORARY TABLE t1(c1 TINYINT NOT NULL);
324
SHOW CREATE TABLE t1;
326
t1 CREATE TEMPORARY TABLE `t1` (
327
`c1` tinyint(4) NOT NULL
328
) ENGINE=ENGINE DEFAULT CHARSET=latin1
332
CREATE TEMPORARY TABLE t1(c1 SMALLINT NOT NULL);
335
SHOW CREATE TABLE t1;
337
t1 CREATE TEMPORARY TABLE `t1` (
338
`c1` smallint(6) NOT NULL
339
) ENGINE=ENGINE DEFAULT CHARSET=latin1
343
CREATE TEMPORARY TABLE t1(c1 MEDIUMINT NOT NULL);
346
SHOW CREATE TABLE t1;
348
t1 CREATE TEMPORARY TABLE `t1` (
349
`c1` mediumint(9) NOT NULL
350
) ENGINE=ENGINE DEFAULT CHARSET=latin1
354
CREATE TEMPORARY TABLE t1(c1 INT NOT NULL);
357
SHOW CREATE TABLE t1;
359
t1 CREATE TEMPORARY TABLE `t1` (
360
`c1` int(11) NOT NULL
361
) ENGINE=ENGINE DEFAULT CHARSET=latin1
365
CREATE TEMPORARY TABLE t1(c1 INTEGER NOT NULL);
368
SHOW CREATE TABLE t1;
370
t1 CREATE TEMPORARY TABLE `t1` (
371
`c1` int(11) NOT NULL
372
) ENGINE=ENGINE DEFAULT CHARSET=latin1
376
CREATE TEMPORARY TABLE t1(c1 BIGINT NOT NULL);
379
SHOW CREATE TABLE t1;
381
t1 CREATE TEMPORARY TABLE `t1` (
382
`c1` bigint(20) NOT NULL
383
) ENGINE=ENGINE DEFAULT CHARSET=latin1
387
CREATE TEMPORARY TABLE t1(c1 DECIMAL NOT NULL);
390
SHOW CREATE TABLE t1;
392
t1 CREATE TEMPORARY TABLE `t1` (
393
`c1` decimal(10,0) NOT NULL
394
) ENGINE=ENGINE DEFAULT CHARSET=latin1
398
CREATE TEMPORARY TABLE t1(c1 DEC NOT NULL);
401
SHOW CREATE TABLE t1;
403
t1 CREATE TEMPORARY TABLE `t1` (
404
`c1` decimal(10,0) NOT NULL
405
) ENGINE=ENGINE DEFAULT CHARSET=latin1
409
CREATE TEMPORARY TABLE t1(c1 FIXED NOT NULL);
412
SHOW CREATE TABLE t1;
414
t1 CREATE TEMPORARY TABLE `t1` (
415
`c1` decimal(10,0) NOT NULL
416
) ENGINE=ENGINE DEFAULT CHARSET=latin1
420
CREATE TEMPORARY TABLE t1(c1 NUMERIC NOT NULL);
423
SHOW CREATE TABLE t1;
425
t1 CREATE TEMPORARY TABLE `t1` (
426
`c1` decimal(10,0) NOT NULL
427
) ENGINE=ENGINE DEFAULT CHARSET=latin1
431
CREATE TEMPORARY TABLE t1(c1 DOUBLE NOT NULL);
434
SHOW CREATE TABLE t1;
436
t1 CREATE TEMPORARY TABLE `t1` (
438
) ENGINE=ENGINE DEFAULT CHARSET=latin1
442
CREATE TEMPORARY TABLE t1(c1 REAL NOT NULL);
445
SHOW CREATE TABLE t1;
447
t1 CREATE TEMPORARY TABLE `t1` (
449
) ENGINE=ENGINE DEFAULT CHARSET=latin1
453
CREATE TEMPORARY TABLE t1(c1 DOUBLE PRECISION NOT NULL);
456
SHOW CREATE TABLE t1;
458
t1 CREATE TEMPORARY TABLE `t1` (
460
) ENGINE=ENGINE DEFAULT CHARSET=latin1
464
CREATE TEMPORARY TABLE t1(c1 FLOAT NOT NULL);
467
SHOW CREATE TABLE t1;
469
t1 CREATE TEMPORARY TABLE `t1` (
471
) ENGINE=ENGINE DEFAULT CHARSET=latin1
475
CREATE TEMPORARY TABLE t1(c1 DATE NOT NULL);
478
SHOW CREATE TABLE t1;
480
t1 CREATE TEMPORARY TABLE `t1` (
482
) ENGINE=ENGINE DEFAULT CHARSET=latin1
486
CREATE TEMPORARY TABLE t1(c1 TIME NOT NULL);
489
SHOW CREATE TABLE t1;
491
t1 CREATE TEMPORARY TABLE `t1` (
493
) ENGINE=ENGINE DEFAULT CHARSET=latin1
497
CREATE TEMPORARY TABLE t1(c1 TIMESTAMP NOT NULL);
500
SHOW CREATE TABLE t1;
502
t1 CREATE TEMPORARY TABLE `t1` (
503
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
504
) ENGINE=ENGINE DEFAULT CHARSET=latin1
508
CREATE TEMPORARY TABLE t1(c1 DATETIME NOT NULL);
511
SHOW CREATE TABLE t1;
513
t1 CREATE TEMPORARY TABLE `t1` (
514
`c1` datetime NOT NULL
515
) ENGINE=ENGINE DEFAULT CHARSET=latin1
519
CREATE TEMPORARY TABLE t1(c1 YEAR NOT NULL);
522
SHOW CREATE TABLE t1;
524
t1 CREATE TEMPORARY TABLE `t1` (
525
`c1` year(4) NOT NULL
526
) ENGINE=ENGINE DEFAULT CHARSET=latin1
530
CREATE TEMPORARY TABLE t1(c1 TINYBLOB NOT NULL);
533
SHOW CREATE TABLE t1;
535
t1 CREATE TEMPORARY TABLE `t1` (
536
`c1` tinyblob NOT NULL
537
) ENGINE=ENGINE DEFAULT CHARSET=latin1
541
CREATE TEMPORARY TABLE t1(c1 BLOB NOT NULL);
544
SHOW CREATE TABLE t1;
546
t1 CREATE TEMPORARY TABLE `t1` (
548
) ENGINE=ENGINE DEFAULT CHARSET=latin1
552
CREATE TEMPORARY TABLE t1(c1 MEDIUMBLOB NOT NULL);
555
SHOW CREATE TABLE t1;
557
t1 CREATE TEMPORARY TABLE `t1` (
558
`c1` mediumblob NOT NULL
559
) ENGINE=ENGINE DEFAULT CHARSET=latin1
563
CREATE TEMPORARY TABLE t1(c1 LONGBLOB NOT NULL);
566
SHOW CREATE TABLE t1;
568
t1 CREATE TEMPORARY TABLE `t1` (
569
`c1` longblob NOT NULL
570
) ENGINE=ENGINE DEFAULT CHARSET=latin1
574
CREATE TEMPORARY TABLE t1(c1 TINYTEXT NOT NULL);
577
SHOW CREATE TABLE t1;
579
t1 CREATE TEMPORARY TABLE `t1` (
580
`c1` tinytext NOT NULL
581
) ENGINE=ENGINE DEFAULT CHARSET=latin1
585
CREATE TEMPORARY TABLE t1(c1 TEXT NOT NULL);
588
SHOW CREATE TABLE t1;
590
t1 CREATE TEMPORARY TABLE `t1` (
592
) ENGINE=ENGINE DEFAULT CHARSET=latin1
596
CREATE TEMPORARY TABLE t1(c1 MEDIUMTEXT NOT NULL);
599
SHOW CREATE TABLE t1;
601
t1 CREATE TEMPORARY TABLE `t1` (
602
`c1` mediumtext NOT NULL
603
) ENGINE=ENGINE DEFAULT CHARSET=latin1
607
CREATE TEMPORARY TABLE t1(c1 LONGTEXT NOT NULL);
610
SHOW CREATE TABLE t1;
612
t1 CREATE TEMPORARY TABLE `t1` (
613
`c1` longtext NOT NULL
614
) ENGINE=ENGINE DEFAULT CHARSET=latin1