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);