Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY );
3 ALTER TABLE t1 AUTO_INCREMENT=10;
4 SHOW CREATE TABLE t1;
5 Table Create Table
6 t1 CREATE TABLE `t1` (
7 `c1` tinyint NOT NULL AUTO_INCREMENT,
8 PRIMARY KEY (`c1`)
9 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
23 SHOW CREATE TABLE t1;
24 Table Create Table
25 t1 CREATE TABLE `t1` (
26 `c1` smallint 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 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 ALTER TABLE t1 AUTO_INCREMENT=10;
42 SHOW CREATE TABLE t1;
43 Table Create Table
44 t1 CREATE TABLE `t1` (
45 `c1` mediumint NOT NULL AUTO_INCREMENT,
46 PRIMARY KEY (`c1`)
47 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
61 SHOW CREATE TABLE t1;
62 Table Create Table
63 t1 CREATE TABLE `t1` (
64 `c1` int NOT NULL AUTO_INCREMENT,
65 PRIMARY KEY (`c1`)
66 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
80 SHOW CREATE TABLE t1;
81 Table Create Table
82 t1 CREATE TABLE `t1` (
83 `c1` int NOT NULL AUTO_INCREMENT,
84 PRIMARY KEY (`c1`)
85 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
99 SHOW CREATE TABLE t1;
100 Table Create Table
101 t1 CREATE TABLE `t1` (
102 `c1` bigint NOT NULL AUTO_INCREMENT,
103 PRIMARY KEY (`c1`)
104 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
118 SHOW CREATE TABLE t1;
119 Table Create Table
120 t1 CREATE TABLE `t1` (
121 `c1` tinyint NOT NULL AUTO_INCREMENT,
122 PRIMARY KEY (`c1`)
123 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
137 SHOW CREATE TABLE t1;
138 Table Create Table
139 t1 CREATE TABLE `t1` (
140 `c1` smallint NOT NULL AUTO_INCREMENT,
141 PRIMARY KEY (`c1`)
142 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
156 SHOW CREATE TABLE t1;
157 Table Create Table
158 t1 CREATE TABLE `t1` (
159 `c1` mediumint NOT NULL AUTO_INCREMENT,
160 PRIMARY KEY (`c1`)
161 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
175 SHOW CREATE TABLE t1;
176 Table Create Table
177 t1 CREATE TABLE `t1` (
178 `c1` int NOT NULL AUTO_INCREMENT,
179 PRIMARY KEY (`c1`)
180 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
194 SHOW CREATE TABLE t1;
195 Table Create Table
196 t1 CREATE TABLE `t1` (
197 `c1` int NOT NULL AUTO_INCREMENT,
198 PRIMARY KEY (`c1`)
199 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 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 DROP TABLE t1;
228 SHOW TABLES;
229 Tables_in_test
230 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY );
231 ALTER TABLE t1 AUTO_INCREMENT=10;
232 SHOW CREATE TABLE t1;
233 Table Create Table
234 t1 CREATE TABLE `t1` (
235 `c1` tinyint AUTO_INCREMENT,
236 UNIQUE KEY `c1` (`c1`)
237 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
251 SHOW CREATE TABLE t1;
252 Table Create Table
253 t1 CREATE TABLE `t1` (
254 `c1` smallint AUTO_INCREMENT,
255 UNIQUE KEY `c1` (`c1`)
256 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
270 SHOW CREATE TABLE t1;
271 Table Create Table
272 t1 CREATE TABLE `t1` (
273 `c1` mediumint AUTO_INCREMENT,
274 UNIQUE KEY `c1` (`c1`)
275 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
289 SHOW CREATE TABLE t1;
290 Table Create Table
291 t1 CREATE TABLE `t1` (
292 `c1` int AUTO_INCREMENT,
293 UNIQUE KEY `c1` (`c1`)
294 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
308 SHOW CREATE TABLE t1;
309 Table Create Table
310 t1 CREATE TABLE `t1` (
311 `c1` int AUTO_INCREMENT,
312 UNIQUE KEY `c1` (`c1`)
313 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
327 SHOW CREATE TABLE t1;
328 Table Create Table
329 t1 CREATE TABLE `t1` (
330 `c1` bigint AUTO_INCREMENT,
331 UNIQUE KEY `c1` (`c1`)
332 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
346 SHOW CREATE TABLE t1;
347 Table Create Table
348 t1 CREATE TABLE `t1` (
349 `c1` tinyint NOT NULL AUTO_INCREMENT,
350 UNIQUE KEY `c1` (`c1`)
351 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
365 SHOW CREATE TABLE t1;
366 Table Create Table
367 t1 CREATE TABLE `t1` (
368 `c1` smallint NOT NULL AUTO_INCREMENT,
369 UNIQUE KEY `c1` (`c1`)
370 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
384 SHOW CREATE TABLE t1;
385 Table Create Table
386 t1 CREATE TABLE `t1` (
387 `c1` mediumint NOT NULL AUTO_INCREMENT,
388 UNIQUE KEY `c1` (`c1`)
389 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
403 SHOW CREATE TABLE t1;
404 Table Create Table
405 t1 CREATE TABLE `t1` (
406 `c1` int NOT NULL AUTO_INCREMENT,
407 UNIQUE KEY `c1` (`c1`)
408 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
422 SHOW CREATE TABLE t1;
423 Table Create Table
424 t1 CREATE TABLE `t1` (
425 `c1` int NOT NULL AUTO_INCREMENT,
426 UNIQUE KEY `c1` (`c1`)
427 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
441 SHOW CREATE TABLE t1;
442 Table Create Table
443 t1 CREATE TABLE `t1` (
444 `c1` bigint NOT NULL AUTO_INCREMENT,
445 UNIQUE KEY `c1` (`c1`)
446 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
460 SHOW CREATE TABLE t1;
461 Table Create Table
462 t1 CREATE TABLE `t1` (
463 `c1` tinyint NOT NULL AUTO_INCREMENT,
464 PRIMARY KEY (`c1`)
465 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
479 SHOW CREATE TABLE t1;
480 Table Create Table
481 t1 CREATE TABLE `t1` (
482 `c1` smallint NOT NULL AUTO_INCREMENT,
483 PRIMARY KEY (`c1`)
484 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
498 SHOW CREATE TABLE t1;
499 Table Create Table
500 t1 CREATE TABLE `t1` (
501 `c1` mediumint NOT NULL AUTO_INCREMENT,
502 PRIMARY KEY (`c1`)
503 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
517 SHOW CREATE TABLE t1;
518 Table Create Table
519 t1 CREATE TABLE `t1` (
520 `c1` int NOT NULL AUTO_INCREMENT,
521 PRIMARY KEY (`c1`)
522 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
536 SHOW CREATE TABLE t1;
537 Table Create Table
538 t1 CREATE TABLE `t1` (
539 `c1` int NOT NULL AUTO_INCREMENT,
540 PRIMARY KEY (`c1`)
541 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
555 SHOW CREATE TABLE t1;
556 Table Create Table
557 t1 CREATE TABLE `t1` (
558 `c1` bigint NOT NULL AUTO_INCREMENT,
559 PRIMARY KEY (`c1`)
560 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
574 SHOW CREATE TABLE t1;
575 Table Create Table
576 t1 CREATE TABLE `t1` (
577 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
578 PRIMARY KEY (`c1`)
579 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
593 SHOW CREATE TABLE t1;
594 Table Create Table
595 t1 CREATE TABLE `t1` (
596 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
597 PRIMARY KEY (`c1`)
598 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
612 SHOW CREATE TABLE t1;
613 Table Create Table
614 t1 CREATE TABLE `t1` (
615 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
616 PRIMARY KEY (`c1`)
617 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
631 SHOW CREATE TABLE t1;
632 Table Create Table
633 t1 CREATE TABLE `t1` (
634 `c1` int unsigned NOT NULL AUTO_INCREMENT,
635 PRIMARY KEY (`c1`)
636 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
650 SHOW CREATE TABLE t1;
651 Table Create Table
652 t1 CREATE TABLE `t1` (
653 `c1` int unsigned NOT NULL AUTO_INCREMENT,
654 PRIMARY KEY (`c1`)
655 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
669 SHOW CREATE TABLE t1;
670 Table Create Table
671 t1 CREATE TABLE `t1` (
672 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
673 PRIMARY KEY (`c1`)
674 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
688 SHOW CREATE TABLE t1;
689 Table Create Table
690 t1 CREATE TABLE `t1` (
691 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
692 PRIMARY KEY (`c1`)
693 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
707 SHOW CREATE TABLE t1;
708 Table Create Table
709 t1 CREATE TABLE `t1` (
710 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
711 PRIMARY KEY (`c1`)
712 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
726 SHOW CREATE TABLE t1;
727 Table Create Table
728 t1 CREATE TABLE `t1` (
729 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
730 PRIMARY KEY (`c1`)
731 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
745 SHOW CREATE TABLE t1;
746 Table Create Table
747 t1 CREATE TABLE `t1` (
748 `c1` int unsigned NOT NULL AUTO_INCREMENT,
749 PRIMARY KEY (`c1`)
750 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
764 SHOW CREATE TABLE t1;
765 Table Create Table
766 t1 CREATE TABLE `t1` (
767 `c1` int unsigned NOT NULL AUTO_INCREMENT,
768 PRIMARY KEY (`c1`)
769 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
783 SHOW CREATE TABLE t1;
784 Table Create Table
785 t1 CREATE TABLE `t1` (
786 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
787 PRIMARY KEY (`c1`)
788 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
802 SHOW CREATE TABLE t1;
803 Table Create Table
804 t1 CREATE TABLE `t1` (
805 `c1` tinyint unsigned AUTO_INCREMENT,
806 UNIQUE KEY `c1` (`c1`)
807 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
821 SHOW CREATE TABLE t1;
822 Table Create Table
823 t1 CREATE TABLE `t1` (
824 `c1` smallint unsigned 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 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 ALTER TABLE t1 AUTO_INCREMENT=10;
840 SHOW CREATE TABLE t1;
841 Table Create Table
842 t1 CREATE TABLE `t1` (
843 `c1` mediumint unsigned AUTO_INCREMENT,
844 UNIQUE KEY `c1` (`c1`)
845 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
859 SHOW CREATE TABLE t1;
860 Table Create Table
861 t1 CREATE TABLE `t1` (
862 `c1` int unsigned AUTO_INCREMENT,
863 UNIQUE KEY `c1` (`c1`)
864 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
878 SHOW CREATE TABLE t1;
879 Table Create Table
880 t1 CREATE TABLE `t1` (
881 `c1` int unsigned AUTO_INCREMENT,
882 UNIQUE KEY `c1` (`c1`)
883 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
897 SHOW CREATE TABLE t1;
898 Table Create Table
899 t1 CREATE TABLE `t1` (
900 `c1` bigint unsigned AUTO_INCREMENT,
901 UNIQUE KEY `c1` (`c1`)
902 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
916 SHOW CREATE TABLE t1;
917 Table Create Table
918 t1 CREATE TABLE `t1` (
919 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
920 UNIQUE KEY `c1` (`c1`)
921 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
935 SHOW CREATE TABLE t1;
936 Table Create Table
937 t1 CREATE TABLE `t1` (
938 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
939 UNIQUE KEY `c1` (`c1`)
940 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
954 SHOW CREATE TABLE t1;
955 Table Create Table
956 t1 CREATE TABLE `t1` (
957 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
958 UNIQUE KEY `c1` (`c1`)
959 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
973 SHOW CREATE TABLE t1;
974 Table Create Table
975 t1 CREATE TABLE `t1` (
976 `c1` int unsigned NOT NULL AUTO_INCREMENT,
977 UNIQUE KEY `c1` (`c1`)
978 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
992 SHOW CREATE TABLE t1;
993 Table Create Table
994 t1 CREATE TABLE `t1` (
995 `c1` int unsigned NOT NULL AUTO_INCREMENT,
996 UNIQUE KEY `c1` (`c1`)
997 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
1011 SHOW CREATE TABLE t1;
1012 Table Create Table
1013 t1 CREATE TABLE `t1` (
1014 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
1015 UNIQUE KEY `c1` (`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 DROP TABLE t1;
1026 SHOW TABLES;
1027 Tables_in_test
1028 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1029 ALTER TABLE t1 AUTO_INCREMENT=10;
1030 SHOW CREATE TABLE t1;
1031 Table Create Table
1032 t1 CREATE TABLE `t1` (
1033 `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
1034 PRIMARY KEY (`c1`)
1035 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
1049 SHOW CREATE TABLE t1;
1050 Table Create Table
1051 t1 CREATE TABLE `t1` (
1052 `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
1053 PRIMARY KEY (`c1`)
1054 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
1068 SHOW CREATE TABLE t1;
1069 Table Create Table
1070 t1 CREATE TABLE `t1` (
1071 `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
1072 PRIMARY KEY (`c1`)
1073 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
1087 SHOW CREATE TABLE t1;
1088 Table Create Table
1089 t1 CREATE TABLE `t1` (
1090 `c1` int unsigned NOT NULL AUTO_INCREMENT,
1091 PRIMARY KEY (`c1`)
1092 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
1106 SHOW CREATE TABLE t1;
1107 Table Create Table
1108 t1 CREATE TABLE `t1` (
1109 `c1` int unsigned NOT NULL AUTO_INCREMENT,
1110 PRIMARY KEY (`c1`)
1111 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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 ALTER TABLE t1 AUTO_INCREMENT=10;
1125 SHOW CREATE TABLE t1;
1126 Table Create Table
1127 t1 CREATE TABLE `t1` (
1128 `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
1129 PRIMARY KEY (`c1`)
1130 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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