1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL KEY );
3
ALTER TABLE t1 AUTO_INCREMENT=10;
7
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
9
) ENGINE=ENGINE AUTO_INCREMENT=10 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 );
22
ALTER TABLE t1 AUTO_INCREMENT=10;
25
t1 CREATE TABLE `t1` (
26
`c1` smallint(6) 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);
40
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL KEY );
41
ALTER TABLE t1 AUTO_INCREMENT=10;
44
t1 CREATE TABLE `t1` (
45
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
47
) ENGINE=ENGINE AUTO_INCREMENT=10 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 );
60
ALTER TABLE t1 AUTO_INCREMENT=10;
63
t1 CREATE TABLE `t1` (
64
`c1` int(11) NOT NULL AUTO_INCREMENT,
66
) ENGINE=ENGINE AUTO_INCREMENT=10 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 );
79
ALTER TABLE t1 AUTO_INCREMENT=10;
82
t1 CREATE TABLE `t1` (
83
`c1` int(11) NOT NULL AUTO_INCREMENT,
85
) ENGINE=ENGINE AUTO_INCREMENT=10 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 );
98
ALTER TABLE t1 AUTO_INCREMENT=10;
101
t1 CREATE TABLE `t1` (
102
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
104
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
118
SHOW CREATE TABLE t1;
120
t1 CREATE TABLE `t1` (
121
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
123
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
137
SHOW CREATE TABLE t1;
139
t1 CREATE TABLE `t1` (
140
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
142
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
156
SHOW CREATE TABLE t1;
158
t1 CREATE TABLE `t1` (
159
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
161
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
175
SHOW CREATE TABLE t1;
177
t1 CREATE TABLE `t1` (
178
`c1` int(11) NOT NULL AUTO_INCREMENT,
180
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
194
SHOW CREATE TABLE t1;
196
t1 CREATE TABLE `t1` (
197
`c1` int(11) NOT NULL AUTO_INCREMENT,
199
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 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);
230
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY );
231
ALTER TABLE t1 AUTO_INCREMENT=10;
232
SHOW CREATE TABLE t1;
234
t1 CREATE TABLE `t1` (
235
`c1` tinyint(4) AUTO_INCREMENT,
236
UNIQUE KEY `c1` (`c1`)
237
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
251
SHOW CREATE TABLE t1;
253
t1 CREATE TABLE `t1` (
254
`c1` smallint(6) AUTO_INCREMENT,
255
UNIQUE KEY `c1` (`c1`)
256
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
270
SHOW CREATE TABLE t1;
272
t1 CREATE TABLE `t1` (
273
`c1` mediumint(9) AUTO_INCREMENT,
274
UNIQUE KEY `c1` (`c1`)
275
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
289
SHOW CREATE TABLE t1;
291
t1 CREATE TABLE `t1` (
292
`c1` int(11) AUTO_INCREMENT,
293
UNIQUE KEY `c1` (`c1`)
294
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
308
SHOW CREATE TABLE t1;
310
t1 CREATE TABLE `t1` (
311
`c1` int(11) AUTO_INCREMENT,
312
UNIQUE KEY `c1` (`c1`)
313
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
327
SHOW CREATE TABLE t1;
329
t1 CREATE TABLE `t1` (
330
`c1` bigint(20) AUTO_INCREMENT,
331
UNIQUE KEY `c1` (`c1`)
332
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
346
SHOW CREATE TABLE t1;
348
t1 CREATE TABLE `t1` (
349
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
350
UNIQUE KEY `c1` (`c1`)
351
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
365
SHOW CREATE TABLE t1;
367
t1 CREATE TABLE `t1` (
368
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
369
UNIQUE KEY `c1` (`c1`)
370
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
384
SHOW CREATE TABLE t1;
386
t1 CREATE TABLE `t1` (
387
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
388
UNIQUE KEY `c1` (`c1`)
389
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
403
SHOW CREATE TABLE t1;
405
t1 CREATE TABLE `t1` (
406
`c1` int(11) NOT NULL AUTO_INCREMENT,
407
UNIQUE KEY `c1` (`c1`)
408
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
422
SHOW CREATE TABLE t1;
424
t1 CREATE TABLE `t1` (
425
`c1` int(11) NOT NULL AUTO_INCREMENT,
426
UNIQUE KEY `c1` (`c1`)
427
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
441
SHOW CREATE TABLE t1;
443
t1 CREATE TABLE `t1` (
444
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
445
UNIQUE KEY `c1` (`c1`)
446
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
460
SHOW CREATE TABLE t1;
462
t1 CREATE TABLE `t1` (
463
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
465
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
479
SHOW CREATE TABLE t1;
481
t1 CREATE TABLE `t1` (
482
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
484
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
498
SHOW CREATE TABLE t1;
500
t1 CREATE TABLE `t1` (
501
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
503
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
517
SHOW CREATE TABLE t1;
519
t1 CREATE TABLE `t1` (
520
`c1` int(11) NOT NULL AUTO_INCREMENT,
522
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
536
SHOW CREATE TABLE t1;
538
t1 CREATE TABLE `t1` (
539
`c1` int(11) NOT NULL AUTO_INCREMENT,
541
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
555
SHOW CREATE TABLE t1;
557
t1 CREATE TABLE `t1` (
558
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
560
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
574
SHOW CREATE TABLE t1;
576
t1 CREATE TABLE `t1` (
577
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
579
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
593
SHOW CREATE TABLE t1;
595
t1 CREATE TABLE `t1` (
596
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
598
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
612
SHOW CREATE TABLE t1;
614
t1 CREATE TABLE `t1` (
615
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
617
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
631
SHOW CREATE TABLE t1;
633
t1 CREATE TABLE `t1` (
634
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
636
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
650
SHOW CREATE TABLE t1;
652
t1 CREATE TABLE `t1` (
653
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
655
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
669
SHOW CREATE TABLE t1;
671
t1 CREATE TABLE `t1` (
672
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
674
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
688
SHOW CREATE TABLE t1;
690
t1 CREATE TABLE `t1` (
691
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
693
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
707
SHOW CREATE TABLE t1;
709
t1 CREATE TABLE `t1` (
710
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
712
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
726
SHOW CREATE TABLE t1;
728
t1 CREATE TABLE `t1` (
729
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
731
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
745
SHOW CREATE TABLE t1;
747
t1 CREATE TABLE `t1` (
748
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
750
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
764
SHOW CREATE TABLE t1;
766
t1 CREATE TABLE `t1` (
767
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
769
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
783
SHOW CREATE TABLE t1;
785
t1 CREATE TABLE `t1` (
786
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
788
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
802
SHOW CREATE TABLE t1;
804
t1 CREATE TABLE `t1` (
805
`c1` tinyint(3) unsigned AUTO_INCREMENT,
806
UNIQUE KEY `c1` (`c1`)
807
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
821
SHOW CREATE TABLE t1;
823
t1 CREATE TABLE `t1` (
824
`c1` smallint(5) unsigned 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);
838
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
839
ALTER TABLE t1 AUTO_INCREMENT=10;
840
SHOW CREATE TABLE t1;
842
t1 CREATE TABLE `t1` (
843
`c1` mediumint(8) unsigned AUTO_INCREMENT,
844
UNIQUE KEY `c1` (`c1`)
845
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
859
SHOW CREATE TABLE t1;
861
t1 CREATE TABLE `t1` (
862
`c1` int(10) unsigned AUTO_INCREMENT,
863
UNIQUE KEY `c1` (`c1`)
864
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
878
SHOW CREATE TABLE t1;
880
t1 CREATE TABLE `t1` (
881
`c1` int(10) unsigned AUTO_INCREMENT,
882
UNIQUE KEY `c1` (`c1`)
883
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
897
SHOW CREATE TABLE t1;
899
t1 CREATE TABLE `t1` (
900
`c1` bigint(20) unsigned AUTO_INCREMENT,
901
UNIQUE KEY `c1` (`c1`)
902
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
916
SHOW CREATE TABLE t1;
918
t1 CREATE TABLE `t1` (
919
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
920
UNIQUE KEY `c1` (`c1`)
921
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
935
SHOW CREATE TABLE t1;
937
t1 CREATE TABLE `t1` (
938
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
939
UNIQUE KEY `c1` (`c1`)
940
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
954
SHOW CREATE TABLE t1;
956
t1 CREATE TABLE `t1` (
957
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
958
UNIQUE KEY `c1` (`c1`)
959
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
973
SHOW CREATE TABLE t1;
975
t1 CREATE TABLE `t1` (
976
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
977
UNIQUE KEY `c1` (`c1`)
978
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
992
SHOW CREATE TABLE t1;
994
t1 CREATE TABLE `t1` (
995
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
996
UNIQUE KEY `c1` (`c1`)
997
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
1011
SHOW CREATE TABLE t1;
1013
t1 CREATE TABLE `t1` (
1014
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1015
UNIQUE KEY `c1` (`c1`)
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);
1028
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1029
ALTER TABLE t1 AUTO_INCREMENT=10;
1030
SHOW CREATE TABLE t1;
1032
t1 CREATE TABLE `t1` (
1033
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
1035
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
1049
SHOW CREATE TABLE t1;
1051
t1 CREATE TABLE `t1` (
1052
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
1054
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
1068
SHOW CREATE TABLE t1;
1070
t1 CREATE TABLE `t1` (
1071
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
1073
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
1087
SHOW CREATE TABLE t1;
1089
t1 CREATE TABLE `t1` (
1090
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1092
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
1106
SHOW CREATE TABLE t1;
1108
t1 CREATE TABLE `t1` (
1109
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1111
) ENGINE=ENGINE AUTO_INCREMENT=10 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
ALTER TABLE t1 AUTO_INCREMENT=10;
1125
SHOW CREATE TABLE t1;
1127
t1 CREATE TABLE `t1` (
1128
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1130
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1131
INSERT INTO t1 VALUES(null);
1132
INSERT INTO t1 VALUES(null);
1133
INSERT INTO t1 VALUES(null);