1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL KEY );
6 `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
8 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
10 INSERT INTO t1 VALUES(null);
11 INSERT INTO t1 VALUES(null);
12 INSERT INTO t1 VALUES(null);
21 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL KEY );
24 t1 CREATE TABLE `t1` (
25 `c1` smallint(6) NOT NULL AUTO_INCREMENT,
27 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
29 INSERT INTO t1 VALUES(null);
30 INSERT INTO t1 VALUES(null);
31 INSERT INTO t1 VALUES(null);
40 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL KEY );
43 t1 CREATE TABLE `t1` (
44 `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
46 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
48 INSERT INTO t1 VALUES(null);
49 INSERT INTO t1 VALUES(null);
50 INSERT INTO t1 VALUES(null);
59 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL KEY );
62 t1 CREATE TABLE `t1` (
63 `c1` int(11) NOT NULL AUTO_INCREMENT,
65 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
67 INSERT INTO t1 VALUES(null);
68 INSERT INTO t1 VALUES(null);
69 INSERT INTO t1 VALUES(null);
78 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL KEY );
81 t1 CREATE TABLE `t1` (
82 `c1` int(11) NOT NULL AUTO_INCREMENT,
84 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
86 INSERT INTO t1 VALUES(null);
87 INSERT INTO t1 VALUES(null);
88 INSERT INTO t1 VALUES(null);
97 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL KEY );
100 t1 CREATE TABLE `t1` (
101 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
103 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
105 INSERT INTO t1 VALUES(null);
106 INSERT INTO t1 VALUES(null);
107 INSERT INTO t1 VALUES(null);
116 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY );
117 SHOW CREATE TABLE t1;
119 t1 CREATE TABLE `t1` (
120 `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
122 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
124 INSERT INTO t1 VALUES(null);
125 INSERT INTO t1 VALUES(null);
126 INSERT INTO t1 VALUES(null);
135 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY );
136 SHOW CREATE TABLE t1;
138 t1 CREATE TABLE `t1` (
139 `c1` smallint(6) NOT NULL AUTO_INCREMENT,
141 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
143 INSERT INTO t1 VALUES(null);
144 INSERT INTO t1 VALUES(null);
145 INSERT INTO t1 VALUES(null);
154 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY );
155 SHOW CREATE TABLE t1;
157 t1 CREATE TABLE `t1` (
158 `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
160 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
162 INSERT INTO t1 VALUES(null);
163 INSERT INTO t1 VALUES(null);
164 INSERT INTO t1 VALUES(null);
173 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY );
174 SHOW CREATE TABLE t1;
176 t1 CREATE TABLE `t1` (
177 `c1` int(11) NOT NULL AUTO_INCREMENT,
179 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
181 INSERT INTO t1 VALUES(null);
182 INSERT INTO t1 VALUES(null);
183 INSERT INTO t1 VALUES(null);
192 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY );
193 SHOW CREATE TABLE t1;
195 t1 CREATE TABLE `t1` (
196 `c1` int(11) NOT NULL AUTO_INCREMENT,
198 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
200 INSERT INTO t1 VALUES(null);
201 INSERT INTO t1 VALUES(null);
202 INSERT INTO t1 VALUES(null);
211 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY );
212 SHOW CREATE TABLE t1;
214 t1 CREATE TABLE `t1` (
215 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
217 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
219 INSERT INTO t1 VALUES(null);
220 INSERT INTO t1 VALUES(null);
221 INSERT INTO t1 VALUES(null);
230 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY );
231 SHOW CREATE TABLE t1;
233 t1 CREATE TABLE `t1` (
234 `c1` tinyint(4) AUTO_INCREMENT,
235 UNIQUE KEY `c1` (`c1`)
236 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
238 INSERT INTO t1 VALUES(null);
239 INSERT INTO t1 VALUES(null);
240 INSERT INTO t1 VALUES(null);
249 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY );
250 SHOW CREATE TABLE t1;
252 t1 CREATE TABLE `t1` (
253 `c1` smallint(6) AUTO_INCREMENT,
254 UNIQUE KEY `c1` (`c1`)
255 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
257 INSERT INTO t1 VALUES(null);
258 INSERT INTO t1 VALUES(null);
259 INSERT INTO t1 VALUES(null);
268 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY );
269 SHOW CREATE TABLE t1;
271 t1 CREATE TABLE `t1` (
272 `c1` mediumint(9) AUTO_INCREMENT,
273 UNIQUE KEY `c1` (`c1`)
274 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
276 INSERT INTO t1 VALUES(null);
277 INSERT INTO t1 VALUES(null);
278 INSERT INTO t1 VALUES(null);
287 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY );
288 SHOW CREATE TABLE t1;
290 t1 CREATE TABLE `t1` (
291 `c1` int(11) AUTO_INCREMENT,
292 UNIQUE KEY `c1` (`c1`)
293 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
295 INSERT INTO t1 VALUES(null);
296 INSERT INTO t1 VALUES(null);
297 INSERT INTO t1 VALUES(null);
306 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY );
307 SHOW CREATE TABLE t1;
309 t1 CREATE TABLE `t1` (
310 `c1` int(11) AUTO_INCREMENT,
311 UNIQUE KEY `c1` (`c1`)
312 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
314 INSERT INTO t1 VALUES(null);
315 INSERT INTO t1 VALUES(null);
316 INSERT INTO t1 VALUES(null);
325 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY );
326 SHOW CREATE TABLE t1;
328 t1 CREATE TABLE `t1` (
329 `c1` bigint(20) AUTO_INCREMENT,
330 UNIQUE KEY `c1` (`c1`)
331 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
333 INSERT INTO t1 VALUES(null);
334 INSERT INTO t1 VALUES(null);
335 INSERT INTO t1 VALUES(null);
344 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
345 SHOW CREATE TABLE t1;
347 t1 CREATE TABLE `t1` (
348 `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
349 UNIQUE KEY `c1` (`c1`)
350 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
352 INSERT INTO t1 VALUES(null);
353 INSERT INTO t1 VALUES(null);
354 INSERT INTO t1 VALUES(null);
363 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
364 SHOW CREATE TABLE t1;
366 t1 CREATE TABLE `t1` (
367 `c1` smallint(6) NOT NULL AUTO_INCREMENT,
368 UNIQUE KEY `c1` (`c1`)
369 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
371 INSERT INTO t1 VALUES(null);
372 INSERT INTO t1 VALUES(null);
373 INSERT INTO t1 VALUES(null);
382 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
383 SHOW CREATE TABLE t1;
385 t1 CREATE TABLE `t1` (
386 `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
387 UNIQUE KEY `c1` (`c1`)
388 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
390 INSERT INTO t1 VALUES(null);
391 INSERT INTO t1 VALUES(null);
392 INSERT INTO t1 VALUES(null);
401 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY );
402 SHOW CREATE TABLE t1;
404 t1 CREATE TABLE `t1` (
405 `c1` int(11) NOT NULL AUTO_INCREMENT,
406 UNIQUE KEY `c1` (`c1`)
407 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
409 INSERT INTO t1 VALUES(null);
410 INSERT INTO t1 VALUES(null);
411 INSERT INTO t1 VALUES(null);
420 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY );
421 SHOW CREATE TABLE t1;
423 t1 CREATE TABLE `t1` (
424 `c1` int(11) NOT NULL AUTO_INCREMENT,
425 UNIQUE KEY `c1` (`c1`)
426 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
428 INSERT INTO t1 VALUES(null);
429 INSERT INTO t1 VALUES(null);
430 INSERT INTO t1 VALUES(null);
439 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
440 SHOW CREATE TABLE t1;
442 t1 CREATE TABLE `t1` (
443 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
444 UNIQUE KEY `c1` (`c1`)
445 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
447 INSERT INTO t1 VALUES(null);
448 INSERT INTO t1 VALUES(null);
449 INSERT INTO t1 VALUES(null);
458 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
459 SHOW CREATE TABLE t1;
461 t1 CREATE TABLE `t1` (
462 `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
464 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
466 INSERT INTO t1 VALUES(null);
467 INSERT INTO t1 VALUES(null);
468 INSERT INTO t1 VALUES(null);
477 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
478 SHOW CREATE TABLE t1;
480 t1 CREATE TABLE `t1` (
481 `c1` smallint(6) NOT NULL AUTO_INCREMENT,
483 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
485 INSERT INTO t1 VALUES(null);
486 INSERT INTO t1 VALUES(null);
487 INSERT INTO t1 VALUES(null);
496 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
497 SHOW CREATE TABLE t1;
499 t1 CREATE TABLE `t1` (
500 `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
502 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
504 INSERT INTO t1 VALUES(null);
505 INSERT INTO t1 VALUES(null);
506 INSERT INTO t1 VALUES(null);
515 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY );
516 SHOW CREATE TABLE t1;
518 t1 CREATE TABLE `t1` (
519 `c1` int(11) NOT NULL AUTO_INCREMENT,
521 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
523 INSERT INTO t1 VALUES(null);
524 INSERT INTO t1 VALUES(null);
525 INSERT INTO t1 VALUES(null);
534 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY );
535 SHOW CREATE TABLE t1;
537 t1 CREATE TABLE `t1` (
538 `c1` int(11) NOT NULL AUTO_INCREMENT,
540 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
542 INSERT INTO t1 VALUES(null);
543 INSERT INTO t1 VALUES(null);
544 INSERT INTO t1 VALUES(null);
553 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
554 SHOW CREATE TABLE t1;
556 t1 CREATE TABLE `t1` (
557 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
559 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
561 INSERT INTO t1 VALUES(null);
562 INSERT INTO t1 VALUES(null);
563 INSERT INTO t1 VALUES(null);
572 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL KEY );
573 SHOW CREATE TABLE t1;
575 t1 CREATE TABLE `t1` (
576 `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
578 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
580 INSERT INTO t1 VALUES(null);
581 INSERT INTO t1 VALUES(null);
582 INSERT INTO t1 VALUES(null);
591 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL KEY );
592 SHOW CREATE TABLE t1;
594 t1 CREATE TABLE `t1` (
595 `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
597 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
599 INSERT INTO t1 VALUES(null);
600 INSERT INTO t1 VALUES(null);
601 INSERT INTO t1 VALUES(null);
610 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL KEY );
611 SHOW CREATE TABLE t1;
613 t1 CREATE TABLE `t1` (
614 `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
616 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
618 INSERT INTO t1 VALUES(null);
619 INSERT INTO t1 VALUES(null);
620 INSERT INTO t1 VALUES(null);
629 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL KEY );
630 SHOW CREATE TABLE t1;
632 t1 CREATE TABLE `t1` (
633 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
635 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
637 INSERT INTO t1 VALUES(null);
638 INSERT INTO t1 VALUES(null);
639 INSERT INTO t1 VALUES(null);
648 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL KEY );
649 SHOW CREATE TABLE t1;
651 t1 CREATE TABLE `t1` (
652 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
654 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
656 INSERT INTO t1 VALUES(null);
657 INSERT INTO t1 VALUES(null);
658 INSERT INTO t1 VALUES(null);
667 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL KEY );
668 SHOW CREATE TABLE t1;
670 t1 CREATE TABLE `t1` (
671 `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
673 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
675 INSERT INTO t1 VALUES(null);
676 INSERT INTO t1 VALUES(null);
677 INSERT INTO t1 VALUES(null);
686 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
687 SHOW CREATE TABLE t1;
689 t1 CREATE TABLE `t1` (
690 `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
692 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
694 INSERT INTO t1 VALUES(null);
695 INSERT INTO t1 VALUES(null);
696 INSERT INTO t1 VALUES(null);
705 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
706 SHOW CREATE TABLE t1;
708 t1 CREATE TABLE `t1` (
709 `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
711 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
713 INSERT INTO t1 VALUES(null);
714 INSERT INTO t1 VALUES(null);
715 INSERT INTO t1 VALUES(null);
724 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
725 SHOW CREATE TABLE t1;
727 t1 CREATE TABLE `t1` (
728 `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
730 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
732 INSERT INTO t1 VALUES(null);
733 INSERT INTO t1 VALUES(null);
734 INSERT INTO t1 VALUES(null);
743 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
744 SHOW CREATE TABLE t1;
746 t1 CREATE TABLE `t1` (
747 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
749 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
751 INSERT INTO t1 VALUES(null);
752 INSERT INTO t1 VALUES(null);
753 INSERT INTO t1 VALUES(null);
762 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
763 SHOW CREATE TABLE t1;
765 t1 CREATE TABLE `t1` (
766 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
768 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
770 INSERT INTO t1 VALUES(null);
771 INSERT INTO t1 VALUES(null);
772 INSERT INTO t1 VALUES(null);
781 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
782 SHOW CREATE TABLE t1;
784 t1 CREATE TABLE `t1` (
785 `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
787 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
789 INSERT INTO t1 VALUES(null);
790 INSERT INTO t1 VALUES(null);
791 INSERT INTO t1 VALUES(null);
800 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
801 SHOW CREATE TABLE t1;
803 t1 CREATE TABLE `t1` (
804 `c1` tinyint(3) unsigned AUTO_INCREMENT,
805 UNIQUE KEY `c1` (`c1`)
806 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
808 INSERT INTO t1 VALUES(null);
809 INSERT INTO t1 VALUES(null);
810 INSERT INTO t1 VALUES(null);
819 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
820 SHOW CREATE TABLE t1;
822 t1 CREATE TABLE `t1` (
823 `c1` smallint(5) unsigned AUTO_INCREMENT,
824 UNIQUE KEY `c1` (`c1`)
825 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
827 INSERT INTO t1 VALUES(null);
828 INSERT INTO t1 VALUES(null);
829 INSERT INTO t1 VALUES(null);
838 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
839 SHOW CREATE TABLE t1;
841 t1 CREATE TABLE `t1` (
842 `c1` mediumint(8) unsigned AUTO_INCREMENT,
843 UNIQUE KEY `c1` (`c1`)
844 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
846 INSERT INTO t1 VALUES(null);
847 INSERT INTO t1 VALUES(null);
848 INSERT INTO t1 VALUES(null);
857 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
858 SHOW CREATE TABLE t1;
860 t1 CREATE TABLE `t1` (
861 `c1` int(10) unsigned AUTO_INCREMENT,
862 UNIQUE KEY `c1` (`c1`)
863 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
865 INSERT INTO t1 VALUES(null);
866 INSERT INTO t1 VALUES(null);
867 INSERT INTO t1 VALUES(null);
876 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
877 SHOW CREATE TABLE t1;
879 t1 CREATE TABLE `t1` (
880 `c1` int(10) unsigned AUTO_INCREMENT,
881 UNIQUE KEY `c1` (`c1`)
882 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
884 INSERT INTO t1 VALUES(null);
885 INSERT INTO t1 VALUES(null);
886 INSERT INTO t1 VALUES(null);
895 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
896 SHOW CREATE TABLE t1;
898 t1 CREATE TABLE `t1` (
899 `c1` bigint(20) unsigned AUTO_INCREMENT,
900 UNIQUE KEY `c1` (`c1`)
901 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
903 INSERT INTO t1 VALUES(null);
904 INSERT INTO t1 VALUES(null);
905 INSERT INTO t1 VALUES(null);
914 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
915 SHOW CREATE TABLE t1;
917 t1 CREATE TABLE `t1` (
918 `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
919 UNIQUE KEY `c1` (`c1`)
920 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
922 INSERT INTO t1 VALUES(null);
923 INSERT INTO t1 VALUES(null);
924 INSERT INTO t1 VALUES(null);
933 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
934 SHOW CREATE TABLE t1;
936 t1 CREATE TABLE `t1` (
937 `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
938 UNIQUE KEY `c1` (`c1`)
939 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
941 INSERT INTO t1 VALUES(null);
942 INSERT INTO t1 VALUES(null);
943 INSERT INTO t1 VALUES(null);
952 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
953 SHOW CREATE TABLE t1;
955 t1 CREATE TABLE `t1` (
956 `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
957 UNIQUE KEY `c1` (`c1`)
958 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
960 INSERT INTO t1 VALUES(null);
961 INSERT INTO t1 VALUES(null);
962 INSERT INTO t1 VALUES(null);
971 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
972 SHOW CREATE TABLE t1;
974 t1 CREATE TABLE `t1` (
975 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
976 UNIQUE KEY `c1` (`c1`)
977 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
979 INSERT INTO t1 VALUES(null);
980 INSERT INTO t1 VALUES(null);
981 INSERT INTO t1 VALUES(null);
990 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
991 SHOW CREATE TABLE t1;
993 t1 CREATE TABLE `t1` (
994 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
995 UNIQUE KEY `c1` (`c1`)
996 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
998 INSERT INTO t1 VALUES(null);
999 INSERT INTO t1 VALUES(null);
1000 INSERT INTO t1 VALUES(null);
1009 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
1010 SHOW CREATE TABLE t1;
1012 t1 CREATE TABLE `t1` (
1013 `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1014 UNIQUE KEY `c1` (`c1`)
1015 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1017 INSERT INTO t1 VALUES(null);
1018 INSERT INTO t1 VALUES(null);
1019 INSERT INTO t1 VALUES(null);
1028 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1029 SHOW CREATE TABLE t1;
1031 t1 CREATE TABLE `t1` (
1032 `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
1034 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1036 INSERT INTO t1 VALUES(null);
1037 INSERT INTO t1 VALUES(null);
1038 INSERT INTO t1 VALUES(null);
1047 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1048 SHOW CREATE TABLE t1;
1050 t1 CREATE TABLE `t1` (
1051 `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
1053 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1055 INSERT INTO t1 VALUES(null);
1056 INSERT INTO t1 VALUES(null);
1057 INSERT INTO t1 VALUES(null);
1066 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1067 SHOW CREATE TABLE t1;
1069 t1 CREATE TABLE `t1` (
1070 `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
1072 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1074 INSERT INTO t1 VALUES(null);
1075 INSERT INTO t1 VALUES(null);
1076 INSERT INTO t1 VALUES(null);
1085 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1086 SHOW CREATE TABLE t1;
1088 t1 CREATE TABLE `t1` (
1089 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1091 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1093 INSERT INTO t1 VALUES(null);
1094 INSERT INTO t1 VALUES(null);
1095 INSERT INTO t1 VALUES(null);
1104 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1105 SHOW CREATE TABLE t1;
1107 t1 CREATE TABLE `t1` (
1108 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1110 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1112 INSERT INTO t1 VALUES(null);
1113 INSERT INTO t1 VALUES(null);
1114 INSERT INTO t1 VALUES(null);
1123 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1124 SHOW CREATE TABLE t1;
1126 t1 CREATE TABLE `t1` (
1127 `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1129 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1131 INSERT INTO t1 VALUES(null);
1132 INSERT INTO t1 VALUES(null);
1133 INSERT INTO t1 VALUES(null);