Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY );
3 SHOW CREATE TABLE t1;
4 Table Create Table
5 t1 CREATE TABLE `t1` (
6 `c1` tinyint NOT NULL AUTO_INCREMENT,
7 PRIMARY KEY (`c1`)
8 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
9 SET INSERT_ID = 10;
10 INSERT INTO t1 VALUES(null);
11 INSERT INTO t1 VALUES(null);
12 INSERT INTO t1 VALUES(null);
13 SELECT * FROM t1;
14 c1
15 10
16 11
17 12
18 DROP TABLE t1;
19 SHOW TABLES;
20 Tables_in_test
21 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY );
22 SHOW CREATE TABLE t1;
23 Table Create Table
24 t1 CREATE TABLE `t1` (
25 `c1` smallint NOT NULL AUTO_INCREMENT,
26 PRIMARY KEY (`c1`)
27 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
28 SET INSERT_ID = 10;
29 INSERT INTO t1 VALUES(null);
30 INSERT INTO t1 VALUES(null);
31 INSERT INTO t1 VALUES(null);
32 SELECT * FROM t1;
33 c1
34 10
35 11
36 12
37 DROP TABLE t1;
38 SHOW TABLES;
39 Tables_in_test
40 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY );
41 SHOW CREATE TABLE t1;
42 Table Create Table
43 t1 CREATE TABLE `t1` (
44 `c1` mediumint NOT NULL AUTO_INCREMENT,
45 PRIMARY KEY (`c1`)
46 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
47 SET INSERT_ID = 10;
48 INSERT INTO t1 VALUES(null);
49 INSERT INTO t1 VALUES(null);
50 INSERT INTO t1 VALUES(null);
51 SELECT * FROM t1;
52 c1
53 10
54 11
55 12
56 DROP TABLE t1;
57 SHOW TABLES;
58 Tables_in_test
59 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY );
60 SHOW CREATE TABLE t1;
61 Table Create Table
62 t1 CREATE TABLE `t1` (
63 `c1` int NOT NULL AUTO_INCREMENT,
64 PRIMARY KEY (`c1`)
65 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
66 SET INSERT_ID = 10;
67 INSERT INTO t1 VALUES(null);
68 INSERT INTO t1 VALUES(null);
69 INSERT INTO t1 VALUES(null);
70 SELECT * FROM t1;
71 c1
72 10
73 11
74 12
75 DROP TABLE t1;
76 SHOW TABLES;
77 Tables_in_test
78 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY );
79 SHOW CREATE TABLE t1;
80 Table Create Table
81 t1 CREATE TABLE `t1` (
82 `c1` int NOT NULL AUTO_INCREMENT,
83 PRIMARY KEY (`c1`)
84 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
85 SET INSERT_ID = 10;
86 INSERT INTO t1 VALUES(null);
87 INSERT INTO t1 VALUES(null);
88 INSERT INTO t1 VALUES(null);
89 SELECT * FROM t1;
90 c1
91 10
92 11
93 12
94 DROP TABLE t1;
95 SHOW TABLES;
96 Tables_in_test
97 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY );
98 SHOW CREATE TABLE t1;
99 Table Create Table
100 t1 CREATE TABLE `t1` (
101 `c1` bigint NOT NULL AUTO_INCREMENT,
102 PRIMARY KEY (`c1`)
103 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
104 SET INSERT_ID = 10;
105 INSERT INTO t1 VALUES(null);
106 INSERT INTO t1 VALUES(null);
107 INSERT INTO t1 VALUES(null);
108 SELECT * FROM t1;
109 c1
110 10
111 11
112 12
113 DROP TABLE t1;
114 SHOW TABLES;
115 Tables_in_test
116 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY );
117 SHOW CREATE TABLE t1;
118 Table Create Table
119 t1 CREATE TABLE `t1` (
120 `c1` tinyint NOT NULL AUTO_INCREMENT,
121 PRIMARY KEY (`c1`)
122 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
123 SET INSERT_ID = 10;
124 INSERT INTO t1 VALUES(null);
125 INSERT INTO t1 VALUES(null);
126 INSERT INTO t1 VALUES(null);
127 SELECT * FROM t1;
128 c1
129 10
130 11
131 12
132 DROP TABLE t1;
133 SHOW TABLES;
134 Tables_in_test
135 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY );
136 SHOW CREATE TABLE t1;
137 Table Create Table
138 t1 CREATE TABLE `t1` (
139 `c1` smallint NOT NULL AUTO_INCREMENT,
140 PRIMARY KEY (`c1`)
141 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
142 SET INSERT_ID = 10;
143 INSERT INTO t1 VALUES(null);
144 INSERT INTO t1 VALUES(null);
145 INSERT INTO t1 VALUES(null);
146 SELECT * FROM t1;
147 c1
148 10
149 11
150 12
151 DROP TABLE t1;
152 SHOW TABLES;
153 Tables_in_test
154 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY );
155 SHOW CREATE TABLE t1;
156 Table Create Table
157 t1 CREATE TABLE `t1` (
158 `c1` mediumint NOT NULL AUTO_INCREMENT,
159 PRIMARY KEY (`c1`)
160 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
161 SET INSERT_ID = 10;
162 INSERT INTO t1 VALUES(null);
163 INSERT INTO t1 VALUES(null);
164 INSERT INTO t1 VALUES(null);
165 SELECT * FROM t1;
166 c1
167 10
168 11
169 12
170 DROP TABLE t1;
171 SHOW TABLES;
172 Tables_in_test
173 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY );
174 SHOW CREATE TABLE t1;
175 Table Create Table
176 t1 CREATE TABLE `t1` (
177 `c1` int NOT NULL AUTO_INCREMENT,
178 PRIMARY KEY (`c1`)
179 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
180 SET INSERT_ID = 10;
181 INSERT INTO t1 VALUES(null);
182 INSERT INTO t1 VALUES(null);
183 INSERT INTO t1 VALUES(null);
184 SELECT * FROM t1;
185 c1
186 10
187 11
188 12
189 DROP TABLE t1;
190 SHOW TABLES;
191 Tables_in_test
192 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY );
193 SHOW CREATE TABLE t1;
194 Table Create Table
195 t1 CREATE TABLE `t1` (
196 `c1` int NOT NULL AUTO_INCREMENT,
197 PRIMARY KEY (`c1`)
198 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
199 SET INSERT_ID = 10;
200 INSERT INTO t1 VALUES(null);
201 INSERT INTO t1 VALUES(null);
202 INSERT INTO t1 VALUES(null);
203 SELECT * FROM t1;
204 c1
205 10
206 11
207 12
208 DROP TABLE t1;
209 SHOW TABLES;
210 Tables_in_test
211 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY );
212 SHOW CREATE TABLE t1;
213 Table Create Table
214 t1 CREATE TABLE `t1` (
215 `c1` bigint NOT NULL AUTO_INCREMENT,
216 PRIMARY KEY (`c1`)
217 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
218 SET INSERT_ID = 10;
219 INSERT INTO t1 VALUES(null);
220 INSERT INTO t1 VALUES(null);
221 INSERT INTO t1 VALUES(null);
222 SELECT * FROM t1;
223 c1
224 10
225 11
226 12
227 DROP TABLE t1;
228 SHOW TABLES;
229 Tables_in_test
230 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY );
231 SHOW CREATE TABLE t1;
232 Table Create Table
233 t1 CREATE TABLE `t1` (
234 `c1` tinyint AUTO_INCREMENT,
235 UNIQUE KEY `c1` (`c1`)
236 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
237 SET INSERT_ID = 10;
238 INSERT INTO t1 VALUES(null);
239 INSERT INTO t1 VALUES(null);
240 INSERT INTO t1 VALUES(null);
241 SELECT * FROM t1;
242 c1
243 NULL
244 NULL
245 NULL
246 DROP TABLE t1;
247 SHOW TABLES;
248 Tables_in_test
249 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY );
250 SHOW CREATE TABLE t1;
251 Table Create Table
252 t1 CREATE TABLE `t1` (
253 `c1` smallint AUTO_INCREMENT,
254 UNIQUE KEY `c1` (`c1`)
255 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
256 SET INSERT_ID = 10;
257 INSERT INTO t1 VALUES(null);
258 INSERT INTO t1 VALUES(null);
259 INSERT INTO t1 VALUES(null);
260 SELECT * FROM t1;
261 c1
262 NULL
263 NULL
264 NULL
265 DROP TABLE t1;
266 SHOW TABLES;
267 Tables_in_test
268 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY );
269 SHOW CREATE TABLE t1;
270 Table Create Table
271 t1 CREATE TABLE `t1` (
272 `c1` mediumint AUTO_INCREMENT,
273 UNIQUE KEY `c1` (`c1`)
274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
275 SET INSERT_ID = 10;
276 INSERT INTO t1 VALUES(null);
277 INSERT INTO t1 VALUES(null);
278 INSERT INTO t1 VALUES(null);
279 SELECT * FROM t1;
280 c1
281 NULL
282 NULL
283 NULL
284 DROP TABLE t1;
285 SHOW TABLES;
286 Tables_in_test
287 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY );
288 SHOW CREATE TABLE t1;
289 Table Create Table
290 t1 CREATE TABLE `t1` (
291 `c1` int AUTO_INCREMENT,
292 UNIQUE KEY `c1` (`c1`)
293 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
294 SET INSERT_ID = 10;
295 INSERT INTO t1 VALUES(null);
296 INSERT INTO t1 VALUES(null);
297 INSERT INTO t1 VALUES(null);
298 SELECT * FROM t1;
299 c1
300 NULL
301 NULL
302 NULL
303 DROP TABLE t1;
304 SHOW TABLES;
305 Tables_in_test
306 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY );
307 SHOW CREATE TABLE t1;
308 Table Create Table
309 t1 CREATE TABLE `t1` (
310 `c1` int AUTO_INCREMENT,
311 UNIQUE KEY `c1` (`c1`)
312 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
313 SET INSERT_ID = 10;
314 INSERT INTO t1 VALUES(null);
315 INSERT INTO t1 VALUES(null);
316 INSERT INTO t1 VALUES(null);
317 SELECT * FROM t1;
318 c1
319 NULL
320 NULL
321 NULL
322 DROP TABLE t1;
323 SHOW TABLES;
324 Tables_in_test
325 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY );
326 SHOW CREATE TABLE t1;
327 Table Create Table
328 t1 CREATE TABLE `t1` (
329 `c1` bigint AUTO_INCREMENT,
330 UNIQUE KEY `c1` (`c1`)
331 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
332 SET INSERT_ID = 10;
333 INSERT INTO t1 VALUES(null);
334 INSERT INTO t1 VALUES(null);
335 INSERT INTO t1 VALUES(null);
336 SELECT * FROM t1;
337 c1
338 NULL
339 NULL
340 NULL
341 DROP TABLE t1;
342 SHOW TABLES;
343 Tables_in_test
344 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
345 SHOW CREATE TABLE t1;
346 Table Create Table
347 t1 CREATE TABLE `t1` (
348 `c1` tinyint NOT NULL AUTO_INCREMENT,
349 UNIQUE KEY `c1` (`c1`)
350 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
351 SET INSERT_ID = 10;
352 INSERT INTO t1 VALUES(null);
353 INSERT INTO t1 VALUES(null);
354 INSERT INTO t1 VALUES(null);
355 SELECT * FROM t1;
356 c1
357 10
358 11
359 12
360 DROP TABLE t1;
361 SHOW TABLES;
362 Tables_in_test
363 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
364 SHOW CREATE TABLE t1;
365 Table Create Table
366 t1 CREATE TABLE `t1` (
367 `c1` smallint NOT NULL AUTO_INCREMENT,
368 UNIQUE KEY `c1` (`c1`)
369 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
370 SET INSERT_ID = 10;
371 INSERT INTO t1 VALUES(null);
372 INSERT INTO t1 VALUES(null);
373 INSERT INTO t1 VALUES(null);
374 SELECT * FROM t1;
375 c1
376 10
377 11
378 12
379 DROP TABLE t1;
380 SHOW TABLES;
381 Tables_in_test
382 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
383 SHOW CREATE TABLE t1;
384 Table Create Table
385 t1 CREATE TABLE `t1` (
386 `c1` mediumint NOT NULL AUTO_INCREMENT,
387 UNIQUE KEY `c1` (`c1`)
388 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
389 SET INSERT_ID = 10;
390 INSERT INTO t1 VALUES(null);
391 INSERT INTO t1 VALUES(null);
392 INSERT INTO t1 VALUES(null);
393 SELECT * FROM t1;
394 c1
395 10
396 11
397 12
398 DROP TABLE t1;
399 SHOW TABLES;
400 Tables_in_test
401 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY );
402 SHOW CREATE TABLE t1;
403 Table Create Table
404 t1 CREATE TABLE `t1` (
405 `c1` int NOT NULL AUTO_INCREMENT,
406 UNIQUE KEY `c1` (`c1`)
407 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
408 SET INSERT_ID = 10;
409 INSERT INTO t1 VALUES(null);
410 INSERT INTO t1 VALUES(null);
411 INSERT INTO t1 VALUES(null);
412 SELECT * FROM t1;
413 c1
414 10
415 11
416 12
417 DROP TABLE t1;
418 SHOW TABLES;
419 Tables_in_test
420 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY );
421 SHOW CREATE TABLE t1;
422 Table Create Table
423 t1 CREATE TABLE `t1` (
424 `c1` int NOT NULL AUTO_INCREMENT,
425 UNIQUE KEY `c1` (`c1`)
426 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
427 SET INSERT_ID = 10;
428 INSERT INTO t1 VALUES(null);
429 INSERT INTO t1 VALUES(null);
430 INSERT INTO t1 VALUES(null);
431 SELECT * FROM t1;
432 c1
433 10
434 11
435 12
436 DROP TABLE t1;
437 SHOW TABLES;
438 Tables_in_test
439 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
440 SHOW CREATE TABLE t1;
441 Table Create Table
442 t1 CREATE TABLE `t1` (
443 `c1` bigint NOT NULL AUTO_INCREMENT,
444 UNIQUE KEY `c1` (`c1`)
445 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
446 SET INSERT_ID = 10;
447 INSERT INTO t1 VALUES(null);
448 INSERT INTO t1 VALUES(null);
449 INSERT INTO t1 VALUES(null);
450 SELECT * FROM t1;
451 c1
452 10
453 11
454 12
455 DROP TABLE t1;
456 SHOW TABLES;
457 Tables_in_test
458 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
459 SHOW CREATE TABLE t1;
460 Table Create Table
461 t1 CREATE TABLE `t1` (
462 `c1` tinyint NOT NULL AUTO_INCREMENT,
463 PRIMARY KEY (`c1`)
464 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
465 SET INSERT_ID = 10;
466 INSERT INTO t1 VALUES(null);
467 INSERT INTO t1 VALUES(null);
468 INSERT INTO t1 VALUES(null);
469 SELECT * FROM t1;
470 c1
471 10
472 11
473 12
474 DROP TABLE t1;
475 SHOW TABLES;
476 Tables_in_test
477 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
478 SHOW CREATE TABLE t1;
479 Table Create Table
480 t1 CREATE TABLE `t1` (
481 `c1` smallint NOT NULL AUTO_INCREMENT,
482 PRIMARY KEY (`c1`)
483 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
484 SET INSERT_ID = 10;
485 INSERT INTO t1 VALUES(null);
486 INSERT INTO t1 VALUES(null);
487 INSERT INTO t1 VALUES(null);
488 SELECT * FROM t1;
489 c1
490 10
491 11
492 12
493 DROP TABLE t1;
494 SHOW TABLES;
495 Tables_in_test
496 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
497 SHOW CREATE TABLE t1;
498 Table Create Table
499 t1 CREATE TABLE `t1` (
500 `c1` mediumint NOT NULL AUTO_INCREMENT,
501 PRIMARY KEY (`c1`)
502 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
503 SET INSERT_ID = 10;
504 INSERT INTO t1 VALUES(null);
505 INSERT INTO t1 VALUES(null);
506 INSERT INTO t1 VALUES(null);
507 SELECT * FROM t1;
508 c1
509 10
510 11
511 12
512 DROP TABLE t1;
513 SHOW TABLES;
514 Tables_in_test
515 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY );
516 SHOW CREATE TABLE t1;
517 Table Create Table
518 t1 CREATE TABLE `t1` (
519 `c1` int NOT NULL AUTO_INCREMENT,
520 PRIMARY KEY (`c1`)
521 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
522 SET INSERT_ID = 10;
523 INSERT INTO t1 VALUES(null);
524 INSERT INTO t1 VALUES(null);
525 INSERT INTO t1 VALUES(null);
526 SELECT * FROM t1;
527 c1
528 10
529 11
530 12
531 DROP TABLE t1;
532 SHOW TABLES;
533 Tables_in_test
534 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY );
535 SHOW CREATE TABLE t1;
536 Table Create Table
537 t1 CREATE TABLE `t1` (
538 `c1` int NOT NULL AUTO_INCREMENT,
539 PRIMARY KEY (`c1`)
540 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
541 SET INSERT_ID = 10;
542 INSERT INTO t1 VALUES(null);
543 INSERT INTO t1 VALUES(null);
544 INSERT INTO t1 VALUES(null);
545 SELECT * FROM t1;
546 c1
547 10
548 11
549 12
550 DROP TABLE t1;
551 SHOW TABLES;
552 Tables_in_test
553 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
554 SHOW CREATE TABLE t1;
555 Table Create Table
556 t1 CREATE TABLE `t1` (
557 `c1` bigint NOT NULL AUTO_INCREMENT,
558 PRIMARY KEY (`c1`)
559 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
560 SET INSERT_ID = 10;
561 INSERT INTO t1 VALUES(null);
562 INSERT INTO t1 VALUES(null);
563 INSERT INTO t1 VALUES(null);
564 SELECT * FROM t1;
565 c1
566 10
567 11
568 12
569 DROP TABLE t1;
570 SHOW TABLES;
571 Tables_in_test
572 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
573 SHOW CREATE TABLE t1;
574 Table Create Table
575 t1 CREATE TABLE `t1` (
576 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
577 PRIMARY KEY (`c1`)
578 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
579 SET INSERT_ID = 10;
580 INSERT INTO t1 VALUES(null);
581 INSERT INTO t1 VALUES(null);
582 INSERT INTO t1 VALUES(null);
583 SELECT * FROM t1;
584 c1
585 10
586 11
587 12
588 DROP TABLE t1;
589 SHOW TABLES;
590 Tables_in_test
591 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
592 SHOW CREATE TABLE t1;
593 Table Create Table
594 t1 CREATE TABLE `t1` (
595 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
596 PRIMARY KEY (`c1`)
597 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
598 SET INSERT_ID = 10;
599 INSERT INTO t1 VALUES(null);
600 INSERT INTO t1 VALUES(null);
601 INSERT INTO t1 VALUES(null);
602 SELECT * FROM t1;
603 c1
604 10
605 11
606 12
607 DROP TABLE t1;
608 SHOW TABLES;
609 Tables_in_test
610 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
611 SHOW CREATE TABLE t1;
612 Table Create Table
613 t1 CREATE TABLE `t1` (
614 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
615 PRIMARY KEY (`c1`)
616 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
617 SET INSERT_ID = 10;
618 INSERT INTO t1 VALUES(null);
619 INSERT INTO t1 VALUES(null);
620 INSERT INTO t1 VALUES(null);
621 SELECT * FROM t1;
622 c1
623 10
624 11
625 12
626 DROP TABLE t1;
627 SHOW TABLES;
628 Tables_in_test
629 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
630 SHOW CREATE TABLE t1;
631 Table Create Table
632 t1 CREATE TABLE `t1` (
633 `c1` int unsigned NOT NULL AUTO_INCREMENT,
634 PRIMARY KEY (`c1`)
635 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
636 SET INSERT_ID = 10;
637 INSERT INTO t1 VALUES(null);
638 INSERT INTO t1 VALUES(null);
639 INSERT INTO t1 VALUES(null);
640 SELECT * FROM t1;
641 c1
642 10
643 11
644 12
645 DROP TABLE t1;
646 SHOW TABLES;
647 Tables_in_test
648 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
649 SHOW CREATE TABLE t1;
650 Table Create Table
651 t1 CREATE TABLE `t1` (
652 `c1` int unsigned NOT NULL AUTO_INCREMENT,
653 PRIMARY KEY (`c1`)
654 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
655 SET INSERT_ID = 10;
656 INSERT INTO t1 VALUES(null);
657 INSERT INTO t1 VALUES(null);
658 INSERT INTO t1 VALUES(null);
659 SELECT * FROM t1;
660 c1
661 10
662 11
663 12
664 DROP TABLE t1;
665 SHOW TABLES;
666 Tables_in_test
667 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
668 SHOW CREATE TABLE t1;
669 Table Create Table
670 t1 CREATE TABLE `t1` (
671 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
672 PRIMARY KEY (`c1`)
673 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
674 SET INSERT_ID = 10;
675 INSERT INTO t1 VALUES(null);
676 INSERT INTO t1 VALUES(null);
677 INSERT INTO t1 VALUES(null);
678 SELECT * FROM t1;
679 c1
680 10
681 11
682 12
683 DROP TABLE t1;
684 SHOW TABLES;
685 Tables_in_test
686 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
687 SHOW CREATE TABLE t1;
688 Table Create Table
689 t1 CREATE TABLE `t1` (
690 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
691 PRIMARY KEY (`c1`)
692 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
693 SET INSERT_ID = 10;
694 INSERT INTO t1 VALUES(null);
695 INSERT INTO t1 VALUES(null);
696 INSERT INTO t1 VALUES(null);
697 SELECT * FROM t1;
698 c1
699 10
700 11
701 12
702 DROP TABLE t1;
703 SHOW TABLES;
704 Tables_in_test
705 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
706 SHOW CREATE TABLE t1;
707 Table Create Table
708 t1 CREATE TABLE `t1` (
709 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
710 PRIMARY KEY (`c1`)
711 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
712 SET INSERT_ID = 10;
713 INSERT INTO t1 VALUES(null);
714 INSERT INTO t1 VALUES(null);
715 INSERT INTO t1 VALUES(null);
716 SELECT * FROM t1;
717 c1
718 10
719 11
720 12
721 DROP TABLE t1;
722 SHOW TABLES;
723 Tables_in_test
724 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
725 SHOW CREATE TABLE t1;
726 Table Create Table
727 t1 CREATE TABLE `t1` (
728 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
729 PRIMARY KEY (`c1`)
730 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
731 SET INSERT_ID = 10;
732 INSERT INTO t1 VALUES(null);
733 INSERT INTO t1 VALUES(null);
734 INSERT INTO t1 VALUES(null);
735 SELECT * FROM t1;
736 c1
737 10
738 11
739 12
740 DROP TABLE t1;
741 SHOW TABLES;
742 Tables_in_test
743 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
744 SHOW CREATE TABLE t1;
745 Table Create Table
746 t1 CREATE TABLE `t1` (
747 `c1` int unsigned NOT NULL AUTO_INCREMENT,
748 PRIMARY KEY (`c1`)
749 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
750 SET INSERT_ID = 10;
751 INSERT INTO t1 VALUES(null);
752 INSERT INTO t1 VALUES(null);
753 INSERT INTO t1 VALUES(null);
754 SELECT * FROM t1;
755 c1
756 10
757 11
758 12
759 DROP TABLE t1;
760 SHOW TABLES;
761 Tables_in_test
762 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
763 SHOW CREATE TABLE t1;
764 Table Create Table
765 t1 CREATE TABLE `t1` (
766 `c1` int unsigned NOT NULL AUTO_INCREMENT,
767 PRIMARY KEY (`c1`)
768 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
769 SET INSERT_ID = 10;
770 INSERT INTO t1 VALUES(null);
771 INSERT INTO t1 VALUES(null);
772 INSERT INTO t1 VALUES(null);
773 SELECT * FROM t1;
774 c1
775 10
776 11
777 12
778 DROP TABLE t1;
779 SHOW TABLES;
780 Tables_in_test
781 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
782 SHOW CREATE TABLE t1;
783 Table Create Table
784 t1 CREATE TABLE `t1` (
785 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
786 PRIMARY KEY (`c1`)
787 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
788 SET INSERT_ID = 10;
789 INSERT INTO t1 VALUES(null);
790 INSERT INTO t1 VALUES(null);
791 INSERT INTO t1 VALUES(null);
792 SELECT * FROM t1;
793 c1
794 10
795 11
796 12
797 DROP TABLE t1;
798 SHOW TABLES;
799 Tables_in_test
800 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
801 SHOW CREATE TABLE t1;
802 Table Create Table
803 t1 CREATE TABLE `t1` (
804 `c1` tinyint unsigned AUTO_INCREMENT,
805 UNIQUE KEY `c1` (`c1`)
806 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
807 SET INSERT_ID = 10;
808 INSERT INTO t1 VALUES(null);
809 INSERT INTO t1 VALUES(null);
810 INSERT INTO t1 VALUES(null);
811 SELECT * FROM t1;
812 c1
813 NULL
814 NULL
815 NULL
816 DROP TABLE t1;
817 SHOW TABLES;
818 Tables_in_test
819 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
820 SHOW CREATE TABLE t1;
821 Table Create Table
822 t1 CREATE TABLE `t1` (
823 `c1` smallint unsigned AUTO_INCREMENT,
824 UNIQUE KEY `c1` (`c1`)
825 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
826 SET INSERT_ID = 10;
827 INSERT INTO t1 VALUES(null);
828 INSERT INTO t1 VALUES(null);
829 INSERT INTO t1 VALUES(null);
830 SELECT * FROM t1;
831 c1
832 NULL
833 NULL
834 NULL
835 DROP TABLE t1;
836 SHOW TABLES;
837 Tables_in_test
838 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
839 SHOW CREATE TABLE t1;
840 Table Create Table
841 t1 CREATE TABLE `t1` (
842 `c1` mediumint unsigned AUTO_INCREMENT,
843 UNIQUE KEY `c1` (`c1`)
844 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
845 SET INSERT_ID = 10;
846 INSERT INTO t1 VALUES(null);
847 INSERT INTO t1 VALUES(null);
848 INSERT INTO t1 VALUES(null);
849 SELECT * FROM t1;
850 c1
851 NULL
852 NULL
853 NULL
854 DROP TABLE t1;
855 SHOW TABLES;
856 Tables_in_test
857 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
858 SHOW CREATE TABLE t1;
859 Table Create Table
860 t1 CREATE TABLE `t1` (
861 `c1` int unsigned AUTO_INCREMENT,
862 UNIQUE KEY `c1` (`c1`)
863 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
864 SET INSERT_ID = 10;
865 INSERT INTO t1 VALUES(null);
866 INSERT INTO t1 VALUES(null);
867 INSERT INTO t1 VALUES(null);
868 SELECT * FROM t1;
869 c1
870 NULL
871 NULL
872 NULL
873 DROP TABLE t1;
874 SHOW TABLES;
875 Tables_in_test
876 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
877 SHOW CREATE TABLE t1;
878 Table Create Table
879 t1 CREATE TABLE `t1` (
880 `c1` int unsigned AUTO_INCREMENT,
881 UNIQUE KEY `c1` (`c1`)
882 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
883 SET INSERT_ID = 10;
884 INSERT INTO t1 VALUES(null);
885 INSERT INTO t1 VALUES(null);
886 INSERT INTO t1 VALUES(null);
887 SELECT * FROM t1;
888 c1
889 NULL
890 NULL
891 NULL
892 DROP TABLE t1;
893 SHOW TABLES;
894 Tables_in_test
895 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
896 SHOW CREATE TABLE t1;
897 Table Create Table
898 t1 CREATE TABLE `t1` (
899 `c1` bigint unsigned AUTO_INCREMENT,
900 UNIQUE KEY `c1` (`c1`)
901 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
902 SET INSERT_ID = 10;
903 INSERT INTO t1 VALUES(null);
904 INSERT INTO t1 VALUES(null);
905 INSERT INTO t1 VALUES(null);
906 SELECT * FROM t1;
907 c1
908 NULL
909 NULL
910 NULL
911 DROP TABLE t1;
912 SHOW TABLES;
913 Tables_in_test
914 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
915 SHOW CREATE TABLE t1;
916 Table Create Table
917 t1 CREATE TABLE `t1` (
918 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
919 UNIQUE KEY `c1` (`c1`)
920 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
921 SET INSERT_ID = 10;
922 INSERT INTO t1 VALUES(null);
923 INSERT INTO t1 VALUES(null);
924 INSERT INTO t1 VALUES(null);
925 SELECT * FROM t1;
926 c1
927 10
928 11
929 12
930 DROP TABLE t1;
931 SHOW TABLES;
932 Tables_in_test
933 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
934 SHOW CREATE TABLE t1;
935 Table Create Table
936 t1 CREATE TABLE `t1` (
937 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
938 UNIQUE KEY `c1` (`c1`)
939 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
940 SET INSERT_ID = 10;
941 INSERT INTO t1 VALUES(null);
942 INSERT INTO t1 VALUES(null);
943 INSERT INTO t1 VALUES(null);
944 SELECT * FROM t1;
945 c1
946 10
947 11
948 12
949 DROP TABLE t1;
950 SHOW TABLES;
951 Tables_in_test
952 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
953 SHOW CREATE TABLE t1;
954 Table Create Table
955 t1 CREATE TABLE `t1` (
956 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
957 UNIQUE KEY `c1` (`c1`)
958 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
959 SET INSERT_ID = 10;
960 INSERT INTO t1 VALUES(null);
961 INSERT INTO t1 VALUES(null);
962 INSERT INTO t1 VALUES(null);
963 SELECT * FROM t1;
964 c1
965 10
966 11
967 12
968 DROP TABLE t1;
969 SHOW TABLES;
970 Tables_in_test
971 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
972 SHOW CREATE TABLE t1;
973 Table Create Table
974 t1 CREATE TABLE `t1` (
975 `c1` int unsigned NOT NULL AUTO_INCREMENT,
976 UNIQUE KEY `c1` (`c1`)
977 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
978 SET INSERT_ID = 10;
979 INSERT INTO t1 VALUES(null);
980 INSERT INTO t1 VALUES(null);
981 INSERT INTO t1 VALUES(null);
982 SELECT * FROM t1;
983 c1
984 10
985 11
986 12
987 DROP TABLE t1;
988 SHOW TABLES;
989 Tables_in_test
990 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
991 SHOW CREATE TABLE t1;
992 Table Create Table
993 t1 CREATE TABLE `t1` (
994 `c1` int unsigned NOT NULL AUTO_INCREMENT,
995 UNIQUE KEY `c1` (`c1`)
996 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
997 SET INSERT_ID = 10;
998 INSERT INTO t1 VALUES(null);
999 INSERT INTO t1 VALUES(null);
1000 INSERT INTO t1 VALUES(null);
1001 SELECT * FROM t1;
1002 c1
1003 10
1004 11
1005 12
1006 DROP TABLE t1;
1007 SHOW TABLES;
1008 Tables_in_test
1009 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
1010 SHOW CREATE TABLE t1;
1011 Table Create Table
1012 t1 CREATE TABLE `t1` (
1013 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
1014 UNIQUE KEY `c1` (`c1`)
1015 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1016 SET INSERT_ID = 10;
1017 INSERT INTO t1 VALUES(null);
1018 INSERT INTO t1 VALUES(null);
1019 INSERT INTO t1 VALUES(null);
1020 SELECT * FROM t1;
1021 c1
1022 10
1023 11
1024 12
1025 DROP TABLE t1;
1026 SHOW TABLES;
1027 Tables_in_test
1028 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1029 SHOW CREATE TABLE t1;
1030 Table Create Table
1031 t1 CREATE TABLE `t1` (
1032 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
1033 PRIMARY KEY (`c1`)
1034 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1035 SET INSERT_ID = 10;
1036 INSERT INTO t1 VALUES(null);
1037 INSERT INTO t1 VALUES(null);
1038 INSERT INTO t1 VALUES(null);
1039 SELECT * FROM t1;
1040 c1
1041 10
1042 11
1043 12
1044 DROP TABLE t1;
1045 SHOW TABLES;
1046 Tables_in_test
1047 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1048 SHOW CREATE TABLE t1;
1049 Table Create Table
1050 t1 CREATE TABLE `t1` (
1051 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
1052 PRIMARY KEY (`c1`)
1053 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1054 SET INSERT_ID = 10;
1055 INSERT INTO t1 VALUES(null);
1056 INSERT INTO t1 VALUES(null);
1057 INSERT INTO t1 VALUES(null);
1058 SELECT * FROM t1;
1059 c1
1060 10
1061 11
1062 12
1063 DROP TABLE t1;
1064 SHOW TABLES;
1065 Tables_in_test
1066 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1067 SHOW CREATE TABLE t1;
1068 Table Create Table
1069 t1 CREATE TABLE `t1` (
1070 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
1071 PRIMARY KEY (`c1`)
1072 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1073 SET INSERT_ID = 10;
1074 INSERT INTO t1 VALUES(null);
1075 INSERT INTO t1 VALUES(null);
1076 INSERT INTO t1 VALUES(null);
1077 SELECT * FROM t1;
1078 c1
1079 10
1080 11
1081 12
1082 DROP TABLE t1;
1083 SHOW TABLES;
1084 Tables_in_test
1085 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1086 SHOW CREATE TABLE t1;
1087 Table Create Table
1088 t1 CREATE TABLE `t1` (
1089 `c1` int unsigned NOT NULL AUTO_INCREMENT,
1090 PRIMARY KEY (`c1`)
1091 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1092 SET INSERT_ID = 10;
1093 INSERT INTO t1 VALUES(null);
1094 INSERT INTO t1 VALUES(null);
1095 INSERT INTO t1 VALUES(null);
1096 SELECT * FROM t1;
1097 c1
1098 10
1099 11
1100 12
1101 DROP TABLE t1;
1102 SHOW TABLES;
1103 Tables_in_test
1104 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1105 SHOW CREATE TABLE t1;
1106 Table Create Table
1107 t1 CREATE TABLE `t1` (
1108 `c1` int unsigned NOT NULL AUTO_INCREMENT,
1109 PRIMARY KEY (`c1`)
1110 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1111 SET INSERT_ID = 10;
1112 INSERT INTO t1 VALUES(null);
1113 INSERT INTO t1 VALUES(null);
1114 INSERT INTO t1 VALUES(null);
1115 SELECT * FROM t1;
1116 c1
1117 10
1118 11
1119 12
1120 DROP TABLE t1;
1121 SHOW TABLES;
1122 Tables_in_test
1123 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1124 SHOW CREATE TABLE t1;
1125 Table Create Table
1126 t1 CREATE TABLE `t1` (
1127 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
1128 PRIMARY KEY (`c1`)
1129 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1130 SET INSERT_ID = 10;
1131 INSERT INTO t1 VALUES(null);
1132 INSERT INTO t1 VALUES(null);
1133 INSERT INTO t1 VALUES(null);
1134 SELECT * FROM t1;
1135 c1
1136 10
1137 11
1138 12
1139 DROP TABLE t1;
1140 SHOW TABLES;
1141 Tables_in_test