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);
20
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
23
t1 CREATE TABLE `t1` (
24
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
26
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
27
INSERT INTO t1 VALUES(null);
28
INSERT INTO t1 VALUES(null);
29
INSERT INTO t1 VALUES(null);
38
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
41
t1 CREATE TABLE `t1` (
42
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
44
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
45
INSERT INTO t1 VALUES(null);
46
INSERT INTO t1 VALUES(null);
47
INSERT INTO t1 VALUES(null);
56
CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
59
t1 CREATE TABLE `t1` (
60
`c1` int(11) NOT NULL AUTO_INCREMENT,
62
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
63
INSERT INTO t1 VALUES(null);
64
INSERT INTO t1 VALUES(null);
65
INSERT INTO t1 VALUES(null);
74
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
77
t1 CREATE TABLE `t1` (
78
`c1` int(11) NOT NULL AUTO_INCREMENT,
80
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
81
INSERT INTO t1 VALUES(null);
82
INSERT INTO t1 VALUES(null);
83
INSERT INTO t1 VALUES(null);
92
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
95
t1 CREATE TABLE `t1` (
96
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
98
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
99
INSERT INTO t1 VALUES(null);
100
INSERT INTO t1 VALUES(null);
101
INSERT INTO t1 VALUES(null);
110
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
111
SHOW CREATE TABLE t1;
113
t1 CREATE TABLE `t1` (
114
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
116
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
117
INSERT INTO t1 VALUES(null);
118
INSERT INTO t1 VALUES(null);
119
INSERT INTO t1 VALUES(null);
128
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
129
SHOW CREATE TABLE t1;
131
t1 CREATE TABLE `t1` (
132
`c1` smallint(6) 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);
146
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
147
SHOW CREATE TABLE t1;
149
t1 CREATE TABLE `t1` (
150
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
152
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
153
INSERT INTO t1 VALUES(null);
154
INSERT INTO t1 VALUES(null);
155
INSERT INTO t1 VALUES(null);
164
CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
165
SHOW CREATE TABLE t1;
167
t1 CREATE TABLE `t1` (
168
`c1` int(11) NOT NULL AUTO_INCREMENT,
170
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
171
INSERT INTO t1 VALUES(null);
172
INSERT INTO t1 VALUES(null);
173
INSERT INTO t1 VALUES(null);
182
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
183
SHOW CREATE TABLE t1;
185
t1 CREATE TABLE `t1` (
186
`c1` int(11) NOT NULL AUTO_INCREMENT,
188
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
189
INSERT INTO t1 VALUES(null);
190
INSERT INTO t1 VALUES(null);
191
INSERT INTO t1 VALUES(null);
200
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
201
SHOW CREATE TABLE t1;
203
t1 CREATE TABLE `t1` (
204
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
206
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
207
INSERT INTO t1 VALUES(null);
208
INSERT INTO t1 VALUES(null);
209
INSERT INTO t1 VALUES(null);
218
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
219
SHOW CREATE TABLE t1;
221
t1 CREATE TABLE `t1` (
222
`c1` tinyint(4) AUTO_INCREMENT,
223
UNIQUE KEY `c1` (`c1`)
224
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
225
INSERT INTO t1 VALUES(null);
226
INSERT INTO t1 VALUES(null);
227
INSERT INTO t1 VALUES(null);
236
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
237
SHOW CREATE TABLE t1;
239
t1 CREATE TABLE `t1` (
240
`c1` smallint(6) AUTO_INCREMENT,
241
UNIQUE KEY `c1` (`c1`)
242
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
243
INSERT INTO t1 VALUES(null);
244
INSERT INTO t1 VALUES(null);
245
INSERT INTO t1 VALUES(null);
254
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
255
SHOW CREATE TABLE t1;
257
t1 CREATE TABLE `t1` (
258
`c1` mediumint(9) AUTO_INCREMENT,
259
UNIQUE KEY `c1` (`c1`)
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);
272
CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
273
SHOW CREATE TABLE t1;
275
t1 CREATE TABLE `t1` (
276
`c1` int(11) AUTO_INCREMENT,
277
UNIQUE KEY `c1` (`c1`)
278
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
279
INSERT INTO t1 VALUES(null);
280
INSERT INTO t1 VALUES(null);
281
INSERT INTO t1 VALUES(null);
290
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
291
SHOW CREATE TABLE t1;
293
t1 CREATE TABLE `t1` (
294
`c1` int(11) AUTO_INCREMENT,
295
UNIQUE KEY `c1` (`c1`)
296
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
297
INSERT INTO t1 VALUES(null);
298
INSERT INTO t1 VALUES(null);
299
INSERT INTO t1 VALUES(null);
308
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
309
SHOW CREATE TABLE t1;
311
t1 CREATE TABLE `t1` (
312
`c1` bigint(20) AUTO_INCREMENT,
313
UNIQUE KEY `c1` (`c1`)
314
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
315
INSERT INTO t1 VALUES(null);
316
INSERT INTO t1 VALUES(null);
317
INSERT INTO t1 VALUES(null);
326
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
327
SHOW CREATE TABLE t1;
329
t1 CREATE TABLE `t1` (
330
`c1` tinyint(4) NOT NULL 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 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
345
SHOW CREATE TABLE t1;
347
t1 CREATE TABLE `t1` (
348
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
349
UNIQUE KEY `c1` (`c1`)
350
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
351
INSERT INTO t1 VALUES(null);
352
INSERT INTO t1 VALUES(null);
353
INSERT INTO t1 VALUES(null);
362
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
363
SHOW CREATE TABLE t1;
365
t1 CREATE TABLE `t1` (
366
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
367
UNIQUE KEY `c1` (`c1`)
368
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
369
INSERT INTO t1 VALUES(null);
370
INSERT INTO t1 VALUES(null);
371
INSERT INTO t1 VALUES(null);
380
CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
381
SHOW CREATE TABLE t1;
383
t1 CREATE TABLE `t1` (
384
`c1` int(11) NOT NULL AUTO_INCREMENT,
385
UNIQUE KEY `c1` (`c1`)
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);
398
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
399
SHOW CREATE TABLE t1;
401
t1 CREATE TABLE `t1` (
402
`c1` int(11) NOT NULL AUTO_INCREMENT,
403
UNIQUE KEY `c1` (`c1`)
404
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
405
INSERT INTO t1 VALUES(null);
406
INSERT INTO t1 VALUES(null);
407
INSERT INTO t1 VALUES(null);
416
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
417
SHOW CREATE TABLE t1;
419
t1 CREATE TABLE `t1` (
420
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
421
UNIQUE KEY `c1` (`c1`)
422
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
423
INSERT INTO t1 VALUES(null);
424
INSERT INTO t1 VALUES(null);
425
INSERT INTO t1 VALUES(null);
434
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
435
SHOW CREATE TABLE t1;
437
t1 CREATE TABLE `t1` (
438
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
440
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
441
INSERT INTO t1 VALUES(null);
442
INSERT INTO t1 VALUES(null);
443
INSERT INTO t1 VALUES(null);
452
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
453
SHOW CREATE TABLE t1;
455
t1 CREATE TABLE `t1` (
456
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
458
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
459
INSERT INTO t1 VALUES(null);
460
INSERT INTO t1 VALUES(null);
461
INSERT INTO t1 VALUES(null);
470
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
471
SHOW CREATE TABLE t1;
473
t1 CREATE TABLE `t1` (
474
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
476
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
477
INSERT INTO t1 VALUES(null);
478
INSERT INTO t1 VALUES(null);
479
INSERT INTO t1 VALUES(null);
488
CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
489
SHOW CREATE TABLE t1;
491
t1 CREATE TABLE `t1` (
492
`c1` int(11) NOT NULL AUTO_INCREMENT,
494
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
495
INSERT INTO t1 VALUES(null);
496
INSERT INTO t1 VALUES(null);
497
INSERT INTO t1 VALUES(null);
506
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
507
SHOW CREATE TABLE t1;
509
t1 CREATE TABLE `t1` (
510
`c1` int(11) NOT NULL AUTO_INCREMENT,
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);
524
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
525
SHOW CREATE TABLE t1;
527
t1 CREATE TABLE `t1` (
528
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
530
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
531
INSERT INTO t1 VALUES(null);
532
INSERT INTO t1 VALUES(null);
533
INSERT INTO t1 VALUES(null);
542
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
543
SHOW CREATE TABLE t1;
545
t1 CREATE TABLE `t1` (
546
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
548
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
549
INSERT INTO t1 VALUES(null);
550
INSERT INTO t1 VALUES(null);
551
INSERT INTO t1 VALUES(null);
560
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
561
SHOW CREATE TABLE t1;
563
t1 CREATE TABLE `t1` (
564
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
566
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
567
INSERT INTO t1 VALUES(null);
568
INSERT INTO t1 VALUES(null);
569
INSERT INTO t1 VALUES(null);
578
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
579
SHOW CREATE TABLE t1;
581
t1 CREATE TABLE `t1` (
582
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
584
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
585
INSERT INTO t1 VALUES(null);
586
INSERT INTO t1 VALUES(null);
587
INSERT INTO t1 VALUES(null);
596
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
597
SHOW CREATE TABLE t1;
599
t1 CREATE TABLE `t1` (
600
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
602
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
603
INSERT INTO t1 VALUES(null);
604
INSERT INTO t1 VALUES(null);
605
INSERT INTO t1 VALUES(null);
614
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
615
SHOW CREATE TABLE t1;
617
t1 CREATE TABLE `t1` (
618
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
620
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
621
INSERT INTO t1 VALUES(null);
622
INSERT INTO t1 VALUES(null);
623
INSERT INTO t1 VALUES(null);
632
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
633
SHOW CREATE TABLE t1;
635
t1 CREATE TABLE `t1` (
636
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
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);
650
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
651
SHOW CREATE TABLE t1;
653
t1 CREATE TABLE `t1` (
654
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
656
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
657
INSERT INTO t1 VALUES(null);
658
INSERT INTO t1 VALUES(null);
659
INSERT INTO t1 VALUES(null);
668
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
669
SHOW CREATE TABLE t1;
671
t1 CREATE TABLE `t1` (
672
`c1` smallint(5) 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 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
687
SHOW CREATE TABLE t1;
689
t1 CREATE TABLE `t1` (
690
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
692
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
693
INSERT INTO t1 VALUES(null);
694
INSERT INTO t1 VALUES(null);
695
INSERT INTO t1 VALUES(null);
704
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
705
SHOW CREATE TABLE t1;
707
t1 CREATE TABLE `t1` (
708
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
710
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
711
INSERT INTO t1 VALUES(null);
712
INSERT INTO t1 VALUES(null);
713
INSERT INTO t1 VALUES(null);
722
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
723
SHOW CREATE TABLE t1;
725
t1 CREATE TABLE `t1` (
726
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
728
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
729
INSERT INTO t1 VALUES(null);
730
INSERT INTO t1 VALUES(null);
731
INSERT INTO t1 VALUES(null);
740
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
741
SHOW CREATE TABLE t1;
743
t1 CREATE TABLE `t1` (
744
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
746
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
747
INSERT INTO t1 VALUES(null);
748
INSERT INTO t1 VALUES(null);
749
INSERT INTO t1 VALUES(null);
758
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
759
SHOW CREATE TABLE t1;
761
t1 CREATE TABLE `t1` (
762
`c1` tinyint(3) unsigned 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);
776
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
777
SHOW CREATE TABLE t1;
779
t1 CREATE TABLE `t1` (
780
`c1` smallint(5) unsigned AUTO_INCREMENT,
781
UNIQUE KEY `c1` (`c1`)
782
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
783
INSERT INTO t1 VALUES(null);
784
INSERT INTO t1 VALUES(null);
785
INSERT INTO t1 VALUES(null);
794
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
795
SHOW CREATE TABLE t1;
797
t1 CREATE TABLE `t1` (
798
`c1` mediumint(8) unsigned AUTO_INCREMENT,
799
UNIQUE KEY `c1` (`c1`)
800
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
801
INSERT INTO t1 VALUES(null);
802
INSERT INTO t1 VALUES(null);
803
INSERT INTO t1 VALUES(null);
812
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
813
SHOW CREATE TABLE t1;
815
t1 CREATE TABLE `t1` (
816
`c1` int(10) unsigned AUTO_INCREMENT,
817
UNIQUE KEY `c1` (`c1`)
818
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
819
INSERT INTO t1 VALUES(null);
820
INSERT INTO t1 VALUES(null);
821
INSERT INTO t1 VALUES(null);
830
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
831
SHOW CREATE TABLE t1;
833
t1 CREATE TABLE `t1` (
834
`c1` int(10) unsigned AUTO_INCREMENT,
835
UNIQUE KEY `c1` (`c1`)
836
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
837
INSERT INTO t1 VALUES(null);
838
INSERT INTO t1 VALUES(null);
839
INSERT INTO t1 VALUES(null);
848
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
849
SHOW CREATE TABLE t1;
851
t1 CREATE TABLE `t1` (
852
`c1` bigint(20) unsigned AUTO_INCREMENT,
853
UNIQUE KEY `c1` (`c1`)
854
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
855
INSERT INTO t1 VALUES(null);
856
INSERT INTO t1 VALUES(null);
857
INSERT INTO t1 VALUES(null);
866
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
867
SHOW CREATE TABLE t1;
869
t1 CREATE TABLE `t1` (
870
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
871
UNIQUE KEY `c1` (`c1`)
872
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
873
INSERT INTO t1 VALUES(null);
874
INSERT INTO t1 VALUES(null);
875
INSERT INTO t1 VALUES(null);
884
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
885
SHOW CREATE TABLE t1;
887
t1 CREATE TABLE `t1` (
888
`c1` smallint(5) unsigned 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);
902
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
903
SHOW CREATE TABLE t1;
905
t1 CREATE TABLE `t1` (
906
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
907
UNIQUE KEY `c1` (`c1`)
908
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
909
INSERT INTO t1 VALUES(null);
910
INSERT INTO t1 VALUES(null);
911
INSERT INTO t1 VALUES(null);
920
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
921
SHOW CREATE TABLE t1;
923
t1 CREATE TABLE `t1` (
924
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
925
UNIQUE KEY `c1` (`c1`)
926
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
927
INSERT INTO t1 VALUES(null);
928
INSERT INTO t1 VALUES(null);
929
INSERT INTO t1 VALUES(null);
938
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
939
SHOW CREATE TABLE t1;
941
t1 CREATE TABLE `t1` (
942
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
943
UNIQUE KEY `c1` (`c1`)
944
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
945
INSERT INTO t1 VALUES(null);
946
INSERT INTO t1 VALUES(null);
947
INSERT INTO t1 VALUES(null);
956
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
957
SHOW CREATE TABLE t1;
959
t1 CREATE TABLE `t1` (
960
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
961
UNIQUE KEY `c1` (`c1`)
962
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
963
INSERT INTO t1 VALUES(null);
964
INSERT INTO t1 VALUES(null);
965
INSERT INTO t1 VALUES(null);
974
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
975
SHOW CREATE TABLE t1;
977
t1 CREATE TABLE `t1` (
978
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
980
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
981
INSERT INTO t1 VALUES(null);
982
INSERT INTO t1 VALUES(null);
983
INSERT INTO t1 VALUES(null);
992
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
993
SHOW CREATE TABLE t1;
995
t1 CREATE TABLE `t1` (
996
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
998
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
999
INSERT INTO t1 VALUES(null);
1000
INSERT INTO t1 VALUES(null);
1001
INSERT INTO t1 VALUES(null);
1010
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1011
SHOW CREATE TABLE t1;
1013
t1 CREATE TABLE `t1` (
1014
`c1` mediumint(8) unsigned 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);
1028
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1029
SHOW CREATE TABLE t1;
1031
t1 CREATE TABLE `t1` (
1032
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1034
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1035
INSERT INTO t1 VALUES(null);
1036
INSERT INTO t1 VALUES(null);
1037
INSERT INTO t1 VALUES(null);
1046
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1047
SHOW CREATE TABLE t1;
1049
t1 CREATE TABLE `t1` (
1050
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1052
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1053
INSERT INTO t1 VALUES(null);
1054
INSERT INTO t1 VALUES(null);
1055
INSERT INTO t1 VALUES(null);
1064
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1065
SHOW CREATE TABLE t1;
1067
t1 CREATE TABLE `t1` (
1068
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1070
) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1071
INSERT INTO t1 VALUES(null);
1072
INSERT INTO t1 VALUES(null);
1073
INSERT INTO t1 VALUES(null);