Debian Codegraph @

mysql-test/suite/engines/funcs/r/tc_structure_create_select.result

raw
1 DROP TABLE IF EXISTS src,dest;
2 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BIT NULL, PRIMARY KEY(c1));
3 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
4 SHOW TABLES;
5 Tables_in_test
6 dst
7 src
8 SHOW CREATE TABLE dst;
9 Table Create Table
10 dst CREATE TABLE `dst` (
11 `c1` int NOT NULL AUTO_INCREMENT,
12 `c2` bit(1) DEFAULT NULL,
13 PRIMARY KEY (`c1`)
14 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
15 DROP TABLE dst;
16 SHOW TABLES;
17 Tables_in_test
18 src
19 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
20 SHOW TABLES;
21 Tables_in_test
22 dst
23 src
24 SHOW CREATE TABLE dst;
25 Table Create Table
26 dst CREATE TABLE `dst` (
27 `c1` int NOT NULL AUTO_INCREMENT,
28 `c2` bit(1) DEFAULT NULL,
29 PRIMARY KEY (`c1`)
30 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
31 DROP TABLE dst;
32 SHOW TABLES;
33 Tables_in_test
34 src
35 DROP TABLE src;
36 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYINT NULL, PRIMARY KEY(c1));
37 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
38 SHOW TABLES;
39 Tables_in_test
40 dst
41 src
42 SHOW CREATE TABLE dst;
43 Table Create Table
44 dst CREATE TABLE `dst` (
45 `c1` int NOT NULL AUTO_INCREMENT,
46 `c2` tinyint DEFAULT NULL,
47 PRIMARY KEY (`c1`)
48 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
49 DROP TABLE dst;
50 SHOW TABLES;
51 Tables_in_test
52 src
53 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
54 SHOW TABLES;
55 Tables_in_test
56 dst
57 src
58 SHOW CREATE TABLE dst;
59 Table Create Table
60 dst CREATE TABLE `dst` (
61 `c1` int NOT NULL AUTO_INCREMENT,
62 `c2` tinyint DEFAULT NULL,
63 PRIMARY KEY (`c1`)
64 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
65 DROP TABLE dst;
66 SHOW TABLES;
67 Tables_in_test
68 src
69 DROP TABLE src;
70 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 SMALLINT NULL, PRIMARY KEY(c1));
71 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
72 SHOW TABLES;
73 Tables_in_test
74 dst
75 src
76 SHOW CREATE TABLE dst;
77 Table Create Table
78 dst CREATE TABLE `dst` (
79 `c1` int NOT NULL AUTO_INCREMENT,
80 `c2` smallint DEFAULT NULL,
81 PRIMARY KEY (`c1`)
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
83 DROP TABLE dst;
84 SHOW TABLES;
85 Tables_in_test
86 src
87 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
88 SHOW TABLES;
89 Tables_in_test
90 dst
91 src
92 SHOW CREATE TABLE dst;
93 Table Create Table
94 dst CREATE TABLE `dst` (
95 `c1` int NOT NULL AUTO_INCREMENT,
96 `c2` smallint DEFAULT NULL,
97 PRIMARY KEY (`c1`)
98 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
99 DROP TABLE dst;
100 SHOW TABLES;
101 Tables_in_test
102 src
103 DROP TABLE src;
104 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMINT NULL, PRIMARY KEY(c1));
105 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
106 SHOW TABLES;
107 Tables_in_test
108 dst
109 src
110 SHOW CREATE TABLE dst;
111 Table Create Table
112 dst CREATE TABLE `dst` (
113 `c1` int NOT NULL AUTO_INCREMENT,
114 `c2` mediumint DEFAULT NULL,
115 PRIMARY KEY (`c1`)
116 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
117 DROP TABLE dst;
118 SHOW TABLES;
119 Tables_in_test
120 src
121 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
122 SHOW TABLES;
123 Tables_in_test
124 dst
125 src
126 SHOW CREATE TABLE dst;
127 Table Create Table
128 dst CREATE TABLE `dst` (
129 `c1` int NOT NULL AUTO_INCREMENT,
130 `c2` mediumint DEFAULT NULL,
131 PRIMARY KEY (`c1`)
132 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
133 DROP TABLE dst;
134 SHOW TABLES;
135 Tables_in_test
136 src
137 DROP TABLE src;
138 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 INT NULL, PRIMARY KEY(c1));
139 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
140 SHOW TABLES;
141 Tables_in_test
142 dst
143 src
144 SHOW CREATE TABLE dst;
145 Table Create Table
146 dst CREATE TABLE `dst` (
147 `c1` int NOT NULL AUTO_INCREMENT,
148 `c2` int DEFAULT NULL,
149 PRIMARY KEY (`c1`)
150 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
151 DROP TABLE dst;
152 SHOW TABLES;
153 Tables_in_test
154 src
155 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
156 SHOW TABLES;
157 Tables_in_test
158 dst
159 src
160 SHOW CREATE TABLE dst;
161 Table Create Table
162 dst CREATE TABLE `dst` (
163 `c1` int NOT NULL AUTO_INCREMENT,
164 `c2` int DEFAULT NULL,
165 PRIMARY KEY (`c1`)
166 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
167 DROP TABLE dst;
168 SHOW TABLES;
169 Tables_in_test
170 src
171 DROP TABLE src;
172 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 INTEGER NULL, PRIMARY KEY(c1));
173 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
174 SHOW TABLES;
175 Tables_in_test
176 dst
177 src
178 SHOW CREATE TABLE dst;
179 Table Create Table
180 dst CREATE TABLE `dst` (
181 `c1` int NOT NULL AUTO_INCREMENT,
182 `c2` int DEFAULT NULL,
183 PRIMARY KEY (`c1`)
184 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
185 DROP TABLE dst;
186 SHOW TABLES;
187 Tables_in_test
188 src
189 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
190 SHOW TABLES;
191 Tables_in_test
192 dst
193 src
194 SHOW CREATE TABLE dst;
195 Table Create Table
196 dst CREATE TABLE `dst` (
197 `c1` int NOT NULL AUTO_INCREMENT,
198 `c2` int DEFAULT NULL,
199 PRIMARY KEY (`c1`)
200 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
201 DROP TABLE dst;
202 SHOW TABLES;
203 Tables_in_test
204 src
205 DROP TABLE src;
206 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BIGINT NULL, PRIMARY KEY(c1));
207 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
208 SHOW TABLES;
209 Tables_in_test
210 dst
211 src
212 SHOW CREATE TABLE dst;
213 Table Create Table
214 dst CREATE TABLE `dst` (
215 `c1` int NOT NULL AUTO_INCREMENT,
216 `c2` bigint DEFAULT NULL,
217 PRIMARY KEY (`c1`)
218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
219 DROP TABLE dst;
220 SHOW TABLES;
221 Tables_in_test
222 src
223 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
224 SHOW TABLES;
225 Tables_in_test
226 dst
227 src
228 SHOW CREATE TABLE dst;
229 Table Create Table
230 dst CREATE TABLE `dst` (
231 `c1` int NOT NULL AUTO_INCREMENT,
232 `c2` bigint DEFAULT NULL,
233 PRIMARY KEY (`c1`)
234 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
235 DROP TABLE dst;
236 SHOW TABLES;
237 Tables_in_test
238 src
239 DROP TABLE src;
240 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 REAL NULL, PRIMARY KEY(c1));
241 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
242 SHOW TABLES;
243 Tables_in_test
244 dst
245 src
246 SHOW CREATE TABLE dst;
247 Table Create Table
248 dst CREATE TABLE `dst` (
249 `c1` int NOT NULL AUTO_INCREMENT,
250 `c2` double DEFAULT NULL,
251 PRIMARY KEY (`c1`)
252 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
253 DROP TABLE dst;
254 SHOW TABLES;
255 Tables_in_test
256 src
257 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
258 SHOW TABLES;
259 Tables_in_test
260 dst
261 src
262 SHOW CREATE TABLE dst;
263 Table Create Table
264 dst CREATE TABLE `dst` (
265 `c1` int NOT NULL AUTO_INCREMENT,
266 `c2` double DEFAULT NULL,
267 PRIMARY KEY (`c1`)
268 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
269 DROP TABLE dst;
270 SHOW TABLES;
271 Tables_in_test
272 src
273 DROP TABLE src;
274 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DOUBLE NULL, PRIMARY KEY(c1));
275 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
276 SHOW TABLES;
277 Tables_in_test
278 dst
279 src
280 SHOW CREATE TABLE dst;
281 Table Create Table
282 dst CREATE TABLE `dst` (
283 `c1` int NOT NULL AUTO_INCREMENT,
284 `c2` double DEFAULT NULL,
285 PRIMARY KEY (`c1`)
286 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
287 DROP TABLE dst;
288 SHOW TABLES;
289 Tables_in_test
290 src
291 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
292 SHOW TABLES;
293 Tables_in_test
294 dst
295 src
296 SHOW CREATE TABLE dst;
297 Table Create Table
298 dst CREATE TABLE `dst` (
299 `c1` int NOT NULL AUTO_INCREMENT,
300 `c2` double DEFAULT NULL,
301 PRIMARY KEY (`c1`)
302 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
303 DROP TABLE dst;
304 SHOW TABLES;
305 Tables_in_test
306 src
307 DROP TABLE src;
308 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 FLOAT NULL, PRIMARY KEY(c1));
309 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
310 SHOW TABLES;
311 Tables_in_test
312 dst
313 src
314 SHOW CREATE TABLE dst;
315 Table Create Table
316 dst CREATE TABLE `dst` (
317 `c1` int NOT NULL AUTO_INCREMENT,
318 `c2` float DEFAULT NULL,
319 PRIMARY KEY (`c1`)
320 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
321 DROP TABLE dst;
322 SHOW TABLES;
323 Tables_in_test
324 src
325 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
326 SHOW TABLES;
327 Tables_in_test
328 dst
329 src
330 SHOW CREATE TABLE dst;
331 Table Create Table
332 dst CREATE TABLE `dst` (
333 `c1` int NOT NULL AUTO_INCREMENT,
334 `c2` float DEFAULT NULL,
335 PRIMARY KEY (`c1`)
336 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
337 DROP TABLE dst;
338 SHOW TABLES;
339 Tables_in_test
340 src
341 DROP TABLE src;
342 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DECIMAL NULL, PRIMARY KEY(c1));
343 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
344 SHOW TABLES;
345 Tables_in_test
346 dst
347 src
348 SHOW CREATE TABLE dst;
349 Table Create Table
350 dst CREATE TABLE `dst` (
351 `c1` int NOT NULL AUTO_INCREMENT,
352 `c2` decimal(10,0) DEFAULT NULL,
353 PRIMARY KEY (`c1`)
354 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
355 DROP TABLE dst;
356 SHOW TABLES;
357 Tables_in_test
358 src
359 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
360 SHOW TABLES;
361 Tables_in_test
362 dst
363 src
364 SHOW CREATE TABLE dst;
365 Table Create Table
366 dst CREATE TABLE `dst` (
367 `c1` int NOT NULL AUTO_INCREMENT,
368 `c2` decimal(10,0) DEFAULT NULL,
369 PRIMARY KEY (`c1`)
370 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
371 DROP TABLE dst;
372 SHOW TABLES;
373 Tables_in_test
374 src
375 DROP TABLE src;
376 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 NUMERIC NULL, PRIMARY KEY(c1));
377 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
378 SHOW TABLES;
379 Tables_in_test
380 dst
381 src
382 SHOW CREATE TABLE dst;
383 Table Create Table
384 dst CREATE TABLE `dst` (
385 `c1` int NOT NULL AUTO_INCREMENT,
386 `c2` decimal(10,0) DEFAULT NULL,
387 PRIMARY KEY (`c1`)
388 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
389 DROP TABLE dst;
390 SHOW TABLES;
391 Tables_in_test
392 src
393 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
394 SHOW TABLES;
395 Tables_in_test
396 dst
397 src
398 SHOW CREATE TABLE dst;
399 Table Create Table
400 dst CREATE TABLE `dst` (
401 `c1` int NOT NULL AUTO_INCREMENT,
402 `c2` decimal(10,0) DEFAULT NULL,
403 PRIMARY KEY (`c1`)
404 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
405 DROP TABLE dst;
406 SHOW TABLES;
407 Tables_in_test
408 src
409 DROP TABLE src;
410 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DATE NULL, PRIMARY KEY(c1));
411 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
412 SHOW TABLES;
413 Tables_in_test
414 dst
415 src
416 SHOW CREATE TABLE dst;
417 Table Create Table
418 dst CREATE TABLE `dst` (
419 `c1` int NOT NULL AUTO_INCREMENT,
420 `c2` date DEFAULT NULL,
421 PRIMARY KEY (`c1`)
422 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
423 DROP TABLE dst;
424 SHOW TABLES;
425 Tables_in_test
426 src
427 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
428 SHOW TABLES;
429 Tables_in_test
430 dst
431 src
432 SHOW CREATE TABLE dst;
433 Table Create Table
434 dst CREATE TABLE `dst` (
435 `c1` int NOT NULL AUTO_INCREMENT,
436 `c2` date DEFAULT NULL,
437 PRIMARY KEY (`c1`)
438 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
439 DROP TABLE dst;
440 SHOW TABLES;
441 Tables_in_test
442 src
443 DROP TABLE src;
444 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TIME NULL, PRIMARY KEY(c1));
445 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
446 SHOW TABLES;
447 Tables_in_test
448 dst
449 src
450 SHOW CREATE TABLE dst;
451 Table Create Table
452 dst CREATE TABLE `dst` (
453 `c1` int NOT NULL AUTO_INCREMENT,
454 `c2` time DEFAULT NULL,
455 PRIMARY KEY (`c1`)
456 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
457 DROP TABLE dst;
458 SHOW TABLES;
459 Tables_in_test
460 src
461 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
462 SHOW TABLES;
463 Tables_in_test
464 dst
465 src
466 SHOW CREATE TABLE dst;
467 Table Create Table
468 dst CREATE TABLE `dst` (
469 `c1` int NOT NULL AUTO_INCREMENT,
470 `c2` time DEFAULT NULL,
471 PRIMARY KEY (`c1`)
472 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
473 DROP TABLE dst;
474 SHOW TABLES;
475 Tables_in_test
476 src
477 DROP TABLE src;
478 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DATETIME NULL, PRIMARY KEY(c1));
479 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
480 SHOW TABLES;
481 Tables_in_test
482 dst
483 src
484 SHOW CREATE TABLE dst;
485 Table Create Table
486 dst CREATE TABLE `dst` (
487 `c1` int NOT NULL AUTO_INCREMENT,
488 `c2` datetime DEFAULT NULL,
489 PRIMARY KEY (`c1`)
490 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
491 DROP TABLE dst;
492 SHOW TABLES;
493 Tables_in_test
494 src
495 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
496 SHOW TABLES;
497 Tables_in_test
498 dst
499 src
500 SHOW CREATE TABLE dst;
501 Table Create Table
502 dst CREATE TABLE `dst` (
503 `c1` int NOT NULL AUTO_INCREMENT,
504 `c2` datetime DEFAULT NULL,
505 PRIMARY KEY (`c1`)
506 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
507 DROP TABLE dst;
508 SHOW TABLES;
509 Tables_in_test
510 src
511 DROP TABLE src;
512 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TIMESTAMP NULL, PRIMARY KEY(c1));
513 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
514 SHOW TABLES;
515 Tables_in_test
516 dst
517 src
518 SHOW CREATE TABLE dst;
519 Table Create Table
520 dst CREATE TABLE `dst` (
521 `c1` int NOT NULL AUTO_INCREMENT,
522 `c2` timestamp NULL DEFAULT NULL,
523 PRIMARY KEY (`c1`)
524 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
525 DROP TABLE dst;
526 SHOW TABLES;
527 Tables_in_test
528 src
529 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
530 SHOW TABLES;
531 Tables_in_test
532 dst
533 src
534 SHOW CREATE TABLE dst;
535 Table Create Table
536 dst CREATE TABLE `dst` (
537 `c1` int NOT NULL AUTO_INCREMENT,
538 `c2` timestamp NULL DEFAULT NULL,
539 PRIMARY KEY (`c1`)
540 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
541 DROP TABLE dst;
542 SHOW TABLES;
543 Tables_in_test
544 src
545 DROP TABLE src;
546 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 YEAR NULL, PRIMARY KEY(c1));
547 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
548 SHOW TABLES;
549 Tables_in_test
550 dst
551 src
552 SHOW CREATE TABLE dst;
553 Table Create Table
554 dst CREATE TABLE `dst` (
555 `c1` int NOT NULL AUTO_INCREMENT,
556 `c2` year DEFAULT NULL,
557 PRIMARY KEY (`c1`)
558 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
559 DROP TABLE dst;
560 SHOW TABLES;
561 Tables_in_test
562 src
563 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
564 SHOW TABLES;
565 Tables_in_test
566 dst
567 src
568 SHOW CREATE TABLE dst;
569 Table Create Table
570 dst CREATE TABLE `dst` (
571 `c1` int NOT NULL AUTO_INCREMENT,
572 `c2` year DEFAULT NULL,
573 PRIMARY KEY (`c1`)
574 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
575 DROP TABLE dst;
576 SHOW TABLES;
577 Tables_in_test
578 src
579 DROP TABLE src;
580 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYBLOB NULL, PRIMARY KEY(c1));
581 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
582 SHOW TABLES;
583 Tables_in_test
584 dst
585 src
586 SHOW CREATE TABLE dst;
587 Table Create Table
588 dst CREATE TABLE `dst` (
589 `c1` int NOT NULL AUTO_INCREMENT,
590 `c2` tinyblob,
591 PRIMARY KEY (`c1`)
592 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
593 DROP TABLE dst;
594 SHOW TABLES;
595 Tables_in_test
596 src
597 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
598 SHOW TABLES;
599 Tables_in_test
600 dst
601 src
602 SHOW CREATE TABLE dst;
603 Table Create Table
604 dst CREATE TABLE `dst` (
605 `c1` int NOT NULL AUTO_INCREMENT,
606 `c2` tinyblob,
607 PRIMARY KEY (`c1`)
608 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
609 DROP TABLE dst;
610 SHOW TABLES;
611 Tables_in_test
612 src
613 DROP TABLE src;
614 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BLOB NULL, PRIMARY KEY(c1));
615 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
616 SHOW TABLES;
617 Tables_in_test
618 dst
619 src
620 SHOW CREATE TABLE dst;
621 Table Create Table
622 dst CREATE TABLE `dst` (
623 `c1` int NOT NULL AUTO_INCREMENT,
624 `c2` blob,
625 PRIMARY KEY (`c1`)
626 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
627 DROP TABLE dst;
628 SHOW TABLES;
629 Tables_in_test
630 src
631 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
632 SHOW TABLES;
633 Tables_in_test
634 dst
635 src
636 SHOW CREATE TABLE dst;
637 Table Create Table
638 dst CREATE TABLE `dst` (
639 `c1` int NOT NULL AUTO_INCREMENT,
640 `c2` blob,
641 PRIMARY KEY (`c1`)
642 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
643 DROP TABLE dst;
644 SHOW TABLES;
645 Tables_in_test
646 src
647 DROP TABLE src;
648 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMBLOB NULL, PRIMARY KEY(c1));
649 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
650 SHOW TABLES;
651 Tables_in_test
652 dst
653 src
654 SHOW CREATE TABLE dst;
655 Table Create Table
656 dst CREATE TABLE `dst` (
657 `c1` int NOT NULL AUTO_INCREMENT,
658 `c2` mediumblob,
659 PRIMARY KEY (`c1`)
660 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
661 DROP TABLE dst;
662 SHOW TABLES;
663 Tables_in_test
664 src
665 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
666 SHOW TABLES;
667 Tables_in_test
668 dst
669 src
670 SHOW CREATE TABLE dst;
671 Table Create Table
672 dst CREATE TABLE `dst` (
673 `c1` int NOT NULL AUTO_INCREMENT,
674 `c2` mediumblob,
675 PRIMARY KEY (`c1`)
676 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
677 DROP TABLE dst;
678 SHOW TABLES;
679 Tables_in_test
680 src
681 DROP TABLE src;
682 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 LONGBLOB NULL, PRIMARY KEY(c1));
683 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
684 SHOW TABLES;
685 Tables_in_test
686 dst
687 src
688 SHOW CREATE TABLE dst;
689 Table Create Table
690 dst CREATE TABLE `dst` (
691 `c1` int NOT NULL AUTO_INCREMENT,
692 `c2` longblob,
693 PRIMARY KEY (`c1`)
694 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
695 DROP TABLE dst;
696 SHOW TABLES;
697 Tables_in_test
698 src
699 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
700 SHOW TABLES;
701 Tables_in_test
702 dst
703 src
704 SHOW CREATE TABLE dst;
705 Table Create Table
706 dst CREATE TABLE `dst` (
707 `c1` int NOT NULL AUTO_INCREMENT,
708 `c2` longblob,
709 PRIMARY KEY (`c1`)
710 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
711 DROP TABLE dst;
712 SHOW TABLES;
713 Tables_in_test
714 src
715 DROP TABLE src;
716 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYTEXT NULL, PRIMARY KEY(c1));
717 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
718 SHOW TABLES;
719 Tables_in_test
720 dst
721 src
722 SHOW CREATE TABLE dst;
723 Table Create Table
724 dst CREATE TABLE `dst` (
725 `c1` int NOT NULL AUTO_INCREMENT,
726 `c2` tinytext,
727 PRIMARY KEY (`c1`)
728 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
729 DROP TABLE dst;
730 SHOW TABLES;
731 Tables_in_test
732 src
733 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
734 SHOW TABLES;
735 Tables_in_test
736 dst
737 src
738 SHOW CREATE TABLE dst;
739 Table Create Table
740 dst CREATE TABLE `dst` (
741 `c1` int NOT NULL AUTO_INCREMENT,
742 `c2` tinytext,
743 PRIMARY KEY (`c1`)
744 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
745 DROP TABLE dst;
746 SHOW TABLES;
747 Tables_in_test
748 src
749 DROP TABLE src;
750 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TEXT NULL, PRIMARY KEY(c1));
751 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
752 SHOW TABLES;
753 Tables_in_test
754 dst
755 src
756 SHOW CREATE TABLE dst;
757 Table Create Table
758 dst CREATE TABLE `dst` (
759 `c1` int NOT NULL AUTO_INCREMENT,
760 `c2` text,
761 PRIMARY KEY (`c1`)
762 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
763 DROP TABLE dst;
764 SHOW TABLES;
765 Tables_in_test
766 src
767 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
768 SHOW TABLES;
769 Tables_in_test
770 dst
771 src
772 SHOW CREATE TABLE dst;
773 Table Create Table
774 dst CREATE TABLE `dst` (
775 `c1` int NOT NULL AUTO_INCREMENT,
776 `c2` text,
777 PRIMARY KEY (`c1`)
778 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
779 DROP TABLE dst;
780 SHOW TABLES;
781 Tables_in_test
782 src
783 DROP TABLE src;
784 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMTEXT NULL, PRIMARY KEY(c1));
785 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
786 SHOW TABLES;
787 Tables_in_test
788 dst
789 src
790 SHOW CREATE TABLE dst;
791 Table Create Table
792 dst CREATE TABLE `dst` (
793 `c1` int NOT NULL AUTO_INCREMENT,
794 `c2` mediumtext,
795 PRIMARY KEY (`c1`)
796 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
797 DROP TABLE dst;
798 SHOW TABLES;
799 Tables_in_test
800 src
801 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
802 SHOW TABLES;
803 Tables_in_test
804 dst
805 src
806 SHOW CREATE TABLE dst;
807 Table Create Table
808 dst CREATE TABLE `dst` (
809 `c1` int NOT NULL AUTO_INCREMENT,
810 `c2` mediumtext,
811 PRIMARY KEY (`c1`)
812 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
813 DROP TABLE dst;
814 SHOW TABLES;
815 Tables_in_test
816 src
817 DROP TABLE src;
818 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 LONGTEXT NULL, PRIMARY KEY(c1));
819 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
820 SHOW TABLES;
821 Tables_in_test
822 dst
823 src
824 SHOW CREATE TABLE dst;
825 Table Create Table
826 dst CREATE TABLE `dst` (
827 `c1` int NOT NULL AUTO_INCREMENT,
828 `c2` longtext,
829 PRIMARY KEY (`c1`)
830 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
831 DROP TABLE dst;
832 SHOW TABLES;
833 Tables_in_test
834 src
835 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
836 SHOW TABLES;
837 Tables_in_test
838 dst
839 src
840 SHOW CREATE TABLE dst;
841 Table Create Table
842 dst CREATE TABLE `dst` (
843 `c1` int NOT NULL AUTO_INCREMENT,
844 `c2` longtext,
845 PRIMARY KEY (`c1`)
846 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
847 DROP TABLE dst;
848 SHOW TABLES;
849 Tables_in_test
850 src
851 DROP TABLE src;