Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
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 AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
9 INSERT INTO t1 VALUES(null);
10 INSERT INTO t1 VALUES(null);
11 INSERT INTO t1 VALUES(null);
12 SELECT * FROM t1;
13 c1
14 10
15 11
16 12
17 TRUNCATE TABLE t1;
18 INSERT INTO t1 VALUES(null);
19 SELECT * FROM t1;
20 c1
21 1
22 ALTER TABLE t1 AUTO_INCREMENT=10;
23 SHOW CREATE TABLE t1;
24 Table Create Table
25 t1 CREATE TABLE `t1` (
26 `c1` tinyint NOT NULL AUTO_INCREMENT,
27 PRIMARY KEY (`c1`)
28 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 1
35 10
36 11
37 12
38 TRUNCATE TABLE t1;
39 INSERT INTO t1 VALUES(null);
40 SELECT * FROM t1;
41 c1
42 1
43 DROP TABLE t1;
44 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
45 SHOW CREATE TABLE t1;
46 Table Create Table
47 t1 CREATE TABLE `t1` (
48 `c1` smallint NOT NULL AUTO_INCREMENT,
49 PRIMARY KEY (`c1`)
50 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
51 INSERT INTO t1 VALUES(null);
52 INSERT INTO t1 VALUES(null);
53 INSERT INTO t1 VALUES(null);
54 SELECT * FROM t1;
55 c1
56 10
57 11
58 12
59 TRUNCATE TABLE t1;
60 INSERT INTO t1 VALUES(null);
61 SELECT * FROM t1;
62 c1
63 1
64 ALTER TABLE t1 AUTO_INCREMENT=10;
65 SHOW CREATE TABLE t1;
66 Table Create Table
67 t1 CREATE TABLE `t1` (
68 `c1` smallint NOT NULL AUTO_INCREMENT,
69 PRIMARY KEY (`c1`)
70 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
71 INSERT INTO t1 VALUES(null);
72 INSERT INTO t1 VALUES(null);
73 INSERT INTO t1 VALUES(null);
74 SELECT * FROM t1;
75 c1
76 1
77 10
78 11
79 12
80 TRUNCATE TABLE t1;
81 INSERT INTO t1 VALUES(null);
82 SELECT * FROM t1;
83 c1
84 1
85 DROP TABLE t1;
86 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
87 SHOW CREATE TABLE t1;
88 Table Create Table
89 t1 CREATE TABLE `t1` (
90 `c1` mediumint NOT NULL AUTO_INCREMENT,
91 PRIMARY KEY (`c1`)
92 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
93 INSERT INTO t1 VALUES(null);
94 INSERT INTO t1 VALUES(null);
95 INSERT INTO t1 VALUES(null);
96 SELECT * FROM t1;
97 c1
98 10
99 11
100 12
101 TRUNCATE TABLE t1;
102 INSERT INTO t1 VALUES(null);
103 SELECT * FROM t1;
104 c1
105 1
106 ALTER TABLE t1 AUTO_INCREMENT=10;
107 SHOW CREATE TABLE t1;
108 Table Create Table
109 t1 CREATE TABLE `t1` (
110 `c1` mediumint NOT NULL AUTO_INCREMENT,
111 PRIMARY KEY (`c1`)
112 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
113 INSERT INTO t1 VALUES(null);
114 INSERT INTO t1 VALUES(null);
115 INSERT INTO t1 VALUES(null);
116 SELECT * FROM t1;
117 c1
118 1
119 10
120 11
121 12
122 TRUNCATE TABLE t1;
123 INSERT INTO t1 VALUES(null);
124 SELECT * FROM t1;
125 c1
126 1
127 DROP TABLE t1;
128 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
129 SHOW CREATE TABLE t1;
130 Table Create Table
131 t1 CREATE TABLE `t1` (
132 `c1` int NOT NULL AUTO_INCREMENT,
133 PRIMARY KEY (`c1`)
134 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
135 INSERT INTO t1 VALUES(null);
136 INSERT INTO t1 VALUES(null);
137 INSERT INTO t1 VALUES(null);
138 SELECT * FROM t1;
139 c1
140 10
141 11
142 12
143 TRUNCATE TABLE t1;
144 INSERT INTO t1 VALUES(null);
145 SELECT * FROM t1;
146 c1
147 1
148 ALTER TABLE t1 AUTO_INCREMENT=10;
149 SHOW CREATE TABLE t1;
150 Table Create Table
151 t1 CREATE TABLE `t1` (
152 `c1` int NOT NULL AUTO_INCREMENT,
153 PRIMARY KEY (`c1`)
154 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
155 INSERT INTO t1 VALUES(null);
156 INSERT INTO t1 VALUES(null);
157 INSERT INTO t1 VALUES(null);
158 SELECT * FROM t1;
159 c1
160 1
161 10
162 11
163 12
164 TRUNCATE TABLE t1;
165 INSERT INTO t1 VALUES(null);
166 SELECT * FROM t1;
167 c1
168 1
169 DROP TABLE t1;
170 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
171 SHOW CREATE TABLE t1;
172 Table Create Table
173 t1 CREATE TABLE `t1` (
174 `c1` int NOT NULL AUTO_INCREMENT,
175 PRIMARY KEY (`c1`)
176 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
177 INSERT INTO t1 VALUES(null);
178 INSERT INTO t1 VALUES(null);
179 INSERT INTO t1 VALUES(null);
180 SELECT * FROM t1;
181 c1
182 10
183 11
184 12
185 TRUNCATE TABLE t1;
186 INSERT INTO t1 VALUES(null);
187 SELECT * FROM t1;
188 c1
189 1
190 ALTER TABLE t1 AUTO_INCREMENT=10;
191 SHOW CREATE TABLE t1;
192 Table Create Table
193 t1 CREATE TABLE `t1` (
194 `c1` int NOT NULL AUTO_INCREMENT,
195 PRIMARY KEY (`c1`)
196 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
197 INSERT INTO t1 VALUES(null);
198 INSERT INTO t1 VALUES(null);
199 INSERT INTO t1 VALUES(null);
200 SELECT * FROM t1;
201 c1
202 1
203 10
204 11
205 12
206 TRUNCATE TABLE t1;
207 INSERT INTO t1 VALUES(null);
208 SELECT * FROM t1;
209 c1
210 1
211 DROP TABLE t1;
212 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
213 SHOW CREATE TABLE t1;
214 Table Create Table
215 t1 CREATE TABLE `t1` (
216 `c1` bigint NOT NULL AUTO_INCREMENT,
217 PRIMARY KEY (`c1`)
218 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 TRUNCATE TABLE t1;
228 INSERT INTO t1 VALUES(null);
229 SELECT * FROM t1;
230 c1
231 1
232 ALTER TABLE t1 AUTO_INCREMENT=10;
233 SHOW CREATE TABLE t1;
234 Table Create Table
235 t1 CREATE TABLE `t1` (
236 `c1` bigint NOT NULL AUTO_INCREMENT,
237 PRIMARY KEY (`c1`)
238 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
239 INSERT INTO t1 VALUES(null);
240 INSERT INTO t1 VALUES(null);
241 INSERT INTO t1 VALUES(null);
242 SELECT * FROM t1;
243 c1
244 1
245 10
246 11
247 12
248 TRUNCATE TABLE t1;
249 INSERT INTO t1 VALUES(null);
250 SELECT * FROM t1;
251 c1
252 1
253 DROP TABLE t1;
254 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
255 SHOW CREATE TABLE t1;
256 Table Create Table
257 t1 CREATE TABLE `t1` (
258 `c1` tinyint NOT NULL AUTO_INCREMENT,
259 PRIMARY KEY (`c1`)
260 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
261 INSERT INTO t1 VALUES(null);
262 INSERT INTO t1 VALUES(null);
263 INSERT INTO t1 VALUES(null);
264 SELECT * FROM t1;
265 c1
266 10
267 11
268 12
269 TRUNCATE TABLE t1;
270 INSERT INTO t1 VALUES(null);
271 SELECT * FROM t1;
272 c1
273 1
274 ALTER TABLE t1 AUTO_INCREMENT=10;
275 SHOW CREATE TABLE t1;
276 Table Create Table
277 t1 CREATE TABLE `t1` (
278 `c1` tinyint NOT NULL AUTO_INCREMENT,
279 PRIMARY KEY (`c1`)
280 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
281 INSERT INTO t1 VALUES(null);
282 INSERT INTO t1 VALUES(null);
283 INSERT INTO t1 VALUES(null);
284 SELECT * FROM t1;
285 c1
286 1
287 10
288 11
289 12
290 TRUNCATE TABLE t1;
291 INSERT INTO t1 VALUES(null);
292 SELECT * FROM t1;
293 c1
294 1
295 DROP TABLE t1;
296 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
297 SHOW CREATE TABLE t1;
298 Table Create Table
299 t1 CREATE TABLE `t1` (
300 `c1` smallint NOT NULL AUTO_INCREMENT,
301 PRIMARY KEY (`c1`)
302 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
303 INSERT INTO t1 VALUES(null);
304 INSERT INTO t1 VALUES(null);
305 INSERT INTO t1 VALUES(null);
306 SELECT * FROM t1;
307 c1
308 10
309 11
310 12
311 TRUNCATE TABLE t1;
312 INSERT INTO t1 VALUES(null);
313 SELECT * FROM t1;
314 c1
315 1
316 ALTER TABLE t1 AUTO_INCREMENT=10;
317 SHOW CREATE TABLE t1;
318 Table Create Table
319 t1 CREATE TABLE `t1` (
320 `c1` smallint NOT NULL AUTO_INCREMENT,
321 PRIMARY KEY (`c1`)
322 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
323 INSERT INTO t1 VALUES(null);
324 INSERT INTO t1 VALUES(null);
325 INSERT INTO t1 VALUES(null);
326 SELECT * FROM t1;
327 c1
328 1
329 10
330 11
331 12
332 TRUNCATE TABLE t1;
333 INSERT INTO t1 VALUES(null);
334 SELECT * FROM t1;
335 c1
336 1
337 DROP TABLE t1;
338 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
339 SHOW CREATE TABLE t1;
340 Table Create Table
341 t1 CREATE TABLE `t1` (
342 `c1` mediumint NOT NULL AUTO_INCREMENT,
343 PRIMARY KEY (`c1`)
344 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
345 INSERT INTO t1 VALUES(null);
346 INSERT INTO t1 VALUES(null);
347 INSERT INTO t1 VALUES(null);
348 SELECT * FROM t1;
349 c1
350 10
351 11
352 12
353 TRUNCATE TABLE t1;
354 INSERT INTO t1 VALUES(null);
355 SELECT * FROM t1;
356 c1
357 1
358 ALTER TABLE t1 AUTO_INCREMENT=10;
359 SHOW CREATE TABLE t1;
360 Table Create Table
361 t1 CREATE TABLE `t1` (
362 `c1` mediumint NOT NULL AUTO_INCREMENT,
363 PRIMARY KEY (`c1`)
364 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
365 INSERT INTO t1 VALUES(null);
366 INSERT INTO t1 VALUES(null);
367 INSERT INTO t1 VALUES(null);
368 SELECT * FROM t1;
369 c1
370 1
371 10
372 11
373 12
374 TRUNCATE TABLE t1;
375 INSERT INTO t1 VALUES(null);
376 SELECT * FROM t1;
377 c1
378 1
379 DROP TABLE t1;
380 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
381 SHOW CREATE TABLE t1;
382 Table Create Table
383 t1 CREATE TABLE `t1` (
384 `c1` int NOT NULL AUTO_INCREMENT,
385 PRIMARY KEY (`c1`)
386 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
387 INSERT INTO t1 VALUES(null);
388 INSERT INTO t1 VALUES(null);
389 INSERT INTO t1 VALUES(null);
390 SELECT * FROM t1;
391 c1
392 10
393 11
394 12
395 TRUNCATE TABLE t1;
396 INSERT INTO t1 VALUES(null);
397 SELECT * FROM t1;
398 c1
399 1
400 ALTER TABLE t1 AUTO_INCREMENT=10;
401 SHOW CREATE TABLE t1;
402 Table Create Table
403 t1 CREATE TABLE `t1` (
404 `c1` int NOT NULL AUTO_INCREMENT,
405 PRIMARY KEY (`c1`)
406 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
407 INSERT INTO t1 VALUES(null);
408 INSERT INTO t1 VALUES(null);
409 INSERT INTO t1 VALUES(null);
410 SELECT * FROM t1;
411 c1
412 1
413 10
414 11
415 12
416 TRUNCATE TABLE t1;
417 INSERT INTO t1 VALUES(null);
418 SELECT * FROM t1;
419 c1
420 1
421 DROP TABLE t1;
422 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
423 SHOW CREATE TABLE t1;
424 Table Create Table
425 t1 CREATE TABLE `t1` (
426 `c1` int NOT NULL AUTO_INCREMENT,
427 PRIMARY KEY (`c1`)
428 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
429 INSERT INTO t1 VALUES(null);
430 INSERT INTO t1 VALUES(null);
431 INSERT INTO t1 VALUES(null);
432 SELECT * FROM t1;
433 c1
434 10
435 11
436 12
437 TRUNCATE TABLE t1;
438 INSERT INTO t1 VALUES(null);
439 SELECT * FROM t1;
440 c1
441 1
442 ALTER TABLE t1 AUTO_INCREMENT=10;
443 SHOW CREATE TABLE t1;
444 Table Create Table
445 t1 CREATE TABLE `t1` (
446 `c1` int NOT NULL AUTO_INCREMENT,
447 PRIMARY KEY (`c1`)
448 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
449 INSERT INTO t1 VALUES(null);
450 INSERT INTO t1 VALUES(null);
451 INSERT INTO t1 VALUES(null);
452 SELECT * FROM t1;
453 c1
454 1
455 10
456 11
457 12
458 TRUNCATE TABLE t1;
459 INSERT INTO t1 VALUES(null);
460 SELECT * FROM t1;
461 c1
462 1
463 DROP TABLE t1;
464 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
465 SHOW CREATE TABLE t1;
466 Table Create Table
467 t1 CREATE TABLE `t1` (
468 `c1` bigint NOT NULL AUTO_INCREMENT,
469 PRIMARY KEY (`c1`)
470 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
471 INSERT INTO t1 VALUES(null);
472 INSERT INTO t1 VALUES(null);
473 INSERT INTO t1 VALUES(null);
474 SELECT * FROM t1;
475 c1
476 10
477 11
478 12
479 TRUNCATE TABLE t1;
480 INSERT INTO t1 VALUES(null);
481 SELECT * FROM t1;
482 c1
483 1
484 ALTER TABLE t1 AUTO_INCREMENT=10;
485 SHOW CREATE TABLE t1;
486 Table Create Table
487 t1 CREATE TABLE `t1` (
488 `c1` bigint NOT NULL AUTO_INCREMENT,
489 PRIMARY KEY (`c1`)
490 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
491 INSERT INTO t1 VALUES(null);
492 INSERT INTO t1 VALUES(null);
493 INSERT INTO t1 VALUES(null);
494 SELECT * FROM t1;
495 c1
496 1
497 10
498 11
499 12
500 TRUNCATE TABLE t1;
501 INSERT INTO t1 VALUES(null);
502 SELECT * FROM t1;
503 c1
504 1
505 DROP TABLE t1;
506 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
507 SHOW CREATE TABLE t1;
508 Table Create Table
509 t1 CREATE TABLE `t1` (
510 `c1` tinyint AUTO_INCREMENT,
511 UNIQUE KEY `c1` (`c1`)
512 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
513 INSERT INTO t1 VALUES(null);
514 INSERT INTO t1 VALUES(null);
515 INSERT INTO t1 VALUES(null);
516 SELECT * FROM t1;
517 c1
518 NULL
519 NULL
520 NULL
521 TRUNCATE TABLE t1;
522 INSERT INTO t1 VALUES(null);
523 SELECT * FROM t1;
524 c1
525 NULL
526 ALTER TABLE t1 AUTO_INCREMENT=10;
527 SHOW CREATE TABLE t1;
528 Table Create Table
529 t1 CREATE TABLE `t1` (
530 `c1` tinyint AUTO_INCREMENT,
531 UNIQUE KEY `c1` (`c1`)
532 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
533 INSERT INTO t1 VALUES(null);
534 INSERT INTO t1 VALUES(null);
535 INSERT INTO t1 VALUES(null);
536 SELECT * FROM t1;
537 c1
538 NULL
539 NULL
540 NULL
541 NULL
542 TRUNCATE TABLE t1;
543 INSERT INTO t1 VALUES(null);
544 SELECT * FROM t1;
545 c1
546 NULL
547 DROP TABLE t1;
548 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
549 SHOW CREATE TABLE t1;
550 Table Create Table
551 t1 CREATE TABLE `t1` (
552 `c1` smallint AUTO_INCREMENT,
553 UNIQUE KEY `c1` (`c1`)
554 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
555 INSERT INTO t1 VALUES(null);
556 INSERT INTO t1 VALUES(null);
557 INSERT INTO t1 VALUES(null);
558 SELECT * FROM t1;
559 c1
560 NULL
561 NULL
562 NULL
563 TRUNCATE TABLE t1;
564 INSERT INTO t1 VALUES(null);
565 SELECT * FROM t1;
566 c1
567 NULL
568 ALTER TABLE t1 AUTO_INCREMENT=10;
569 SHOW CREATE TABLE t1;
570 Table Create Table
571 t1 CREATE TABLE `t1` (
572 `c1` smallint AUTO_INCREMENT,
573 UNIQUE KEY `c1` (`c1`)
574 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
575 INSERT INTO t1 VALUES(null);
576 INSERT INTO t1 VALUES(null);
577 INSERT INTO t1 VALUES(null);
578 SELECT * FROM t1;
579 c1
580 NULL
581 NULL
582 NULL
583 NULL
584 TRUNCATE TABLE t1;
585 INSERT INTO t1 VALUES(null);
586 SELECT * FROM t1;
587 c1
588 NULL
589 DROP TABLE t1;
590 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
591 SHOW CREATE TABLE t1;
592 Table Create Table
593 t1 CREATE TABLE `t1` (
594 `c1` mediumint AUTO_INCREMENT,
595 UNIQUE KEY `c1` (`c1`)
596 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
597 INSERT INTO t1 VALUES(null);
598 INSERT INTO t1 VALUES(null);
599 INSERT INTO t1 VALUES(null);
600 SELECT * FROM t1;
601 c1
602 NULL
603 NULL
604 NULL
605 TRUNCATE TABLE t1;
606 INSERT INTO t1 VALUES(null);
607 SELECT * FROM t1;
608 c1
609 NULL
610 ALTER TABLE t1 AUTO_INCREMENT=10;
611 SHOW CREATE TABLE t1;
612 Table Create Table
613 t1 CREATE TABLE `t1` (
614 `c1` mediumint AUTO_INCREMENT,
615 UNIQUE KEY `c1` (`c1`)
616 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
617 INSERT INTO t1 VALUES(null);
618 INSERT INTO t1 VALUES(null);
619 INSERT INTO t1 VALUES(null);
620 SELECT * FROM t1;
621 c1
622 NULL
623 NULL
624 NULL
625 NULL
626 TRUNCATE TABLE t1;
627 INSERT INTO t1 VALUES(null);
628 SELECT * FROM t1;
629 c1
630 NULL
631 DROP TABLE t1;
632 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
633 SHOW CREATE TABLE t1;
634 Table Create Table
635 t1 CREATE TABLE `t1` (
636 `c1` int AUTO_INCREMENT,
637 UNIQUE KEY `c1` (`c1`)
638 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
639 INSERT INTO t1 VALUES(null);
640 INSERT INTO t1 VALUES(null);
641 INSERT INTO t1 VALUES(null);
642 SELECT * FROM t1;
643 c1
644 NULL
645 NULL
646 NULL
647 TRUNCATE TABLE t1;
648 INSERT INTO t1 VALUES(null);
649 SELECT * FROM t1;
650 c1
651 NULL
652 ALTER TABLE t1 AUTO_INCREMENT=10;
653 SHOW CREATE TABLE t1;
654 Table Create Table
655 t1 CREATE TABLE `t1` (
656 `c1` int AUTO_INCREMENT,
657 UNIQUE KEY `c1` (`c1`)
658 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
659 INSERT INTO t1 VALUES(null);
660 INSERT INTO t1 VALUES(null);
661 INSERT INTO t1 VALUES(null);
662 SELECT * FROM t1;
663 c1
664 NULL
665 NULL
666 NULL
667 NULL
668 TRUNCATE TABLE t1;
669 INSERT INTO t1 VALUES(null);
670 SELECT * FROM t1;
671 c1
672 NULL
673 DROP TABLE t1;
674 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
675 SHOW CREATE TABLE t1;
676 Table Create Table
677 t1 CREATE TABLE `t1` (
678 `c1` int AUTO_INCREMENT,
679 UNIQUE KEY `c1` (`c1`)
680 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
681 INSERT INTO t1 VALUES(null);
682 INSERT INTO t1 VALUES(null);
683 INSERT INTO t1 VALUES(null);
684 SELECT * FROM t1;
685 c1
686 NULL
687 NULL
688 NULL
689 TRUNCATE TABLE t1;
690 INSERT INTO t1 VALUES(null);
691 SELECT * FROM t1;
692 c1
693 NULL
694 ALTER TABLE t1 AUTO_INCREMENT=10;
695 SHOW CREATE TABLE t1;
696 Table Create Table
697 t1 CREATE TABLE `t1` (
698 `c1` int AUTO_INCREMENT,
699 UNIQUE KEY `c1` (`c1`)
700 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
701 INSERT INTO t1 VALUES(null);
702 INSERT INTO t1 VALUES(null);
703 INSERT INTO t1 VALUES(null);
704 SELECT * FROM t1;
705 c1
706 NULL
707 NULL
708 NULL
709 NULL
710 TRUNCATE TABLE t1;
711 INSERT INTO t1 VALUES(null);
712 SELECT * FROM t1;
713 c1
714 NULL
715 DROP TABLE t1;
716 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
717 SHOW CREATE TABLE t1;
718 Table Create Table
719 t1 CREATE TABLE `t1` (
720 `c1` bigint AUTO_INCREMENT,
721 UNIQUE KEY `c1` (`c1`)
722 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
723 INSERT INTO t1 VALUES(null);
724 INSERT INTO t1 VALUES(null);
725 INSERT INTO t1 VALUES(null);
726 SELECT * FROM t1;
727 c1
728 NULL
729 NULL
730 NULL
731 TRUNCATE TABLE t1;
732 INSERT INTO t1 VALUES(null);
733 SELECT * FROM t1;
734 c1
735 NULL
736 ALTER TABLE t1 AUTO_INCREMENT=10;
737 SHOW CREATE TABLE t1;
738 Table Create Table
739 t1 CREATE TABLE `t1` (
740 `c1` bigint AUTO_INCREMENT,
741 UNIQUE KEY `c1` (`c1`)
742 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
743 INSERT INTO t1 VALUES(null);
744 INSERT INTO t1 VALUES(null);
745 INSERT INTO t1 VALUES(null);
746 SELECT * FROM t1;
747 c1
748 NULL
749 NULL
750 NULL
751 NULL
752 TRUNCATE TABLE t1;
753 INSERT INTO t1 VALUES(null);
754 SELECT * FROM t1;
755 c1
756 NULL
757 DROP TABLE t1;
758 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
759 SHOW CREATE TABLE t1;
760 Table Create Table
761 t1 CREATE TABLE `t1` (
762 `c1` tinyint NOT NULL AUTO_INCREMENT,
763 UNIQUE KEY `c1` (`c1`)
764 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
765 INSERT INTO t1 VALUES(null);
766 INSERT INTO t1 VALUES(null);
767 INSERT INTO t1 VALUES(null);
768 SELECT * FROM t1;
769 c1
770 10
771 11
772 12
773 TRUNCATE TABLE t1;
774 INSERT INTO t1 VALUES(null);
775 SELECT * FROM t1;
776 c1
777 1
778 ALTER TABLE t1 AUTO_INCREMENT=10;
779 SHOW CREATE TABLE t1;
780 Table Create Table
781 t1 CREATE TABLE `t1` (
782 `c1` tinyint NOT NULL AUTO_INCREMENT,
783 UNIQUE KEY `c1` (`c1`)
784 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
785 INSERT INTO t1 VALUES(null);
786 INSERT INTO t1 VALUES(null);
787 INSERT INTO t1 VALUES(null);
788 SELECT * FROM t1;
789 c1
790 1
791 10
792 11
793 12
794 TRUNCATE TABLE t1;
795 INSERT INTO t1 VALUES(null);
796 SELECT * FROM t1;
797 c1
798 1
799 DROP TABLE t1;
800 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
801 SHOW CREATE TABLE t1;
802 Table Create Table
803 t1 CREATE TABLE `t1` (
804 `c1` smallint NOT NULL AUTO_INCREMENT,
805 UNIQUE KEY `c1` (`c1`)
806 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
807 INSERT INTO t1 VALUES(null);
808 INSERT INTO t1 VALUES(null);
809 INSERT INTO t1 VALUES(null);
810 SELECT * FROM t1;
811 c1
812 10
813 11
814 12
815 TRUNCATE TABLE t1;
816 INSERT INTO t1 VALUES(null);
817 SELECT * FROM t1;
818 c1
819 1
820 ALTER TABLE t1 AUTO_INCREMENT=10;
821 SHOW CREATE TABLE t1;
822 Table Create Table
823 t1 CREATE TABLE `t1` (
824 `c1` smallint NOT NULL AUTO_INCREMENT,
825 UNIQUE KEY `c1` (`c1`)
826 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 1
833 10
834 11
835 12
836 TRUNCATE TABLE t1;
837 INSERT INTO t1 VALUES(null);
838 SELECT * FROM t1;
839 c1
840 1
841 DROP TABLE t1;
842 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
843 SHOW CREATE TABLE t1;
844 Table Create Table
845 t1 CREATE TABLE `t1` (
846 `c1` mediumint NOT NULL AUTO_INCREMENT,
847 UNIQUE KEY `c1` (`c1`)
848 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
849 INSERT INTO t1 VALUES(null);
850 INSERT INTO t1 VALUES(null);
851 INSERT INTO t1 VALUES(null);
852 SELECT * FROM t1;
853 c1
854 10
855 11
856 12
857 TRUNCATE TABLE t1;
858 INSERT INTO t1 VALUES(null);
859 SELECT * FROM t1;
860 c1
861 1
862 ALTER TABLE t1 AUTO_INCREMENT=10;
863 SHOW CREATE TABLE t1;
864 Table Create Table
865 t1 CREATE TABLE `t1` (
866 `c1` mediumint NOT NULL AUTO_INCREMENT,
867 UNIQUE KEY `c1` (`c1`)
868 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
869 INSERT INTO t1 VALUES(null);
870 INSERT INTO t1 VALUES(null);
871 INSERT INTO t1 VALUES(null);
872 SELECT * FROM t1;
873 c1
874 1
875 10
876 11
877 12
878 TRUNCATE TABLE t1;
879 INSERT INTO t1 VALUES(null);
880 SELECT * FROM t1;
881 c1
882 1
883 DROP TABLE t1;
884 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
885 SHOW CREATE TABLE t1;
886 Table Create Table
887 t1 CREATE TABLE `t1` (
888 `c1` int NOT NULL AUTO_INCREMENT,
889 UNIQUE KEY `c1` (`c1`)
890 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
891 INSERT INTO t1 VALUES(null);
892 INSERT INTO t1 VALUES(null);
893 INSERT INTO t1 VALUES(null);
894 SELECT * FROM t1;
895 c1
896 10
897 11
898 12
899 TRUNCATE TABLE t1;
900 INSERT INTO t1 VALUES(null);
901 SELECT * FROM t1;
902 c1
903 1
904 ALTER TABLE t1 AUTO_INCREMENT=10;
905 SHOW CREATE TABLE t1;
906 Table Create Table
907 t1 CREATE TABLE `t1` (
908 `c1` int NOT NULL AUTO_INCREMENT,
909 UNIQUE KEY `c1` (`c1`)
910 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
911 INSERT INTO t1 VALUES(null);
912 INSERT INTO t1 VALUES(null);
913 INSERT INTO t1 VALUES(null);
914 SELECT * FROM t1;
915 c1
916 1
917 10
918 11
919 12
920 TRUNCATE TABLE t1;
921 INSERT INTO t1 VALUES(null);
922 SELECT * FROM t1;
923 c1
924 1
925 DROP TABLE t1;
926 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
927 SHOW CREATE TABLE t1;
928 Table Create Table
929 t1 CREATE TABLE `t1` (
930 `c1` int NOT NULL AUTO_INCREMENT,
931 UNIQUE KEY `c1` (`c1`)
932 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
933 INSERT INTO t1 VALUES(null);
934 INSERT INTO t1 VALUES(null);
935 INSERT INTO t1 VALUES(null);
936 SELECT * FROM t1;
937 c1
938 10
939 11
940 12
941 TRUNCATE TABLE t1;
942 INSERT INTO t1 VALUES(null);
943 SELECT * FROM t1;
944 c1
945 1
946 ALTER TABLE t1 AUTO_INCREMENT=10;
947 SHOW CREATE TABLE t1;
948 Table Create Table
949 t1 CREATE TABLE `t1` (
950 `c1` int NOT NULL AUTO_INCREMENT,
951 UNIQUE KEY `c1` (`c1`)
952 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
953 INSERT INTO t1 VALUES(null);
954 INSERT INTO t1 VALUES(null);
955 INSERT INTO t1 VALUES(null);
956 SELECT * FROM t1;
957 c1
958 1
959 10
960 11
961 12
962 TRUNCATE TABLE t1;
963 INSERT INTO t1 VALUES(null);
964 SELECT * FROM t1;
965 c1
966 1
967 DROP TABLE t1;
968 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
969 SHOW CREATE TABLE t1;
970 Table Create Table
971 t1 CREATE TABLE `t1` (
972 `c1` bigint NOT NULL AUTO_INCREMENT,
973 UNIQUE KEY `c1` (`c1`)
974 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
975 INSERT INTO t1 VALUES(null);
976 INSERT INTO t1 VALUES(null);
977 INSERT INTO t1 VALUES(null);
978 SELECT * FROM t1;
979 c1
980 10
981 11
982 12
983 TRUNCATE TABLE t1;
984 INSERT INTO t1 VALUES(null);
985 SELECT * FROM t1;
986 c1
987 1
988 ALTER TABLE t1 AUTO_INCREMENT=10;
989 SHOW CREATE TABLE t1;
990 Table Create Table
991 t1 CREATE TABLE `t1` (
992 `c1` bigint NOT NULL AUTO_INCREMENT,
993 UNIQUE KEY `c1` (`c1`)
994 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
995 INSERT INTO t1 VALUES(null);
996 INSERT INTO t1 VALUES(null);
997 INSERT INTO t1 VALUES(null);
998 SELECT * FROM t1;
999 c1
1000 1
1001 10
1002 11
1003 12
1004 TRUNCATE TABLE t1;
1005 INSERT INTO t1 VALUES(null);
1006 SELECT * FROM t1;
1007 c1
1008 1
1009 DROP TABLE t1;
1010 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1011 SHOW CREATE TABLE t1;
1012 Table Create Table
1013 t1 CREATE TABLE `t1` (
1014 `c1` tinyint NOT NULL AUTO_INCREMENT,
1015 PRIMARY KEY (`c1`)
1016 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 TRUNCATE TABLE t1;
1026 INSERT INTO t1 VALUES(null);
1027 SELECT * FROM t1;
1028 c1
1029 1
1030 ALTER TABLE t1 AUTO_INCREMENT=10;
1031 SHOW CREATE TABLE t1;
1032 Table Create Table
1033 t1 CREATE TABLE `t1` (
1034 `c1` tinyint NOT NULL AUTO_INCREMENT,
1035 PRIMARY KEY (`c1`)
1036 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1037 INSERT INTO t1 VALUES(null);
1038 INSERT INTO t1 VALUES(null);
1039 INSERT INTO t1 VALUES(null);
1040 SELECT * FROM t1;
1041 c1
1042 1
1043 10
1044 11
1045 12
1046 TRUNCATE TABLE t1;
1047 INSERT INTO t1 VALUES(null);
1048 SELECT * FROM t1;
1049 c1
1050 1
1051 DROP TABLE t1;
1052 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1053 SHOW CREATE TABLE t1;
1054 Table Create Table
1055 t1 CREATE TABLE `t1` (
1056 `c1` smallint NOT NULL AUTO_INCREMENT,
1057 PRIMARY KEY (`c1`)
1058 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1059 INSERT INTO t1 VALUES(null);
1060 INSERT INTO t1 VALUES(null);
1061 INSERT INTO t1 VALUES(null);
1062 SELECT * FROM t1;
1063 c1
1064 10
1065 11
1066 12
1067 TRUNCATE TABLE t1;
1068 INSERT INTO t1 VALUES(null);
1069 SELECT * FROM t1;
1070 c1
1071 1
1072 ALTER TABLE t1 AUTO_INCREMENT=10;
1073 SHOW CREATE TABLE t1;
1074 Table Create Table
1075 t1 CREATE TABLE `t1` (
1076 `c1` smallint NOT NULL AUTO_INCREMENT,
1077 PRIMARY KEY (`c1`)
1078 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1079 INSERT INTO t1 VALUES(null);
1080 INSERT INTO t1 VALUES(null);
1081 INSERT INTO t1 VALUES(null);
1082 SELECT * FROM t1;
1083 c1
1084 1
1085 10
1086 11
1087 12
1088 TRUNCATE TABLE t1;
1089 INSERT INTO t1 VALUES(null);
1090 SELECT * FROM t1;
1091 c1
1092 1
1093 DROP TABLE t1;
1094 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1095 SHOW CREATE TABLE t1;
1096 Table Create Table
1097 t1 CREATE TABLE `t1` (
1098 `c1` mediumint NOT NULL AUTO_INCREMENT,
1099 PRIMARY KEY (`c1`)
1100 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1101 INSERT INTO t1 VALUES(null);
1102 INSERT INTO t1 VALUES(null);
1103 INSERT INTO t1 VALUES(null);
1104 SELECT * FROM t1;
1105 c1
1106 10
1107 11
1108 12
1109 TRUNCATE TABLE t1;
1110 INSERT INTO t1 VALUES(null);
1111 SELECT * FROM t1;
1112 c1
1113 1
1114 ALTER TABLE t1 AUTO_INCREMENT=10;
1115 SHOW CREATE TABLE t1;
1116 Table Create Table
1117 t1 CREATE TABLE `t1` (
1118 `c1` mediumint NOT NULL AUTO_INCREMENT,
1119 PRIMARY KEY (`c1`)
1120 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1121 INSERT INTO t1 VALUES(null);
1122 INSERT INTO t1 VALUES(null);
1123 INSERT INTO t1 VALUES(null);
1124 SELECT * FROM t1;
1125 c1
1126 1
1127 10
1128 11
1129 12
1130 TRUNCATE TABLE t1;
1131 INSERT INTO t1 VALUES(null);
1132 SELECT * FROM t1;
1133 c1
1134 1
1135 DROP TABLE t1;
1136 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1137 SHOW CREATE TABLE t1;
1138 Table Create Table
1139 t1 CREATE TABLE `t1` (
1140 `c1` int NOT NULL AUTO_INCREMENT,
1141 PRIMARY KEY (`c1`)
1142 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1143 INSERT INTO t1 VALUES(null);
1144 INSERT INTO t1 VALUES(null);
1145 INSERT INTO t1 VALUES(null);
1146 SELECT * FROM t1;
1147 c1
1148 10
1149 11
1150 12
1151 TRUNCATE TABLE t1;
1152 INSERT INTO t1 VALUES(null);
1153 SELECT * FROM t1;
1154 c1
1155 1
1156 ALTER TABLE t1 AUTO_INCREMENT=10;
1157 SHOW CREATE TABLE t1;
1158 Table Create Table
1159 t1 CREATE TABLE `t1` (
1160 `c1` int NOT NULL AUTO_INCREMENT,
1161 PRIMARY KEY (`c1`)
1162 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1163 INSERT INTO t1 VALUES(null);
1164 INSERT INTO t1 VALUES(null);
1165 INSERT INTO t1 VALUES(null);
1166 SELECT * FROM t1;
1167 c1
1168 1
1169 10
1170 11
1171 12
1172 TRUNCATE TABLE t1;
1173 INSERT INTO t1 VALUES(null);
1174 SELECT * FROM t1;
1175 c1
1176 1
1177 DROP TABLE t1;
1178 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1179 SHOW CREATE TABLE t1;
1180 Table Create Table
1181 t1 CREATE TABLE `t1` (
1182 `c1` int NOT NULL AUTO_INCREMENT,
1183 PRIMARY KEY (`c1`)
1184 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1185 INSERT INTO t1 VALUES(null);
1186 INSERT INTO t1 VALUES(null);
1187 INSERT INTO t1 VALUES(null);
1188 SELECT * FROM t1;
1189 c1
1190 10
1191 11
1192 12
1193 TRUNCATE TABLE t1;
1194 INSERT INTO t1 VALUES(null);
1195 SELECT * FROM t1;
1196 c1
1197 1
1198 ALTER TABLE t1 AUTO_INCREMENT=10;
1199 SHOW CREATE TABLE t1;
1200 Table Create Table
1201 t1 CREATE TABLE `t1` (
1202 `c1` int NOT NULL AUTO_INCREMENT,
1203 PRIMARY KEY (`c1`)
1204 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1205 INSERT INTO t1 VALUES(null);
1206 INSERT INTO t1 VALUES(null);
1207 INSERT INTO t1 VALUES(null);
1208 SELECT * FROM t1;
1209 c1
1210 1
1211 10
1212 11
1213 12
1214 TRUNCATE TABLE t1;
1215 INSERT INTO t1 VALUES(null);
1216 SELECT * FROM t1;
1217 c1
1218 1
1219 DROP TABLE t1;
1220 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1221 SHOW CREATE TABLE t1;
1222 Table Create Table
1223 t1 CREATE TABLE `t1` (
1224 `c1` bigint NOT NULL AUTO_INCREMENT,
1225 PRIMARY KEY (`c1`)
1226 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1227 INSERT INTO t1 VALUES(null);
1228 INSERT INTO t1 VALUES(null);
1229 INSERT INTO t1 VALUES(null);
1230 SELECT * FROM t1;
1231 c1
1232 10
1233 11
1234 12
1235 TRUNCATE TABLE t1;
1236 INSERT INTO t1 VALUES(null);
1237 SELECT * FROM t1;
1238 c1
1239 1
1240 ALTER TABLE t1 AUTO_INCREMENT=10;
1241 SHOW CREATE TABLE t1;
1242 Table Create Table
1243 t1 CREATE TABLE `t1` (
1244 `c1` bigint NOT NULL AUTO_INCREMENT,
1245 PRIMARY KEY (`c1`)
1246 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1247 INSERT INTO t1 VALUES(null);
1248 INSERT INTO t1 VALUES(null);
1249 INSERT INTO t1 VALUES(null);
1250 SELECT * FROM t1;
1251 c1
1252 1
1253 10
1254 11
1255 12
1256 TRUNCATE TABLE t1;
1257 INSERT INTO t1 VALUES(null);
1258 SELECT * FROM t1;
1259 c1
1260 1
1261 DROP TABLE t1;
1262 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1263 SHOW CREATE TABLE t1;
1264 Table Create Table
1265 t1 CREATE TABLE `t1` (
1266 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
1267 PRIMARY KEY (`c1`)
1268 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1269 INSERT INTO t1 VALUES(null);
1270 INSERT INTO t1 VALUES(null);
1271 INSERT INTO t1 VALUES(null);
1272 SELECT * FROM t1;
1273 c1
1274 10
1275 11
1276 12
1277 TRUNCATE TABLE t1;
1278 INSERT INTO t1 VALUES(null);
1279 SELECT * FROM t1;
1280 c1
1281 1
1282 ALTER TABLE t1 AUTO_INCREMENT=10;
1283 SHOW CREATE TABLE t1;
1284 Table Create Table
1285 t1 CREATE TABLE `t1` (
1286 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
1287 PRIMARY KEY (`c1`)
1288 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1289 INSERT INTO t1 VALUES(null);
1290 INSERT INTO t1 VALUES(null);
1291 INSERT INTO t1 VALUES(null);
1292 SELECT * FROM t1;
1293 c1
1294 1
1295 10
1296 11
1297 12
1298 TRUNCATE TABLE t1;
1299 INSERT INTO t1 VALUES(null);
1300 SELECT * FROM t1;
1301 c1
1302 1
1303 DROP TABLE t1;
1304 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1305 SHOW CREATE TABLE t1;
1306 Table Create Table
1307 t1 CREATE TABLE `t1` (
1308 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
1309 PRIMARY KEY (`c1`)
1310 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1311 INSERT INTO t1 VALUES(null);
1312 INSERT INTO t1 VALUES(null);
1313 INSERT INTO t1 VALUES(null);
1314 SELECT * FROM t1;
1315 c1
1316 10
1317 11
1318 12
1319 TRUNCATE TABLE t1;
1320 INSERT INTO t1 VALUES(null);
1321 SELECT * FROM t1;
1322 c1
1323 1
1324 ALTER TABLE t1 AUTO_INCREMENT=10;
1325 SHOW CREATE TABLE t1;
1326 Table Create Table
1327 t1 CREATE TABLE `t1` (
1328 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
1329 PRIMARY KEY (`c1`)
1330 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1331 INSERT INTO t1 VALUES(null);
1332 INSERT INTO t1 VALUES(null);
1333 INSERT INTO t1 VALUES(null);
1334 SELECT * FROM t1;
1335 c1
1336 1
1337 10
1338 11
1339 12
1340 TRUNCATE TABLE t1;
1341 INSERT INTO t1 VALUES(null);
1342 SELECT * FROM t1;
1343 c1
1344 1
1345 DROP TABLE t1;
1346 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1347 SHOW CREATE TABLE t1;
1348 Table Create Table
1349 t1 CREATE TABLE `t1` (
1350 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
1351 PRIMARY KEY (`c1`)
1352 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1353 INSERT INTO t1 VALUES(null);
1354 INSERT INTO t1 VALUES(null);
1355 INSERT INTO t1 VALUES(null);
1356 SELECT * FROM t1;
1357 c1
1358 10
1359 11
1360 12
1361 TRUNCATE TABLE t1;
1362 INSERT INTO t1 VALUES(null);
1363 SELECT * FROM t1;
1364 c1
1365 1
1366 ALTER TABLE t1 AUTO_INCREMENT=10;
1367 SHOW CREATE TABLE t1;
1368 Table Create Table
1369 t1 CREATE TABLE `t1` (
1370 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
1371 PRIMARY KEY (`c1`)
1372 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1373 INSERT INTO t1 VALUES(null);
1374 INSERT INTO t1 VALUES(null);
1375 INSERT INTO t1 VALUES(null);
1376 SELECT * FROM t1;
1377 c1
1378 1
1379 10
1380 11
1381 12
1382 TRUNCATE TABLE t1;
1383 INSERT INTO t1 VALUES(null);
1384 SELECT * FROM t1;
1385 c1
1386 1
1387 DROP TABLE t1;
1388 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1389 SHOW CREATE TABLE t1;
1390 Table Create Table
1391 t1 CREATE TABLE `t1` (
1392 `c1` int unsigned NOT NULL AUTO_INCREMENT,
1393 PRIMARY KEY (`c1`)
1394 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1395 INSERT INTO t1 VALUES(null);
1396 INSERT INTO t1 VALUES(null);
1397 INSERT INTO t1 VALUES(null);
1398 SELECT * FROM t1;
1399 c1
1400 10
1401 11
1402 12
1403 TRUNCATE TABLE t1;
1404 INSERT INTO t1 VALUES(null);
1405 SELECT * FROM t1;
1406 c1
1407 1
1408 ALTER TABLE t1 AUTO_INCREMENT=10;
1409 SHOW CREATE TABLE t1;
1410 Table Create Table
1411 t1 CREATE TABLE `t1` (
1412 `c1` int unsigned NOT NULL AUTO_INCREMENT,
1413 PRIMARY KEY (`c1`)
1414 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1415 INSERT INTO t1 VALUES(null);
1416 INSERT INTO t1 VALUES(null);
1417 INSERT INTO t1 VALUES(null);
1418 SELECT * FROM t1;
1419 c1
1420 1
1421 10
1422 11
1423 12
1424 TRUNCATE TABLE t1;
1425 INSERT INTO t1 VALUES(null);
1426 SELECT * FROM t1;
1427 c1
1428 1
1429 DROP TABLE t1;
1430 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1431 SHOW CREATE TABLE t1;
1432 Table Create Table
1433 t1 CREATE TABLE `t1` (
1434 `c1` int unsigned NOT NULL AUTO_INCREMENT,
1435 PRIMARY KEY (`c1`)
1436 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1437 INSERT INTO t1 VALUES(null);
1438 INSERT INTO t1 VALUES(null);
1439 INSERT INTO t1 VALUES(null);
1440 SELECT * FROM t1;
1441 c1
1442 10
1443 11
1444 12
1445 TRUNCATE TABLE t1;
1446 INSERT INTO t1 VALUES(null);
1447 SELECT * FROM t1;
1448 c1
1449 1
1450 ALTER TABLE t1 AUTO_INCREMENT=10;
1451 SHOW CREATE TABLE t1;
1452 Table Create Table
1453 t1 CREATE TABLE `t1` (
1454 `c1` int unsigned NOT NULL AUTO_INCREMENT,
1455 PRIMARY KEY (`c1`)
1456 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1457 INSERT INTO t1 VALUES(null);
1458 INSERT INTO t1 VALUES(null);
1459 INSERT INTO t1 VALUES(null);
1460 SELECT * FROM t1;
1461 c1
1462 1
1463 10
1464 11
1465 12
1466 TRUNCATE TABLE t1;
1467 INSERT INTO t1 VALUES(null);
1468 SELECT * FROM t1;
1469 c1
1470 1
1471 DROP TABLE t1;
1472 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1473 SHOW CREATE TABLE t1;
1474 Table Create Table
1475 t1 CREATE TABLE `t1` (
1476 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
1477 PRIMARY KEY (`c1`)
1478 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1479 INSERT INTO t1 VALUES(null);
1480 INSERT INTO t1 VALUES(null);
1481 INSERT INTO t1 VALUES(null);
1482 SELECT * FROM t1;
1483 c1
1484 10
1485 11
1486 12
1487 TRUNCATE TABLE t1;
1488 INSERT INTO t1 VALUES(null);
1489 SELECT * FROM t1;
1490 c1
1491 1
1492 ALTER TABLE t1 AUTO_INCREMENT=10;
1493 SHOW CREATE TABLE t1;
1494 Table Create Table
1495 t1 CREATE TABLE `t1` (
1496 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
1497 PRIMARY KEY (`c1`)
1498 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1499 INSERT INTO t1 VALUES(null);
1500 INSERT INTO t1 VALUES(null);
1501 INSERT INTO t1 VALUES(null);
1502 SELECT * FROM t1;
1503 c1
1504 1
1505 10
1506 11
1507 12
1508 TRUNCATE TABLE t1;
1509 INSERT INTO t1 VALUES(null);
1510 SELECT * FROM t1;
1511 c1
1512 1
1513 DROP TABLE t1;
1514 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1515 SHOW CREATE TABLE t1;
1516 Table Create Table
1517 t1 CREATE TABLE `t1` (
1518 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
1519 PRIMARY KEY (`c1`)
1520 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1521 INSERT INTO t1 VALUES(null);
1522 INSERT INTO t1 VALUES(null);
1523 INSERT INTO t1 VALUES(null);
1524 SELECT * FROM t1;
1525 c1
1526 10
1527 11
1528 12
1529 TRUNCATE TABLE t1;
1530 INSERT INTO t1 VALUES(null);
1531 SELECT * FROM t1;
1532 c1
1533 1
1534 ALTER TABLE t1 AUTO_INCREMENT=10;
1535 SHOW CREATE TABLE t1;
1536 Table Create Table
1537 t1 CREATE TABLE `t1` (
1538 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
1539 PRIMARY KEY (`c1`)
1540 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1541 INSERT INTO t1 VALUES(null);
1542 INSERT INTO t1 VALUES(null);
1543 INSERT INTO t1 VALUES(null);
1544 SELECT * FROM t1;
1545 c1
1546 1
1547 10
1548 11
1549 12
1550 TRUNCATE TABLE t1;
1551 INSERT INTO t1 VALUES(null);
1552 SELECT * FROM t1;
1553 c1
1554 1
1555 DROP TABLE t1;
1556 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1557 SHOW CREATE TABLE t1;
1558 Table Create Table
1559 t1 CREATE TABLE `t1` (
1560 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
1561 PRIMARY KEY (`c1`)
1562 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1563 INSERT INTO t1 VALUES(null);
1564 INSERT INTO t1 VALUES(null);
1565 INSERT INTO t1 VALUES(null);
1566 SELECT * FROM t1;
1567 c1
1568 10
1569 11
1570 12
1571 TRUNCATE TABLE t1;
1572 INSERT INTO t1 VALUES(null);
1573 SELECT * FROM t1;
1574 c1
1575 1
1576 ALTER TABLE t1 AUTO_INCREMENT=10;
1577 SHOW CREATE TABLE t1;
1578 Table Create Table
1579 t1 CREATE TABLE `t1` (
1580 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
1581 PRIMARY KEY (`c1`)
1582 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1583 INSERT INTO t1 VALUES(null);
1584 INSERT INTO t1 VALUES(null);
1585 INSERT INTO t1 VALUES(null);
1586 SELECT * FROM t1;
1587 c1
1588 1
1589 10
1590 11
1591 12
1592 TRUNCATE TABLE t1;
1593 INSERT INTO t1 VALUES(null);
1594 SELECT * FROM t1;
1595 c1
1596 1
1597 DROP TABLE t1;
1598 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1599 SHOW CREATE TABLE t1;
1600 Table Create Table
1601 t1 CREATE TABLE `t1` (
1602 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
1603 PRIMARY KEY (`c1`)
1604 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1605 INSERT INTO t1 VALUES(null);
1606 INSERT INTO t1 VALUES(null);
1607 INSERT INTO t1 VALUES(null);
1608 SELECT * FROM t1;
1609 c1
1610 10
1611 11
1612 12
1613 TRUNCATE TABLE t1;
1614 INSERT INTO t1 VALUES(null);
1615 SELECT * FROM t1;
1616 c1
1617 1
1618 ALTER TABLE t1 AUTO_INCREMENT=10;
1619 SHOW CREATE TABLE t1;
1620 Table Create Table
1621 t1 CREATE TABLE `t1` (
1622 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
1623 PRIMARY KEY (`c1`)
1624 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1625 INSERT INTO t1 VALUES(null);
1626 INSERT INTO t1 VALUES(null);
1627 INSERT INTO t1 VALUES(null);
1628 SELECT * FROM t1;
1629 c1
1630 1
1631 10
1632 11
1633 12
1634 TRUNCATE TABLE t1;
1635 INSERT INTO t1 VALUES(null);
1636 SELECT * FROM t1;
1637 c1
1638 1
1639 DROP TABLE t1;
1640 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1641 SHOW CREATE TABLE t1;
1642 Table Create Table
1643 t1 CREATE TABLE `t1` (
1644 `c1` int unsigned NOT NULL AUTO_INCREMENT,
1645 PRIMARY KEY (`c1`)
1646 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1647 INSERT INTO t1 VALUES(null);
1648 INSERT INTO t1 VALUES(null);
1649 INSERT INTO t1 VALUES(null);
1650 SELECT * FROM t1;
1651 c1
1652 10
1653 11
1654 12
1655 TRUNCATE TABLE t1;
1656 INSERT INTO t1 VALUES(null);
1657 SELECT * FROM t1;
1658 c1
1659 1
1660 ALTER TABLE t1 AUTO_INCREMENT=10;
1661 SHOW CREATE TABLE t1;
1662 Table Create Table
1663 t1 CREATE TABLE `t1` (
1664 `c1` int unsigned NOT NULL AUTO_INCREMENT,
1665 PRIMARY KEY (`c1`)
1666 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1667 INSERT INTO t1 VALUES(null);
1668 INSERT INTO t1 VALUES(null);
1669 INSERT INTO t1 VALUES(null);
1670 SELECT * FROM t1;
1671 c1
1672 1
1673 10
1674 11
1675 12
1676 TRUNCATE TABLE t1;
1677 INSERT INTO t1 VALUES(null);
1678 SELECT * FROM t1;
1679 c1
1680 1
1681 DROP TABLE t1;
1682 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1683 SHOW CREATE TABLE t1;
1684 Table Create Table
1685 t1 CREATE TABLE `t1` (
1686 `c1` int unsigned NOT NULL AUTO_INCREMENT,
1687 PRIMARY KEY (`c1`)
1688 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1689 INSERT INTO t1 VALUES(null);
1690 INSERT INTO t1 VALUES(null);
1691 INSERT INTO t1 VALUES(null);
1692 SELECT * FROM t1;
1693 c1
1694 10
1695 11
1696 12
1697 TRUNCATE TABLE t1;
1698 INSERT INTO t1 VALUES(null);
1699 SELECT * FROM t1;
1700 c1
1701 1
1702 ALTER TABLE t1 AUTO_INCREMENT=10;
1703 SHOW CREATE TABLE t1;
1704 Table Create Table
1705 t1 CREATE TABLE `t1` (
1706 `c1` int unsigned NOT NULL AUTO_INCREMENT,
1707 PRIMARY KEY (`c1`)
1708 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1709 INSERT INTO t1 VALUES(null);
1710 INSERT INTO t1 VALUES(null);
1711 INSERT INTO t1 VALUES(null);
1712 SELECT * FROM t1;
1713 c1
1714 1
1715 10
1716 11
1717 12
1718 TRUNCATE TABLE t1;
1719 INSERT INTO t1 VALUES(null);
1720 SELECT * FROM t1;
1721 c1
1722 1
1723 DROP TABLE t1;
1724 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1725 SHOW CREATE TABLE t1;
1726 Table Create Table
1727 t1 CREATE TABLE `t1` (
1728 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
1729 PRIMARY KEY (`c1`)
1730 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1731 INSERT INTO t1 VALUES(null);
1732 INSERT INTO t1 VALUES(null);
1733 INSERT INTO t1 VALUES(null);
1734 SELECT * FROM t1;
1735 c1
1736 10
1737 11
1738 12
1739 TRUNCATE TABLE t1;
1740 INSERT INTO t1 VALUES(null);
1741 SELECT * FROM t1;
1742 c1
1743 1
1744 ALTER TABLE t1 AUTO_INCREMENT=10;
1745 SHOW CREATE TABLE t1;
1746 Table Create Table
1747 t1 CREATE TABLE `t1` (
1748 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
1749 PRIMARY KEY (`c1`)
1750 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1751 INSERT INTO t1 VALUES(null);
1752 INSERT INTO t1 VALUES(null);
1753 INSERT INTO t1 VALUES(null);
1754 SELECT * FROM t1;
1755 c1
1756 1
1757 10
1758 11
1759 12
1760 TRUNCATE TABLE t1;
1761 INSERT INTO t1 VALUES(null);
1762 SELECT * FROM t1;
1763 c1
1764 1
1765 DROP TABLE t1;
1766 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1767 SHOW CREATE TABLE t1;
1768 Table Create Table
1769 t1 CREATE TABLE `t1` (
1770 `c1` tinyint unsigned AUTO_INCREMENT,
1771 UNIQUE KEY `c1` (`c1`)
1772 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1773 INSERT INTO t1 VALUES(null);
1774 INSERT INTO t1 VALUES(null);
1775 INSERT INTO t1 VALUES(null);
1776 SELECT * FROM t1;
1777 c1
1778 NULL
1779 NULL
1780 NULL
1781 TRUNCATE TABLE t1;
1782 INSERT INTO t1 VALUES(null);
1783 SELECT * FROM t1;
1784 c1
1785 NULL
1786 ALTER TABLE t1 AUTO_INCREMENT=10;
1787 SHOW CREATE TABLE t1;
1788 Table Create Table
1789 t1 CREATE TABLE `t1` (
1790 `c1` tinyint unsigned AUTO_INCREMENT,
1791 UNIQUE KEY `c1` (`c1`)
1792 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1793 INSERT INTO t1 VALUES(null);
1794 INSERT INTO t1 VALUES(null);
1795 INSERT INTO t1 VALUES(null);
1796 SELECT * FROM t1;
1797 c1
1798 NULL
1799 NULL
1800 NULL
1801 NULL
1802 TRUNCATE TABLE t1;
1803 INSERT INTO t1 VALUES(null);
1804 SELECT * FROM t1;
1805 c1
1806 NULL
1807 DROP TABLE t1;
1808 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1809 SHOW CREATE TABLE t1;
1810 Table Create Table
1811 t1 CREATE TABLE `t1` (
1812 `c1` smallint unsigned AUTO_INCREMENT,
1813 UNIQUE KEY `c1` (`c1`)
1814 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1815 INSERT INTO t1 VALUES(null);
1816 INSERT INTO t1 VALUES(null);
1817 INSERT INTO t1 VALUES(null);
1818 SELECT * FROM t1;
1819 c1
1820 NULL
1821 NULL
1822 NULL
1823 TRUNCATE TABLE t1;
1824 INSERT INTO t1 VALUES(null);
1825 SELECT * FROM t1;
1826 c1
1827 NULL
1828 ALTER TABLE t1 AUTO_INCREMENT=10;
1829 SHOW CREATE TABLE t1;
1830 Table Create Table
1831 t1 CREATE TABLE `t1` (
1832 `c1` smallint unsigned AUTO_INCREMENT,
1833 UNIQUE KEY `c1` (`c1`)
1834 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1835 INSERT INTO t1 VALUES(null);
1836 INSERT INTO t1 VALUES(null);
1837 INSERT INTO t1 VALUES(null);
1838 SELECT * FROM t1;
1839 c1
1840 NULL
1841 NULL
1842 NULL
1843 NULL
1844 TRUNCATE TABLE t1;
1845 INSERT INTO t1 VALUES(null);
1846 SELECT * FROM t1;
1847 c1
1848 NULL
1849 DROP TABLE t1;
1850 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1851 SHOW CREATE TABLE t1;
1852 Table Create Table
1853 t1 CREATE TABLE `t1` (
1854 `c1` mediumint unsigned AUTO_INCREMENT,
1855 UNIQUE KEY `c1` (`c1`)
1856 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1857 INSERT INTO t1 VALUES(null);
1858 INSERT INTO t1 VALUES(null);
1859 INSERT INTO t1 VALUES(null);
1860 SELECT * FROM t1;
1861 c1
1862 NULL
1863 NULL
1864 NULL
1865 TRUNCATE TABLE t1;
1866 INSERT INTO t1 VALUES(null);
1867 SELECT * FROM t1;
1868 c1
1869 NULL
1870 ALTER TABLE t1 AUTO_INCREMENT=10;
1871 SHOW CREATE TABLE t1;
1872 Table Create Table
1873 t1 CREATE TABLE `t1` (
1874 `c1` mediumint unsigned AUTO_INCREMENT,
1875 UNIQUE KEY `c1` (`c1`)
1876 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1877 INSERT INTO t1 VALUES(null);
1878 INSERT INTO t1 VALUES(null);
1879 INSERT INTO t1 VALUES(null);
1880 SELECT * FROM t1;
1881 c1
1882 NULL
1883 NULL
1884 NULL
1885 NULL
1886 TRUNCATE TABLE t1;
1887 INSERT INTO t1 VALUES(null);
1888 SELECT * FROM t1;
1889 c1
1890 NULL
1891 DROP TABLE t1;
1892 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1893 SHOW CREATE TABLE t1;
1894 Table Create Table
1895 t1 CREATE TABLE `t1` (
1896 `c1` int unsigned AUTO_INCREMENT,
1897 UNIQUE KEY `c1` (`c1`)
1898 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1899 INSERT INTO t1 VALUES(null);
1900 INSERT INTO t1 VALUES(null);
1901 INSERT INTO t1 VALUES(null);
1902 SELECT * FROM t1;
1903 c1
1904 NULL
1905 NULL
1906 NULL
1907 TRUNCATE TABLE t1;
1908 INSERT INTO t1 VALUES(null);
1909 SELECT * FROM t1;
1910 c1
1911 NULL
1912 ALTER TABLE t1 AUTO_INCREMENT=10;
1913 SHOW CREATE TABLE t1;
1914 Table Create Table
1915 t1 CREATE TABLE `t1` (
1916 `c1` int unsigned AUTO_INCREMENT,
1917 UNIQUE KEY `c1` (`c1`)
1918 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1919 INSERT INTO t1 VALUES(null);
1920 INSERT INTO t1 VALUES(null);
1921 INSERT INTO t1 VALUES(null);
1922 SELECT * FROM t1;
1923 c1
1924 NULL
1925 NULL
1926 NULL
1927 NULL
1928 TRUNCATE TABLE t1;
1929 INSERT INTO t1 VALUES(null);
1930 SELECT * FROM t1;
1931 c1
1932 NULL
1933 DROP TABLE t1;
1934 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1935 SHOW CREATE TABLE t1;
1936 Table Create Table
1937 t1 CREATE TABLE `t1` (
1938 `c1` int unsigned AUTO_INCREMENT,
1939 UNIQUE KEY `c1` (`c1`)
1940 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1941 INSERT INTO t1 VALUES(null);
1942 INSERT INTO t1 VALUES(null);
1943 INSERT INTO t1 VALUES(null);
1944 SELECT * FROM t1;
1945 c1
1946 NULL
1947 NULL
1948 NULL
1949 TRUNCATE TABLE t1;
1950 INSERT INTO t1 VALUES(null);
1951 SELECT * FROM t1;
1952 c1
1953 NULL
1954 ALTER TABLE t1 AUTO_INCREMENT=10;
1955 SHOW CREATE TABLE t1;
1956 Table Create Table
1957 t1 CREATE TABLE `t1` (
1958 `c1` int unsigned AUTO_INCREMENT,
1959 UNIQUE KEY `c1` (`c1`)
1960 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1961 INSERT INTO t1 VALUES(null);
1962 INSERT INTO t1 VALUES(null);
1963 INSERT INTO t1 VALUES(null);
1964 SELECT * FROM t1;
1965 c1
1966 NULL
1967 NULL
1968 NULL
1969 NULL
1970 TRUNCATE TABLE t1;
1971 INSERT INTO t1 VALUES(null);
1972 SELECT * FROM t1;
1973 c1
1974 NULL
1975 DROP TABLE t1;
1976 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1977 SHOW CREATE TABLE t1;
1978 Table Create Table
1979 t1 CREATE TABLE `t1` (
1980 `c1` bigint unsigned AUTO_INCREMENT,
1981 UNIQUE KEY `c1` (`c1`)
1982 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1983 INSERT INTO t1 VALUES(null);
1984 INSERT INTO t1 VALUES(null);
1985 INSERT INTO t1 VALUES(null);
1986 SELECT * FROM t1;
1987 c1
1988 NULL
1989 NULL
1990 NULL
1991 TRUNCATE TABLE t1;
1992 INSERT INTO t1 VALUES(null);
1993 SELECT * FROM t1;
1994 c1
1995 NULL
1996 ALTER TABLE t1 AUTO_INCREMENT=10;
1997 SHOW CREATE TABLE t1;
1998 Table Create Table
1999 t1 CREATE TABLE `t1` (
2000 `c1` bigint unsigned AUTO_INCREMENT,
2001 UNIQUE KEY `c1` (`c1`)
2002 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2003 INSERT INTO t1 VALUES(null);
2004 INSERT INTO t1 VALUES(null);
2005 INSERT INTO t1 VALUES(null);
2006 SELECT * FROM t1;
2007 c1
2008 NULL
2009 NULL
2010 NULL
2011 NULL
2012 TRUNCATE TABLE t1;
2013 INSERT INTO t1 VALUES(null);
2014 SELECT * FROM t1;
2015 c1
2016 NULL
2017 DROP TABLE t1;
2018 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
2019 SHOW CREATE TABLE t1;
2020 Table Create Table
2021 t1 CREATE TABLE `t1` (
2022 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
2023 UNIQUE KEY `c1` (`c1`)
2024 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2025 INSERT INTO t1 VALUES(null);
2026 INSERT INTO t1 VALUES(null);
2027 INSERT INTO t1 VALUES(null);
2028 SELECT * FROM t1;
2029 c1
2030 10
2031 11
2032 12
2033 TRUNCATE TABLE t1;
2034 INSERT INTO t1 VALUES(null);
2035 SELECT * FROM t1;
2036 c1
2037 1
2038 ALTER TABLE t1 AUTO_INCREMENT=10;
2039 SHOW CREATE TABLE t1;
2040 Table Create Table
2041 t1 CREATE TABLE `t1` (
2042 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
2043 UNIQUE KEY `c1` (`c1`)
2044 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2045 INSERT INTO t1 VALUES(null);
2046 INSERT INTO t1 VALUES(null);
2047 INSERT INTO t1 VALUES(null);
2048 SELECT * FROM t1;
2049 c1
2050 1
2051 10
2052 11
2053 12
2054 TRUNCATE TABLE t1;
2055 INSERT INTO t1 VALUES(null);
2056 SELECT * FROM t1;
2057 c1
2058 1
2059 DROP TABLE t1;
2060 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
2061 SHOW CREATE TABLE t1;
2062 Table Create Table
2063 t1 CREATE TABLE `t1` (
2064 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
2065 UNIQUE KEY `c1` (`c1`)
2066 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2067 INSERT INTO t1 VALUES(null);
2068 INSERT INTO t1 VALUES(null);
2069 INSERT INTO t1 VALUES(null);
2070 SELECT * FROM t1;
2071 c1
2072 10
2073 11
2074 12
2075 TRUNCATE TABLE t1;
2076 INSERT INTO t1 VALUES(null);
2077 SELECT * FROM t1;
2078 c1
2079 1
2080 ALTER TABLE t1 AUTO_INCREMENT=10;
2081 SHOW CREATE TABLE t1;
2082 Table Create Table
2083 t1 CREATE TABLE `t1` (
2084 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
2085 UNIQUE KEY `c1` (`c1`)
2086 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2087 INSERT INTO t1 VALUES(null);
2088 INSERT INTO t1 VALUES(null);
2089 INSERT INTO t1 VALUES(null);
2090 SELECT * FROM t1;
2091 c1
2092 1
2093 10
2094 11
2095 12
2096 TRUNCATE TABLE t1;
2097 INSERT INTO t1 VALUES(null);
2098 SELECT * FROM t1;
2099 c1
2100 1
2101 DROP TABLE t1;
2102 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
2103 SHOW CREATE TABLE t1;
2104 Table Create Table
2105 t1 CREATE TABLE `t1` (
2106 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
2107 UNIQUE KEY `c1` (`c1`)
2108 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2109 INSERT INTO t1 VALUES(null);
2110 INSERT INTO t1 VALUES(null);
2111 INSERT INTO t1 VALUES(null);
2112 SELECT * FROM t1;
2113 c1
2114 10
2115 11
2116 12
2117 TRUNCATE TABLE t1;
2118 INSERT INTO t1 VALUES(null);
2119 SELECT * FROM t1;
2120 c1
2121 1
2122 ALTER TABLE t1 AUTO_INCREMENT=10;
2123 SHOW CREATE TABLE t1;
2124 Table Create Table
2125 t1 CREATE TABLE `t1` (
2126 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
2127 UNIQUE KEY `c1` (`c1`)
2128 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2129 INSERT INTO t1 VALUES(null);
2130 INSERT INTO t1 VALUES(null);
2131 INSERT INTO t1 VALUES(null);
2132 SELECT * FROM t1;
2133 c1
2134 1
2135 10
2136 11
2137 12
2138 TRUNCATE TABLE t1;
2139 INSERT INTO t1 VALUES(null);
2140 SELECT * FROM t1;
2141 c1
2142 1
2143 DROP TABLE t1;
2144 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
2145 SHOW CREATE TABLE t1;
2146 Table Create Table
2147 t1 CREATE TABLE `t1` (
2148 `c1` int unsigned NOT NULL AUTO_INCREMENT,
2149 UNIQUE KEY `c1` (`c1`)
2150 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2151 INSERT INTO t1 VALUES(null);
2152 INSERT INTO t1 VALUES(null);
2153 INSERT INTO t1 VALUES(null);
2154 SELECT * FROM t1;
2155 c1
2156 10
2157 11
2158 12
2159 TRUNCATE TABLE t1;
2160 INSERT INTO t1 VALUES(null);
2161 SELECT * FROM t1;
2162 c1
2163 1
2164 ALTER TABLE t1 AUTO_INCREMENT=10;
2165 SHOW CREATE TABLE t1;
2166 Table Create Table
2167 t1 CREATE TABLE `t1` (
2168 `c1` int unsigned NOT NULL AUTO_INCREMENT,
2169 UNIQUE KEY `c1` (`c1`)
2170 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2171 INSERT INTO t1 VALUES(null);
2172 INSERT INTO t1 VALUES(null);
2173 INSERT INTO t1 VALUES(null);
2174 SELECT * FROM t1;
2175 c1
2176 1
2177 10
2178 11
2179 12
2180 TRUNCATE TABLE t1;
2181 INSERT INTO t1 VALUES(null);
2182 SELECT * FROM t1;
2183 c1
2184 1
2185 DROP TABLE t1;
2186 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
2187 SHOW CREATE TABLE t1;
2188 Table Create Table
2189 t1 CREATE TABLE `t1` (
2190 `c1` int unsigned NOT NULL AUTO_INCREMENT,
2191 UNIQUE KEY `c1` (`c1`)
2192 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2193 INSERT INTO t1 VALUES(null);
2194 INSERT INTO t1 VALUES(null);
2195 INSERT INTO t1 VALUES(null);
2196 SELECT * FROM t1;
2197 c1
2198 10
2199 11
2200 12
2201 TRUNCATE TABLE t1;
2202 INSERT INTO t1 VALUES(null);
2203 SELECT * FROM t1;
2204 c1
2205 1
2206 ALTER TABLE t1 AUTO_INCREMENT=10;
2207 SHOW CREATE TABLE t1;
2208 Table Create Table
2209 t1 CREATE TABLE `t1` (
2210 `c1` int unsigned NOT NULL AUTO_INCREMENT,
2211 UNIQUE KEY `c1` (`c1`)
2212 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2213 INSERT INTO t1 VALUES(null);
2214 INSERT INTO t1 VALUES(null);
2215 INSERT INTO t1 VALUES(null);
2216 SELECT * FROM t1;
2217 c1
2218 1
2219 10
2220 11
2221 12
2222 TRUNCATE TABLE t1;
2223 INSERT INTO t1 VALUES(null);
2224 SELECT * FROM t1;
2225 c1
2226 1
2227 DROP TABLE t1;
2228 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
2229 SHOW CREATE TABLE t1;
2230 Table Create Table
2231 t1 CREATE TABLE `t1` (
2232 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
2233 UNIQUE KEY `c1` (`c1`)
2234 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2235 INSERT INTO t1 VALUES(null);
2236 INSERT INTO t1 VALUES(null);
2237 INSERT INTO t1 VALUES(null);
2238 SELECT * FROM t1;
2239 c1
2240 10
2241 11
2242 12
2243 TRUNCATE TABLE t1;
2244 INSERT INTO t1 VALUES(null);
2245 SELECT * FROM t1;
2246 c1
2247 1
2248 ALTER TABLE t1 AUTO_INCREMENT=10;
2249 SHOW CREATE TABLE t1;
2250 Table Create Table
2251 t1 CREATE TABLE `t1` (
2252 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
2253 UNIQUE KEY `c1` (`c1`)
2254 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2255 INSERT INTO t1 VALUES(null);
2256 INSERT INTO t1 VALUES(null);
2257 INSERT INTO t1 VALUES(null);
2258 SELECT * FROM t1;
2259 c1
2260 1
2261 10
2262 11
2263 12
2264 TRUNCATE TABLE t1;
2265 INSERT INTO t1 VALUES(null);
2266 SELECT * FROM t1;
2267 c1
2268 1
2269 DROP TABLE t1;
2270 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
2271 SHOW CREATE TABLE t1;
2272 Table Create Table
2273 t1 CREATE TABLE `t1` (
2274 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
2275 PRIMARY KEY (`c1`)
2276 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2277 INSERT INTO t1 VALUES(null);
2278 INSERT INTO t1 VALUES(null);
2279 INSERT INTO t1 VALUES(null);
2280 SELECT * FROM t1;
2281 c1
2282 10
2283 11
2284 12
2285 TRUNCATE TABLE t1;
2286 INSERT INTO t1 VALUES(null);
2287 SELECT * FROM t1;
2288 c1
2289 1
2290 ALTER TABLE t1 AUTO_INCREMENT=10;
2291 SHOW CREATE TABLE t1;
2292 Table Create Table
2293 t1 CREATE TABLE `t1` (
2294 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
2295 PRIMARY KEY (`c1`)
2296 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2297 INSERT INTO t1 VALUES(null);
2298 INSERT INTO t1 VALUES(null);
2299 INSERT INTO t1 VALUES(null);
2300 SELECT * FROM t1;
2301 c1
2302 1
2303 10
2304 11
2305 12
2306 TRUNCATE TABLE t1;
2307 INSERT INTO t1 VALUES(null);
2308 SELECT * FROM t1;
2309 c1
2310 1
2311 DROP TABLE t1;
2312 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
2313 SHOW CREATE TABLE t1;
2314 Table Create Table
2315 t1 CREATE TABLE `t1` (
2316 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
2317 PRIMARY KEY (`c1`)
2318 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2319 INSERT INTO t1 VALUES(null);
2320 INSERT INTO t1 VALUES(null);
2321 INSERT INTO t1 VALUES(null);
2322 SELECT * FROM t1;
2323 c1
2324 10
2325 11
2326 12
2327 TRUNCATE TABLE t1;
2328 INSERT INTO t1 VALUES(null);
2329 SELECT * FROM t1;
2330 c1
2331 1
2332 ALTER TABLE t1 AUTO_INCREMENT=10;
2333 SHOW CREATE TABLE t1;
2334 Table Create Table
2335 t1 CREATE TABLE `t1` (
2336 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
2337 PRIMARY KEY (`c1`)
2338 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2339 INSERT INTO t1 VALUES(null);
2340 INSERT INTO t1 VALUES(null);
2341 INSERT INTO t1 VALUES(null);
2342 SELECT * FROM t1;
2343 c1
2344 1
2345 10
2346 11
2347 12
2348 TRUNCATE TABLE t1;
2349 INSERT INTO t1 VALUES(null);
2350 SELECT * FROM t1;
2351 c1
2352 1
2353 DROP TABLE t1;
2354 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
2355 SHOW CREATE TABLE t1;
2356 Table Create Table
2357 t1 CREATE TABLE `t1` (
2358 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
2359 PRIMARY KEY (`c1`)
2360 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2361 INSERT INTO t1 VALUES(null);
2362 INSERT INTO t1 VALUES(null);
2363 INSERT INTO t1 VALUES(null);
2364 SELECT * FROM t1;
2365 c1
2366 10
2367 11
2368 12
2369 TRUNCATE TABLE t1;
2370 INSERT INTO t1 VALUES(null);
2371 SELECT * FROM t1;
2372 c1
2373 1
2374 ALTER TABLE t1 AUTO_INCREMENT=10;
2375 SHOW CREATE TABLE t1;
2376 Table Create Table
2377 t1 CREATE TABLE `t1` (
2378 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
2379 PRIMARY KEY (`c1`)
2380 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2381 INSERT INTO t1 VALUES(null);
2382 INSERT INTO t1 VALUES(null);
2383 INSERT INTO t1 VALUES(null);
2384 SELECT * FROM t1;
2385 c1
2386 1
2387 10
2388 11
2389 12
2390 TRUNCATE TABLE t1;
2391 INSERT INTO t1 VALUES(null);
2392 SELECT * FROM t1;
2393 c1
2394 1
2395 DROP TABLE t1;
2396 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
2397 SHOW CREATE TABLE t1;
2398 Table Create Table
2399 t1 CREATE TABLE `t1` (
2400 `c1` int unsigned NOT NULL AUTO_INCREMENT,
2401 PRIMARY KEY (`c1`)
2402 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2403 INSERT INTO t1 VALUES(null);
2404 INSERT INTO t1 VALUES(null);
2405 INSERT INTO t1 VALUES(null);
2406 SELECT * FROM t1;
2407 c1
2408 10
2409 11
2410 12
2411 TRUNCATE TABLE t1;
2412 INSERT INTO t1 VALUES(null);
2413 SELECT * FROM t1;
2414 c1
2415 1
2416 ALTER TABLE t1 AUTO_INCREMENT=10;
2417 SHOW CREATE TABLE t1;
2418 Table Create Table
2419 t1 CREATE TABLE `t1` (
2420 `c1` int unsigned NOT NULL AUTO_INCREMENT,
2421 PRIMARY KEY (`c1`)
2422 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2423 INSERT INTO t1 VALUES(null);
2424 INSERT INTO t1 VALUES(null);
2425 INSERT INTO t1 VALUES(null);
2426 SELECT * FROM t1;
2427 c1
2428 1
2429 10
2430 11
2431 12
2432 TRUNCATE TABLE t1;
2433 INSERT INTO t1 VALUES(null);
2434 SELECT * FROM t1;
2435 c1
2436 1
2437 DROP TABLE t1;
2438 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
2439 SHOW CREATE TABLE t1;
2440 Table Create Table
2441 t1 CREATE TABLE `t1` (
2442 `c1` int unsigned NOT NULL AUTO_INCREMENT,
2443 PRIMARY KEY (`c1`)
2444 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2445 INSERT INTO t1 VALUES(null);
2446 INSERT INTO t1 VALUES(null);
2447 INSERT INTO t1 VALUES(null);
2448 SELECT * FROM t1;
2449 c1
2450 10
2451 11
2452 12
2453 TRUNCATE TABLE t1;
2454 INSERT INTO t1 VALUES(null);
2455 SELECT * FROM t1;
2456 c1
2457 1
2458 ALTER TABLE t1 AUTO_INCREMENT=10;
2459 SHOW CREATE TABLE t1;
2460 Table Create Table
2461 t1 CREATE TABLE `t1` (
2462 `c1` int unsigned NOT NULL AUTO_INCREMENT,
2463 PRIMARY KEY (`c1`)
2464 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2465 INSERT INTO t1 VALUES(null);
2466 INSERT INTO t1 VALUES(null);
2467 INSERT INTO t1 VALUES(null);
2468 SELECT * FROM t1;
2469 c1
2470 1
2471 10
2472 11
2473 12
2474 TRUNCATE TABLE t1;
2475 INSERT INTO t1 VALUES(null);
2476 SELECT * FROM t1;
2477 c1
2478 1
2479 DROP TABLE t1;
2480 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
2481 SHOW CREATE TABLE t1;
2482 Table Create Table
2483 t1 CREATE TABLE `t1` (
2484 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
2485 PRIMARY KEY (`c1`)
2486 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2487 INSERT INTO t1 VALUES(null);
2488 INSERT INTO t1 VALUES(null);
2489 INSERT INTO t1 VALUES(null);
2490 SELECT * FROM t1;
2491 c1
2492 10
2493 11
2494 12
2495 TRUNCATE TABLE t1;
2496 INSERT INTO t1 VALUES(null);
2497 SELECT * FROM t1;
2498 c1
2499 1
2500 ALTER TABLE t1 AUTO_INCREMENT=10;
2501 SHOW CREATE TABLE t1;
2502 Table Create Table
2503 t1 CREATE TABLE `t1` (
2504 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
2505 PRIMARY KEY (`c1`)
2506 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2507 INSERT INTO t1 VALUES(null);
2508 INSERT INTO t1 VALUES(null);
2509 INSERT INTO t1 VALUES(null);
2510 SELECT * FROM t1;
2511 c1
2512 1
2513 10
2514 11
2515 12
2516 TRUNCATE TABLE t1;
2517 INSERT INTO t1 VALUES(null);
2518 SELECT * FROM t1;
2519 c1
2520 1
2521 DROP TABLE t1;