1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
6 `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
8 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
9 INSERT INTO t1 VALUES(null);
10 INSERT INTO t1 VALUES(null);
11 INSERT INTO t1 VALUES(null);
18 INSERT INTO t1 VALUES(null);
22 ALTER TABLE t1 AUTO_INCREMENT=10;
25 t1 CREATE TABLE `t1` (
26 `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
28 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
29 INSERT INTO t1 VALUES(null);
30 INSERT INTO t1 VALUES(null);
31 INSERT INTO t1 VALUES(null);
39 INSERT INTO t1 VALUES(null);
44 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
47 t1 CREATE TABLE `t1` (
48 `c1` smallint(6) NOT NULL AUTO_INCREMENT,
50 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
51 INSERT INTO t1 VALUES(null);
52 INSERT INTO t1 VALUES(null);
53 INSERT INTO t1 VALUES(null);
60 INSERT INTO t1 VALUES(null);
64 ALTER TABLE t1 AUTO_INCREMENT=10;
67 t1 CREATE TABLE `t1` (
68 `c1` smallint(6) NOT NULL AUTO_INCREMENT,
70 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
71 INSERT INTO t1 VALUES(null);
72 INSERT INTO t1 VALUES(null);
73 INSERT INTO t1 VALUES(null);
81 INSERT INTO t1 VALUES(null);
86 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
89 t1 CREATE TABLE `t1` (
90 `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
92 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
93 INSERT INTO t1 VALUES(null);
94 INSERT INTO t1 VALUES(null);
95 INSERT INTO t1 VALUES(null);
102 INSERT INTO t1 VALUES(null);
106 ALTER TABLE t1 AUTO_INCREMENT=10;
107 SHOW CREATE TABLE t1;
109 t1 CREATE TABLE `t1` (
110 `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
112 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
113 INSERT INTO t1 VALUES(null);
114 INSERT INTO t1 VALUES(null);
115 INSERT INTO t1 VALUES(null);
123 INSERT INTO t1 VALUES(null);
128 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
129 SHOW CREATE TABLE t1;
131 t1 CREATE TABLE `t1` (
132 `c1` int(11) NOT NULL AUTO_INCREMENT,
134 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
135 INSERT INTO t1 VALUES(null);
136 INSERT INTO t1 VALUES(null);
137 INSERT INTO t1 VALUES(null);
144 INSERT INTO t1 VALUES(null);
148 ALTER TABLE t1 AUTO_INCREMENT=10;
149 SHOW CREATE TABLE t1;
151 t1 CREATE TABLE `t1` (
152 `c1` int(11) NOT NULL AUTO_INCREMENT,
154 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
155 INSERT INTO t1 VALUES(null);
156 INSERT INTO t1 VALUES(null);
157 INSERT INTO t1 VALUES(null);
165 INSERT INTO t1 VALUES(null);
170 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
171 SHOW CREATE TABLE t1;
173 t1 CREATE TABLE `t1` (
174 `c1` int(11) NOT NULL AUTO_INCREMENT,
176 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
177 INSERT INTO t1 VALUES(null);
178 INSERT INTO t1 VALUES(null);
179 INSERT INTO t1 VALUES(null);
186 INSERT INTO t1 VALUES(null);
190 ALTER TABLE t1 AUTO_INCREMENT=10;
191 SHOW CREATE TABLE t1;
193 t1 CREATE TABLE `t1` (
194 `c1` int(11) NOT NULL AUTO_INCREMENT,
196 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
197 INSERT INTO t1 VALUES(null);
198 INSERT INTO t1 VALUES(null);
199 INSERT INTO t1 VALUES(null);
207 INSERT INTO t1 VALUES(null);
212 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
213 SHOW CREATE TABLE t1;
215 t1 CREATE TABLE `t1` (
216 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
218 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
219 INSERT INTO t1 VALUES(null);
220 INSERT INTO t1 VALUES(null);
221 INSERT INTO t1 VALUES(null);
228 INSERT INTO t1 VALUES(null);
232 ALTER TABLE t1 AUTO_INCREMENT=10;
233 SHOW CREATE TABLE t1;
235 t1 CREATE TABLE `t1` (
236 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
238 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
239 INSERT INTO t1 VALUES(null);
240 INSERT INTO t1 VALUES(null);
241 INSERT INTO t1 VALUES(null);
249 INSERT INTO t1 VALUES(null);
254 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
255 SHOW CREATE TABLE t1;
257 t1 CREATE TABLE `t1` (
258 `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
260 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
261 INSERT INTO t1 VALUES(null);
262 INSERT INTO t1 VALUES(null);
263 INSERT INTO t1 VALUES(null);
270 INSERT INTO t1 VALUES(null);
274 ALTER TABLE t1 AUTO_INCREMENT=10;
275 SHOW CREATE TABLE t1;
277 t1 CREATE TABLE `t1` (
278 `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
280 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
281 INSERT INTO t1 VALUES(null);
282 INSERT INTO t1 VALUES(null);
283 INSERT INTO t1 VALUES(null);
291 INSERT INTO t1 VALUES(null);
296 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
297 SHOW CREATE TABLE t1;
299 t1 CREATE TABLE `t1` (
300 `c1` smallint(6) NOT NULL AUTO_INCREMENT,
302 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
303 INSERT INTO t1 VALUES(null);
304 INSERT INTO t1 VALUES(null);
305 INSERT INTO t1 VALUES(null);
312 INSERT INTO t1 VALUES(null);
316 ALTER TABLE t1 AUTO_INCREMENT=10;
317 SHOW CREATE TABLE t1;
319 t1 CREATE TABLE `t1` (
320 `c1` smallint(6) NOT NULL AUTO_INCREMENT,
322 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
323 INSERT INTO t1 VALUES(null);
324 INSERT INTO t1 VALUES(null);
325 INSERT INTO t1 VALUES(null);
333 INSERT INTO t1 VALUES(null);
338 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
339 SHOW CREATE TABLE t1;
341 t1 CREATE TABLE `t1` (
342 `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
344 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
345 INSERT INTO t1 VALUES(null);
346 INSERT INTO t1 VALUES(null);
347 INSERT INTO t1 VALUES(null);
354 INSERT INTO t1 VALUES(null);
358 ALTER TABLE t1 AUTO_INCREMENT=10;
359 SHOW CREATE TABLE t1;
361 t1 CREATE TABLE `t1` (
362 `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
364 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
365 INSERT INTO t1 VALUES(null);
366 INSERT INTO t1 VALUES(null);
367 INSERT INTO t1 VALUES(null);
375 INSERT INTO t1 VALUES(null);
380 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
381 SHOW CREATE TABLE t1;
383 t1 CREATE TABLE `t1` (
384 `c1` int(11) NOT NULL AUTO_INCREMENT,
386 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
387 INSERT INTO t1 VALUES(null);
388 INSERT INTO t1 VALUES(null);
389 INSERT INTO t1 VALUES(null);
396 INSERT INTO t1 VALUES(null);
400 ALTER TABLE t1 AUTO_INCREMENT=10;
401 SHOW CREATE TABLE t1;
403 t1 CREATE TABLE `t1` (
404 `c1` int(11) NOT NULL AUTO_INCREMENT,
406 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
407 INSERT INTO t1 VALUES(null);
408 INSERT INTO t1 VALUES(null);
409 INSERT INTO t1 VALUES(null);
417 INSERT INTO t1 VALUES(null);
422 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
423 SHOW CREATE TABLE t1;
425 t1 CREATE TABLE `t1` (
426 `c1` int(11) NOT NULL AUTO_INCREMENT,
428 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
429 INSERT INTO t1 VALUES(null);
430 INSERT INTO t1 VALUES(null);
431 INSERT INTO t1 VALUES(null);
438 INSERT INTO t1 VALUES(null);
442 ALTER TABLE t1 AUTO_INCREMENT=10;
443 SHOW CREATE TABLE t1;
445 t1 CREATE TABLE `t1` (
446 `c1` int(11) NOT NULL AUTO_INCREMENT,
448 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
449 INSERT INTO t1 VALUES(null);
450 INSERT INTO t1 VALUES(null);
451 INSERT INTO t1 VALUES(null);
459 INSERT INTO t1 VALUES(null);
464 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
465 SHOW CREATE TABLE t1;
467 t1 CREATE TABLE `t1` (
468 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
470 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
471 INSERT INTO t1 VALUES(null);
472 INSERT INTO t1 VALUES(null);
473 INSERT INTO t1 VALUES(null);
480 INSERT INTO t1 VALUES(null);
484 ALTER TABLE t1 AUTO_INCREMENT=10;
485 SHOW CREATE TABLE t1;
487 t1 CREATE TABLE `t1` (
488 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
490 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
491 INSERT INTO t1 VALUES(null);
492 INSERT INTO t1 VALUES(null);
493 INSERT INTO t1 VALUES(null);
501 INSERT INTO t1 VALUES(null);
506 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
507 SHOW CREATE TABLE t1;
509 t1 CREATE TABLE `t1` (
510 `c1` tinyint(4) AUTO_INCREMENT,
511 UNIQUE KEY `c1` (`c1`)
512 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
513 INSERT INTO t1 VALUES(null);
514 INSERT INTO t1 VALUES(null);
515 INSERT INTO t1 VALUES(null);
522 INSERT INTO t1 VALUES(null);
526 ALTER TABLE t1 AUTO_INCREMENT=10;
527 SHOW CREATE TABLE t1;
529 t1 CREATE TABLE `t1` (
530 `c1` tinyint(4) AUTO_INCREMENT,
531 UNIQUE KEY `c1` (`c1`)
532 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
533 INSERT INTO t1 VALUES(null);
534 INSERT INTO t1 VALUES(null);
535 INSERT INTO t1 VALUES(null);
543 INSERT INTO t1 VALUES(null);
548 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
549 SHOW CREATE TABLE t1;
551 t1 CREATE TABLE `t1` (
552 `c1` smallint(6) AUTO_INCREMENT,
553 UNIQUE KEY `c1` (`c1`)
554 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
555 INSERT INTO t1 VALUES(null);
556 INSERT INTO t1 VALUES(null);
557 INSERT INTO t1 VALUES(null);
564 INSERT INTO t1 VALUES(null);
568 ALTER TABLE t1 AUTO_INCREMENT=10;
569 SHOW CREATE TABLE t1;
571 t1 CREATE TABLE `t1` (
572 `c1` smallint(6) AUTO_INCREMENT,
573 UNIQUE KEY `c1` (`c1`)
574 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
575 INSERT INTO t1 VALUES(null);
576 INSERT INTO t1 VALUES(null);
577 INSERT INTO t1 VALUES(null);
585 INSERT INTO t1 VALUES(null);
590 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
591 SHOW CREATE TABLE t1;
593 t1 CREATE TABLE `t1` (
594 `c1` mediumint(9) AUTO_INCREMENT,
595 UNIQUE KEY `c1` (`c1`)
596 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
597 INSERT INTO t1 VALUES(null);
598 INSERT INTO t1 VALUES(null);
599 INSERT INTO t1 VALUES(null);
606 INSERT INTO t1 VALUES(null);
610 ALTER TABLE t1 AUTO_INCREMENT=10;
611 SHOW CREATE TABLE t1;
613 t1 CREATE TABLE `t1` (
614 `c1` mediumint(9) AUTO_INCREMENT,
615 UNIQUE KEY `c1` (`c1`)
616 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
617 INSERT INTO t1 VALUES(null);
618 INSERT INTO t1 VALUES(null);
619 INSERT INTO t1 VALUES(null);
627 INSERT INTO t1 VALUES(null);
632 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
633 SHOW CREATE TABLE t1;
635 t1 CREATE TABLE `t1` (
636 `c1` int(11) AUTO_INCREMENT,
637 UNIQUE KEY `c1` (`c1`)
638 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
639 INSERT INTO t1 VALUES(null);
640 INSERT INTO t1 VALUES(null);
641 INSERT INTO t1 VALUES(null);
648 INSERT INTO t1 VALUES(null);
652 ALTER TABLE t1 AUTO_INCREMENT=10;
653 SHOW CREATE TABLE t1;
655 t1 CREATE TABLE `t1` (
656 `c1` int(11) AUTO_INCREMENT,
657 UNIQUE KEY `c1` (`c1`)
658 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
659 INSERT INTO t1 VALUES(null);
660 INSERT INTO t1 VALUES(null);
661 INSERT INTO t1 VALUES(null);
669 INSERT INTO t1 VALUES(null);
674 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
675 SHOW CREATE TABLE t1;
677 t1 CREATE TABLE `t1` (
678 `c1` int(11) AUTO_INCREMENT,
679 UNIQUE KEY `c1` (`c1`)
680 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
681 INSERT INTO t1 VALUES(null);
682 INSERT INTO t1 VALUES(null);
683 INSERT INTO t1 VALUES(null);
690 INSERT INTO t1 VALUES(null);
694 ALTER TABLE t1 AUTO_INCREMENT=10;
695 SHOW CREATE TABLE t1;
697 t1 CREATE TABLE `t1` (
698 `c1` int(11) AUTO_INCREMENT,
699 UNIQUE KEY `c1` (`c1`)
700 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
701 INSERT INTO t1 VALUES(null);
702 INSERT INTO t1 VALUES(null);
703 INSERT INTO t1 VALUES(null);
711 INSERT INTO t1 VALUES(null);
716 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
717 SHOW CREATE TABLE t1;
719 t1 CREATE TABLE `t1` (
720 `c1` bigint(20) AUTO_INCREMENT,
721 UNIQUE KEY `c1` (`c1`)
722 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
723 INSERT INTO t1 VALUES(null);
724 INSERT INTO t1 VALUES(null);
725 INSERT INTO t1 VALUES(null);
732 INSERT INTO t1 VALUES(null);
736 ALTER TABLE t1 AUTO_INCREMENT=10;
737 SHOW CREATE TABLE t1;
739 t1 CREATE TABLE `t1` (
740 `c1` bigint(20) AUTO_INCREMENT,
741 UNIQUE KEY `c1` (`c1`)
742 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
743 INSERT INTO t1 VALUES(null);
744 INSERT INTO t1 VALUES(null);
745 INSERT INTO t1 VALUES(null);
753 INSERT INTO t1 VALUES(null);
758 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
759 SHOW CREATE TABLE t1;
761 t1 CREATE TABLE `t1` (
762 `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
763 UNIQUE KEY `c1` (`c1`)
764 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
765 INSERT INTO t1 VALUES(null);
766 INSERT INTO t1 VALUES(null);
767 INSERT INTO t1 VALUES(null);
774 INSERT INTO t1 VALUES(null);
778 ALTER TABLE t1 AUTO_INCREMENT=10;
779 SHOW CREATE TABLE t1;
781 t1 CREATE TABLE `t1` (
782 `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
783 UNIQUE KEY `c1` (`c1`)
784 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
785 INSERT INTO t1 VALUES(null);
786 INSERT INTO t1 VALUES(null);
787 INSERT INTO t1 VALUES(null);
795 INSERT INTO t1 VALUES(null);
800 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
801 SHOW CREATE TABLE t1;
803 t1 CREATE TABLE `t1` (
804 `c1` smallint(6) NOT NULL AUTO_INCREMENT,
805 UNIQUE KEY `c1` (`c1`)
806 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
807 INSERT INTO t1 VALUES(null);
808 INSERT INTO t1 VALUES(null);
809 INSERT INTO t1 VALUES(null);
816 INSERT INTO t1 VALUES(null);
820 ALTER TABLE t1 AUTO_INCREMENT=10;
821 SHOW CREATE TABLE t1;
823 t1 CREATE TABLE `t1` (
824 `c1` smallint(6) NOT NULL AUTO_INCREMENT,
825 UNIQUE KEY `c1` (`c1`)
826 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
827 INSERT INTO t1 VALUES(null);
828 INSERT INTO t1 VALUES(null);
829 INSERT INTO t1 VALUES(null);
837 INSERT INTO t1 VALUES(null);
842 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
843 SHOW CREATE TABLE t1;
845 t1 CREATE TABLE `t1` (
846 `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
847 UNIQUE KEY `c1` (`c1`)
848 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
849 INSERT INTO t1 VALUES(null);
850 INSERT INTO t1 VALUES(null);
851 INSERT INTO t1 VALUES(null);
858 INSERT INTO t1 VALUES(null);
862 ALTER TABLE t1 AUTO_INCREMENT=10;
863 SHOW CREATE TABLE t1;
865 t1 CREATE TABLE `t1` (
866 `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
867 UNIQUE KEY `c1` (`c1`)
868 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
869 INSERT INTO t1 VALUES(null);
870 INSERT INTO t1 VALUES(null);
871 INSERT INTO t1 VALUES(null);
879 INSERT INTO t1 VALUES(null);
884 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
885 SHOW CREATE TABLE t1;
887 t1 CREATE TABLE `t1` (
888 `c1` int(11) NOT NULL AUTO_INCREMENT,
889 UNIQUE KEY `c1` (`c1`)
890 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
891 INSERT INTO t1 VALUES(null);
892 INSERT INTO t1 VALUES(null);
893 INSERT INTO t1 VALUES(null);
900 INSERT INTO t1 VALUES(null);
904 ALTER TABLE t1 AUTO_INCREMENT=10;
905 SHOW CREATE TABLE t1;
907 t1 CREATE TABLE `t1` (
908 `c1` int(11) NOT NULL AUTO_INCREMENT,
909 UNIQUE KEY `c1` (`c1`)
910 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
911 INSERT INTO t1 VALUES(null);
912 INSERT INTO t1 VALUES(null);
913 INSERT INTO t1 VALUES(null);
921 INSERT INTO t1 VALUES(null);
926 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
927 SHOW CREATE TABLE t1;
929 t1 CREATE TABLE `t1` (
930 `c1` int(11) NOT NULL AUTO_INCREMENT,
931 UNIQUE KEY `c1` (`c1`)
932 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
933 INSERT INTO t1 VALUES(null);
934 INSERT INTO t1 VALUES(null);
935 INSERT INTO t1 VALUES(null);
942 INSERT INTO t1 VALUES(null);
946 ALTER TABLE t1 AUTO_INCREMENT=10;
947 SHOW CREATE TABLE t1;
949 t1 CREATE TABLE `t1` (
950 `c1` int(11) NOT NULL AUTO_INCREMENT,
951 UNIQUE KEY `c1` (`c1`)
952 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
953 INSERT INTO t1 VALUES(null);
954 INSERT INTO t1 VALUES(null);
955 INSERT INTO t1 VALUES(null);
963 INSERT INTO t1 VALUES(null);
968 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
969 SHOW CREATE TABLE t1;
971 t1 CREATE TABLE `t1` (
972 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
973 UNIQUE KEY `c1` (`c1`)
974 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
975 INSERT INTO t1 VALUES(null);
976 INSERT INTO t1 VALUES(null);
977 INSERT INTO t1 VALUES(null);
984 INSERT INTO t1 VALUES(null);
988 ALTER TABLE t1 AUTO_INCREMENT=10;
989 SHOW CREATE TABLE t1;
991 t1 CREATE TABLE `t1` (
992 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
993 UNIQUE KEY `c1` (`c1`)
994 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
995 INSERT INTO t1 VALUES(null);
996 INSERT INTO t1 VALUES(null);
997 INSERT INTO t1 VALUES(null);
1005 INSERT INTO t1 VALUES(null);
1010 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1011 SHOW CREATE TABLE t1;
1013 t1 CREATE TABLE `t1` (
1014 `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
1016 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1017 INSERT INTO t1 VALUES(null);
1018 INSERT INTO t1 VALUES(null);
1019 INSERT INTO t1 VALUES(null);
1026 INSERT INTO t1 VALUES(null);
1030 ALTER TABLE t1 AUTO_INCREMENT=10;
1031 SHOW CREATE TABLE t1;
1033 t1 CREATE TABLE `t1` (
1034 `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
1036 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1037 INSERT INTO t1 VALUES(null);
1038 INSERT INTO t1 VALUES(null);
1039 INSERT INTO t1 VALUES(null);
1047 INSERT INTO t1 VALUES(null);
1052 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1053 SHOW CREATE TABLE t1;
1055 t1 CREATE TABLE `t1` (
1056 `c1` smallint(6) NOT NULL AUTO_INCREMENT,
1058 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1059 INSERT INTO t1 VALUES(null);
1060 INSERT INTO t1 VALUES(null);
1061 INSERT INTO t1 VALUES(null);
1068 INSERT INTO t1 VALUES(null);
1072 ALTER TABLE t1 AUTO_INCREMENT=10;
1073 SHOW CREATE TABLE t1;
1075 t1 CREATE TABLE `t1` (
1076 `c1` smallint(6) NOT NULL AUTO_INCREMENT,
1078 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1079 INSERT INTO t1 VALUES(null);
1080 INSERT INTO t1 VALUES(null);
1081 INSERT INTO t1 VALUES(null);
1089 INSERT INTO t1 VALUES(null);
1094 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1095 SHOW CREATE TABLE t1;
1097 t1 CREATE TABLE `t1` (
1098 `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
1100 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1101 INSERT INTO t1 VALUES(null);
1102 INSERT INTO t1 VALUES(null);
1103 INSERT INTO t1 VALUES(null);
1110 INSERT INTO t1 VALUES(null);
1114 ALTER TABLE t1 AUTO_INCREMENT=10;
1115 SHOW CREATE TABLE t1;
1117 t1 CREATE TABLE `t1` (
1118 `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
1120 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1121 INSERT INTO t1 VALUES(null);
1122 INSERT INTO t1 VALUES(null);
1123 INSERT INTO t1 VALUES(null);
1131 INSERT INTO t1 VALUES(null);
1136 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1137 SHOW CREATE TABLE t1;
1139 t1 CREATE TABLE `t1` (
1140 `c1` int(11) NOT NULL AUTO_INCREMENT,
1142 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1143 INSERT INTO t1 VALUES(null);
1144 INSERT INTO t1 VALUES(null);
1145 INSERT INTO t1 VALUES(null);
1152 INSERT INTO t1 VALUES(null);
1156 ALTER TABLE t1 AUTO_INCREMENT=10;
1157 SHOW CREATE TABLE t1;
1159 t1 CREATE TABLE `t1` (
1160 `c1` int(11) NOT NULL AUTO_INCREMENT,
1162 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1163 INSERT INTO t1 VALUES(null);
1164 INSERT INTO t1 VALUES(null);
1165 INSERT INTO t1 VALUES(null);
1173 INSERT INTO t1 VALUES(null);
1178 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1179 SHOW CREATE TABLE t1;
1181 t1 CREATE TABLE `t1` (
1182 `c1` int(11) NOT NULL AUTO_INCREMENT,
1184 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1185 INSERT INTO t1 VALUES(null);
1186 INSERT INTO t1 VALUES(null);
1187 INSERT INTO t1 VALUES(null);
1194 INSERT INTO t1 VALUES(null);
1198 ALTER TABLE t1 AUTO_INCREMENT=10;
1199 SHOW CREATE TABLE t1;
1201 t1 CREATE TABLE `t1` (
1202 `c1` int(11) NOT NULL AUTO_INCREMENT,
1204 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1205 INSERT INTO t1 VALUES(null);
1206 INSERT INTO t1 VALUES(null);
1207 INSERT INTO t1 VALUES(null);
1215 INSERT INTO t1 VALUES(null);
1220 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1221 SHOW CREATE TABLE t1;
1223 t1 CREATE TABLE `t1` (
1224 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
1226 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1227 INSERT INTO t1 VALUES(null);
1228 INSERT INTO t1 VALUES(null);
1229 INSERT INTO t1 VALUES(null);
1236 INSERT INTO t1 VALUES(null);
1240 ALTER TABLE t1 AUTO_INCREMENT=10;
1241 SHOW CREATE TABLE t1;
1243 t1 CREATE TABLE `t1` (
1244 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
1246 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1247 INSERT INTO t1 VALUES(null);
1248 INSERT INTO t1 VALUES(null);
1249 INSERT INTO t1 VALUES(null);
1257 INSERT INTO t1 VALUES(null);
1262 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
1263 SHOW CREATE TABLE t1;
1265 t1 CREATE TABLE `t1` (
1266 `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
1268 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1269 INSERT INTO t1 VALUES(null);
1270 INSERT INTO t1 VALUES(null);
1271 INSERT INTO t1 VALUES(null);
1278 INSERT INTO t1 VALUES(null);
1282 ALTER TABLE t1 AUTO_INCREMENT=10;
1283 SHOW CREATE TABLE t1;
1285 t1 CREATE TABLE `t1` (
1286 `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
1288 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1289 INSERT INTO t1 VALUES(null);
1290 INSERT INTO t1 VALUES(null);
1291 INSERT INTO t1 VALUES(null);
1299 INSERT INTO t1 VALUES(null);
1304 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
1305 SHOW CREATE TABLE t1;
1307 t1 CREATE TABLE `t1` (
1308 `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
1310 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1311 INSERT INTO t1 VALUES(null);
1312 INSERT INTO t1 VALUES(null);
1313 INSERT INTO t1 VALUES(null);
1320 INSERT INTO t1 VALUES(null);
1324 ALTER TABLE t1 AUTO_INCREMENT=10;
1325 SHOW CREATE TABLE t1;
1327 t1 CREATE TABLE `t1` (
1328 `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
1330 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1331 INSERT INTO t1 VALUES(null);
1332 INSERT INTO t1 VALUES(null);
1333 INSERT INTO t1 VALUES(null);
1341 INSERT INTO t1 VALUES(null);
1346 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
1347 SHOW CREATE TABLE t1;
1349 t1 CREATE TABLE `t1` (
1350 `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
1352 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1353 INSERT INTO t1 VALUES(null);
1354 INSERT INTO t1 VALUES(null);
1355 INSERT INTO t1 VALUES(null);
1362 INSERT INTO t1 VALUES(null);
1366 ALTER TABLE t1 AUTO_INCREMENT=10;
1367 SHOW CREATE TABLE t1;
1369 t1 CREATE TABLE `t1` (
1370 `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
1372 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1373 INSERT INTO t1 VALUES(null);
1374 INSERT INTO t1 VALUES(null);
1375 INSERT INTO t1 VALUES(null);
1383 INSERT INTO t1 VALUES(null);
1388 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
1389 SHOW CREATE TABLE t1;
1391 t1 CREATE TABLE `t1` (
1392 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1394 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1395 INSERT INTO t1 VALUES(null);
1396 INSERT INTO t1 VALUES(null);
1397 INSERT INTO t1 VALUES(null);
1404 INSERT INTO t1 VALUES(null);
1408 ALTER TABLE t1 AUTO_INCREMENT=10;
1409 SHOW CREATE TABLE t1;
1411 t1 CREATE TABLE `t1` (
1412 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1414 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1415 INSERT INTO t1 VALUES(null);
1416 INSERT INTO t1 VALUES(null);
1417 INSERT INTO t1 VALUES(null);
1425 INSERT INTO t1 VALUES(null);
1430 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
1431 SHOW CREATE TABLE t1;
1433 t1 CREATE TABLE `t1` (
1434 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1436 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1437 INSERT INTO t1 VALUES(null);
1438 INSERT INTO t1 VALUES(null);
1439 INSERT INTO t1 VALUES(null);
1446 INSERT INTO t1 VALUES(null);
1450 ALTER TABLE t1 AUTO_INCREMENT=10;
1451 SHOW CREATE TABLE t1;
1453 t1 CREATE TABLE `t1` (
1454 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1456 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1457 INSERT INTO t1 VALUES(null);
1458 INSERT INTO t1 VALUES(null);
1459 INSERT INTO t1 VALUES(null);
1467 INSERT INTO t1 VALUES(null);
1472 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
1473 SHOW CREATE TABLE t1;
1475 t1 CREATE TABLE `t1` (
1476 `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1478 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1479 INSERT INTO t1 VALUES(null);
1480 INSERT INTO t1 VALUES(null);
1481 INSERT INTO t1 VALUES(null);
1488 INSERT INTO t1 VALUES(null);
1492 ALTER TABLE t1 AUTO_INCREMENT=10;
1493 SHOW CREATE TABLE t1;
1495 t1 CREATE TABLE `t1` (
1496 `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1498 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1499 INSERT INTO t1 VALUES(null);
1500 INSERT INTO t1 VALUES(null);
1501 INSERT INTO t1 VALUES(null);
1509 INSERT INTO t1 VALUES(null);
1514 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1515 SHOW CREATE TABLE t1;
1517 t1 CREATE TABLE `t1` (
1518 `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
1520 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1521 INSERT INTO t1 VALUES(null);
1522 INSERT INTO t1 VALUES(null);
1523 INSERT INTO t1 VALUES(null);
1530 INSERT INTO t1 VALUES(null);
1534 ALTER TABLE t1 AUTO_INCREMENT=10;
1535 SHOW CREATE TABLE t1;
1537 t1 CREATE TABLE `t1` (
1538 `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
1540 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1541 INSERT INTO t1 VALUES(null);
1542 INSERT INTO t1 VALUES(null);
1543 INSERT INTO t1 VALUES(null);
1551 INSERT INTO t1 VALUES(null);
1556 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1557 SHOW CREATE TABLE t1;
1559 t1 CREATE TABLE `t1` (
1560 `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
1562 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1563 INSERT INTO t1 VALUES(null);
1564 INSERT INTO t1 VALUES(null);
1565 INSERT INTO t1 VALUES(null);
1572 INSERT INTO t1 VALUES(null);
1576 ALTER TABLE t1 AUTO_INCREMENT=10;
1577 SHOW CREATE TABLE t1;
1579 t1 CREATE TABLE `t1` (
1580 `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
1582 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1583 INSERT INTO t1 VALUES(null);
1584 INSERT INTO t1 VALUES(null);
1585 INSERT INTO t1 VALUES(null);
1593 INSERT INTO t1 VALUES(null);
1598 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1599 SHOW CREATE TABLE t1;
1601 t1 CREATE TABLE `t1` (
1602 `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
1604 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1605 INSERT INTO t1 VALUES(null);
1606 INSERT INTO t1 VALUES(null);
1607 INSERT INTO t1 VALUES(null);
1614 INSERT INTO t1 VALUES(null);
1618 ALTER TABLE t1 AUTO_INCREMENT=10;
1619 SHOW CREATE TABLE t1;
1621 t1 CREATE TABLE `t1` (
1622 `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
1624 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1625 INSERT INTO t1 VALUES(null);
1626 INSERT INTO t1 VALUES(null);
1627 INSERT INTO t1 VALUES(null);
1635 INSERT INTO t1 VALUES(null);
1640 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1641 SHOW CREATE TABLE t1;
1643 t1 CREATE TABLE `t1` (
1644 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1646 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1647 INSERT INTO t1 VALUES(null);
1648 INSERT INTO t1 VALUES(null);
1649 INSERT INTO t1 VALUES(null);
1656 INSERT INTO t1 VALUES(null);
1660 ALTER TABLE t1 AUTO_INCREMENT=10;
1661 SHOW CREATE TABLE t1;
1663 t1 CREATE TABLE `t1` (
1664 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1666 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1667 INSERT INTO t1 VALUES(null);
1668 INSERT INTO t1 VALUES(null);
1669 INSERT INTO t1 VALUES(null);
1677 INSERT INTO t1 VALUES(null);
1682 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1683 SHOW CREATE TABLE t1;
1685 t1 CREATE TABLE `t1` (
1686 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1688 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1689 INSERT INTO t1 VALUES(null);
1690 INSERT INTO t1 VALUES(null);
1691 INSERT INTO t1 VALUES(null);
1698 INSERT INTO t1 VALUES(null);
1702 ALTER TABLE t1 AUTO_INCREMENT=10;
1703 SHOW CREATE TABLE t1;
1705 t1 CREATE TABLE `t1` (
1706 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1708 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1709 INSERT INTO t1 VALUES(null);
1710 INSERT INTO t1 VALUES(null);
1711 INSERT INTO t1 VALUES(null);
1719 INSERT INTO t1 VALUES(null);
1724 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1725 SHOW CREATE TABLE t1;
1727 t1 CREATE TABLE `t1` (
1728 `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1730 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1731 INSERT INTO t1 VALUES(null);
1732 INSERT INTO t1 VALUES(null);
1733 INSERT INTO t1 VALUES(null);
1740 INSERT INTO t1 VALUES(null);
1744 ALTER TABLE t1 AUTO_INCREMENT=10;
1745 SHOW CREATE TABLE t1;
1747 t1 CREATE TABLE `t1` (
1748 `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1750 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1751 INSERT INTO t1 VALUES(null);
1752 INSERT INTO t1 VALUES(null);
1753 INSERT INTO t1 VALUES(null);
1761 INSERT INTO t1 VALUES(null);
1766 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1767 SHOW CREATE TABLE t1;
1769 t1 CREATE TABLE `t1` (
1770 `c1` tinyint(3) unsigned AUTO_INCREMENT,
1771 UNIQUE KEY `c1` (`c1`)
1772 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1773 INSERT INTO t1 VALUES(null);
1774 INSERT INTO t1 VALUES(null);
1775 INSERT INTO t1 VALUES(null);
1782 INSERT INTO t1 VALUES(null);
1786 ALTER TABLE t1 AUTO_INCREMENT=10;
1787 SHOW CREATE TABLE t1;
1789 t1 CREATE TABLE `t1` (
1790 `c1` tinyint(3) unsigned AUTO_INCREMENT,
1791 UNIQUE KEY `c1` (`c1`)
1792 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1793 INSERT INTO t1 VALUES(null);
1794 INSERT INTO t1 VALUES(null);
1795 INSERT INTO t1 VALUES(null);
1803 INSERT INTO t1 VALUES(null);
1808 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1809 SHOW CREATE TABLE t1;
1811 t1 CREATE TABLE `t1` (
1812 `c1` smallint(5) unsigned AUTO_INCREMENT,
1813 UNIQUE KEY `c1` (`c1`)
1814 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1815 INSERT INTO t1 VALUES(null);
1816 INSERT INTO t1 VALUES(null);
1817 INSERT INTO t1 VALUES(null);
1824 INSERT INTO t1 VALUES(null);
1828 ALTER TABLE t1 AUTO_INCREMENT=10;
1829 SHOW CREATE TABLE t1;
1831 t1 CREATE TABLE `t1` (
1832 `c1` smallint(5) unsigned AUTO_INCREMENT,
1833 UNIQUE KEY `c1` (`c1`)
1834 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1835 INSERT INTO t1 VALUES(null);
1836 INSERT INTO t1 VALUES(null);
1837 INSERT INTO t1 VALUES(null);
1845 INSERT INTO t1 VALUES(null);
1850 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1851 SHOW CREATE TABLE t1;
1853 t1 CREATE TABLE `t1` (
1854 `c1` mediumint(8) unsigned AUTO_INCREMENT,
1855 UNIQUE KEY `c1` (`c1`)
1856 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1857 INSERT INTO t1 VALUES(null);
1858 INSERT INTO t1 VALUES(null);
1859 INSERT INTO t1 VALUES(null);
1866 INSERT INTO t1 VALUES(null);
1870 ALTER TABLE t1 AUTO_INCREMENT=10;
1871 SHOW CREATE TABLE t1;
1873 t1 CREATE TABLE `t1` (
1874 `c1` mediumint(8) unsigned AUTO_INCREMENT,
1875 UNIQUE KEY `c1` (`c1`)
1876 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1877 INSERT INTO t1 VALUES(null);
1878 INSERT INTO t1 VALUES(null);
1879 INSERT INTO t1 VALUES(null);
1887 INSERT INTO t1 VALUES(null);
1892 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1893 SHOW CREATE TABLE t1;
1895 t1 CREATE TABLE `t1` (
1896 `c1` int(10) unsigned AUTO_INCREMENT,
1897 UNIQUE KEY `c1` (`c1`)
1898 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1899 INSERT INTO t1 VALUES(null);
1900 INSERT INTO t1 VALUES(null);
1901 INSERT INTO t1 VALUES(null);
1908 INSERT INTO t1 VALUES(null);
1912 ALTER TABLE t1 AUTO_INCREMENT=10;
1913 SHOW CREATE TABLE t1;
1915 t1 CREATE TABLE `t1` (
1916 `c1` int(10) unsigned AUTO_INCREMENT,
1917 UNIQUE KEY `c1` (`c1`)
1918 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1919 INSERT INTO t1 VALUES(null);
1920 INSERT INTO t1 VALUES(null);
1921 INSERT INTO t1 VALUES(null);
1929 INSERT INTO t1 VALUES(null);
1934 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1935 SHOW CREATE TABLE t1;
1937 t1 CREATE TABLE `t1` (
1938 `c1` int(10) unsigned AUTO_INCREMENT,
1939 UNIQUE KEY `c1` (`c1`)
1940 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1941 INSERT INTO t1 VALUES(null);
1942 INSERT INTO t1 VALUES(null);
1943 INSERT INTO t1 VALUES(null);
1950 INSERT INTO t1 VALUES(null);
1954 ALTER TABLE t1 AUTO_INCREMENT=10;
1955 SHOW CREATE TABLE t1;
1957 t1 CREATE TABLE `t1` (
1958 `c1` int(10) unsigned AUTO_INCREMENT,
1959 UNIQUE KEY `c1` (`c1`)
1960 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1961 INSERT INTO t1 VALUES(null);
1962 INSERT INTO t1 VALUES(null);
1963 INSERT INTO t1 VALUES(null);
1971 INSERT INTO t1 VALUES(null);
1976 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1977 SHOW CREATE TABLE t1;
1979 t1 CREATE TABLE `t1` (
1980 `c1` bigint(20) unsigned AUTO_INCREMENT,
1981 UNIQUE KEY `c1` (`c1`)
1982 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1983 INSERT INTO t1 VALUES(null);
1984 INSERT INTO t1 VALUES(null);
1985 INSERT INTO t1 VALUES(null);
1992 INSERT INTO t1 VALUES(null);
1996 ALTER TABLE t1 AUTO_INCREMENT=10;
1997 SHOW CREATE TABLE t1;
1999 t1 CREATE TABLE `t1` (
2000 `c1` bigint(20) unsigned AUTO_INCREMENT,
2001 UNIQUE KEY `c1` (`c1`)
2002 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2003 INSERT INTO t1 VALUES(null);
2004 INSERT INTO t1 VALUES(null);
2005 INSERT INTO t1 VALUES(null);
2013 INSERT INTO t1 VALUES(null);
2018 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
2019 SHOW CREATE TABLE t1;
2021 t1 CREATE TABLE `t1` (
2022 `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
2023 UNIQUE KEY `c1` (`c1`)
2024 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2025 INSERT INTO t1 VALUES(null);
2026 INSERT INTO t1 VALUES(null);
2027 INSERT INTO t1 VALUES(null);
2034 INSERT INTO t1 VALUES(null);
2038 ALTER TABLE t1 AUTO_INCREMENT=10;
2039 SHOW CREATE TABLE t1;
2041 t1 CREATE TABLE `t1` (
2042 `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
2043 UNIQUE KEY `c1` (`c1`)
2044 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2045 INSERT INTO t1 VALUES(null);
2046 INSERT INTO t1 VALUES(null);
2047 INSERT INTO t1 VALUES(null);
2055 INSERT INTO t1 VALUES(null);
2060 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
2061 SHOW CREATE TABLE t1;
2063 t1 CREATE TABLE `t1` (
2064 `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
2065 UNIQUE KEY `c1` (`c1`)
2066 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2067 INSERT INTO t1 VALUES(null);
2068 INSERT INTO t1 VALUES(null);
2069 INSERT INTO t1 VALUES(null);
2076 INSERT INTO t1 VALUES(null);
2080 ALTER TABLE t1 AUTO_INCREMENT=10;
2081 SHOW CREATE TABLE t1;
2083 t1 CREATE TABLE `t1` (
2084 `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
2085 UNIQUE KEY `c1` (`c1`)
2086 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2087 INSERT INTO t1 VALUES(null);
2088 INSERT INTO t1 VALUES(null);
2089 INSERT INTO t1 VALUES(null);
2097 INSERT INTO t1 VALUES(null);
2102 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
2103 SHOW CREATE TABLE t1;
2105 t1 CREATE TABLE `t1` (
2106 `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
2107 UNIQUE KEY `c1` (`c1`)
2108 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2109 INSERT INTO t1 VALUES(null);
2110 INSERT INTO t1 VALUES(null);
2111 INSERT INTO t1 VALUES(null);
2118 INSERT INTO t1 VALUES(null);
2122 ALTER TABLE t1 AUTO_INCREMENT=10;
2123 SHOW CREATE TABLE t1;
2125 t1 CREATE TABLE `t1` (
2126 `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
2127 UNIQUE KEY `c1` (`c1`)
2128 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2129 INSERT INTO t1 VALUES(null);
2130 INSERT INTO t1 VALUES(null);
2131 INSERT INTO t1 VALUES(null);
2139 INSERT INTO t1 VALUES(null);
2144 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
2145 SHOW CREATE TABLE t1;
2147 t1 CREATE TABLE `t1` (
2148 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
2149 UNIQUE KEY `c1` (`c1`)
2150 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2151 INSERT INTO t1 VALUES(null);
2152 INSERT INTO t1 VALUES(null);
2153 INSERT INTO t1 VALUES(null);
2160 INSERT INTO t1 VALUES(null);
2164 ALTER TABLE t1 AUTO_INCREMENT=10;
2165 SHOW CREATE TABLE t1;
2167 t1 CREATE TABLE `t1` (
2168 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
2169 UNIQUE KEY `c1` (`c1`)
2170 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2171 INSERT INTO t1 VALUES(null);
2172 INSERT INTO t1 VALUES(null);
2173 INSERT INTO t1 VALUES(null);
2181 INSERT INTO t1 VALUES(null);
2186 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
2187 SHOW CREATE TABLE t1;
2189 t1 CREATE TABLE `t1` (
2190 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
2191 UNIQUE KEY `c1` (`c1`)
2192 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2193 INSERT INTO t1 VALUES(null);
2194 INSERT INTO t1 VALUES(null);
2195 INSERT INTO t1 VALUES(null);
2202 INSERT INTO t1 VALUES(null);
2206 ALTER TABLE t1 AUTO_INCREMENT=10;
2207 SHOW CREATE TABLE t1;
2209 t1 CREATE TABLE `t1` (
2210 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
2211 UNIQUE KEY `c1` (`c1`)
2212 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2213 INSERT INTO t1 VALUES(null);
2214 INSERT INTO t1 VALUES(null);
2215 INSERT INTO t1 VALUES(null);
2223 INSERT INTO t1 VALUES(null);
2228 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
2229 SHOW CREATE TABLE t1;
2231 t1 CREATE TABLE `t1` (
2232 `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2233 UNIQUE KEY `c1` (`c1`)
2234 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2235 INSERT INTO t1 VALUES(null);
2236 INSERT INTO t1 VALUES(null);
2237 INSERT INTO t1 VALUES(null);
2244 INSERT INTO t1 VALUES(null);
2248 ALTER TABLE t1 AUTO_INCREMENT=10;
2249 SHOW CREATE TABLE t1;
2251 t1 CREATE TABLE `t1` (
2252 `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2253 UNIQUE KEY `c1` (`c1`)
2254 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2255 INSERT INTO t1 VALUES(null);
2256 INSERT INTO t1 VALUES(null);
2257 INSERT INTO t1 VALUES(null);
2265 INSERT INTO t1 VALUES(null);
2270 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
2271 SHOW CREATE TABLE t1;
2273 t1 CREATE TABLE `t1` (
2274 `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
2276 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2277 INSERT INTO t1 VALUES(null);
2278 INSERT INTO t1 VALUES(null);
2279 INSERT INTO t1 VALUES(null);
2286 INSERT INTO t1 VALUES(null);
2290 ALTER TABLE t1 AUTO_INCREMENT=10;
2291 SHOW CREATE TABLE t1;
2293 t1 CREATE TABLE `t1` (
2294 `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
2296 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2297 INSERT INTO t1 VALUES(null);
2298 INSERT INTO t1 VALUES(null);
2299 INSERT INTO t1 VALUES(null);
2307 INSERT INTO t1 VALUES(null);
2312 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
2313 SHOW CREATE TABLE t1;
2315 t1 CREATE TABLE `t1` (
2316 `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
2318 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2319 INSERT INTO t1 VALUES(null);
2320 INSERT INTO t1 VALUES(null);
2321 INSERT INTO t1 VALUES(null);
2328 INSERT INTO t1 VALUES(null);
2332 ALTER TABLE t1 AUTO_INCREMENT=10;
2333 SHOW CREATE TABLE t1;
2335 t1 CREATE TABLE `t1` (
2336 `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
2338 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2339 INSERT INTO t1 VALUES(null);
2340 INSERT INTO t1 VALUES(null);
2341 INSERT INTO t1 VALUES(null);
2349 INSERT INTO t1 VALUES(null);
2354 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
2355 SHOW CREATE TABLE t1;
2357 t1 CREATE TABLE `t1` (
2358 `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
2360 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2361 INSERT INTO t1 VALUES(null);
2362 INSERT INTO t1 VALUES(null);
2363 INSERT INTO t1 VALUES(null);
2370 INSERT INTO t1 VALUES(null);
2374 ALTER TABLE t1 AUTO_INCREMENT=10;
2375 SHOW CREATE TABLE t1;
2377 t1 CREATE TABLE `t1` (
2378 `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
2380 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2381 INSERT INTO t1 VALUES(null);
2382 INSERT INTO t1 VALUES(null);
2383 INSERT INTO t1 VALUES(null);
2391 INSERT INTO t1 VALUES(null);
2396 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
2397 SHOW CREATE TABLE t1;
2399 t1 CREATE TABLE `t1` (
2400 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
2402 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2403 INSERT INTO t1 VALUES(null);
2404 INSERT INTO t1 VALUES(null);
2405 INSERT INTO t1 VALUES(null);
2412 INSERT INTO t1 VALUES(null);
2416 ALTER TABLE t1 AUTO_INCREMENT=10;
2417 SHOW CREATE TABLE t1;
2419 t1 CREATE TABLE `t1` (
2420 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
2422 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2423 INSERT INTO t1 VALUES(null);
2424 INSERT INTO t1 VALUES(null);
2425 INSERT INTO t1 VALUES(null);
2433 INSERT INTO t1 VALUES(null);
2438 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
2439 SHOW CREATE TABLE t1;
2441 t1 CREATE TABLE `t1` (
2442 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
2444 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2445 INSERT INTO t1 VALUES(null);
2446 INSERT INTO t1 VALUES(null);
2447 INSERT INTO t1 VALUES(null);
2454 INSERT INTO t1 VALUES(null);
2458 ALTER TABLE t1 AUTO_INCREMENT=10;
2459 SHOW CREATE TABLE t1;
2461 t1 CREATE TABLE `t1` (
2462 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
2464 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2465 INSERT INTO t1 VALUES(null);
2466 INSERT INTO t1 VALUES(null);
2467 INSERT INTO t1 VALUES(null);
2475 INSERT INTO t1 VALUES(null);
2480 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
2481 SHOW CREATE TABLE t1;
2483 t1 CREATE TABLE `t1` (
2484 `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2486 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2487 INSERT INTO t1 VALUES(null);
2488 INSERT INTO t1 VALUES(null);
2489 INSERT INTO t1 VALUES(null);
2496 INSERT INTO t1 VALUES(null);
2500 ALTER TABLE t1 AUTO_INCREMENT=10;
2501 SHOW CREATE TABLE t1;
2503 t1 CREATE TABLE `t1` (
2504 `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2506 ) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
2507 INSERT INTO t1 VALUES(null);
2508 INSERT INTO t1 VALUES(null);
2509 INSERT INTO t1 VALUES(null);
2517 INSERT INTO t1 VALUES(null);