Debian Codegraph @

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