SvjepzuT

1drop table if exists f1;
2   create table f1 (
3        i int(11)  not null auto_increment,
4        primary key (`i`)
5   )ENGINE=InnoDB AUTO_INCREMENT=2147483640 DEFAULT CHARSET=utf8;
6
7   insert into f1 values (); -- execute this for 8 times
8
9   select * from f1;
10
11+------------+
12| i          |
13+------------+
14| 2147483640 |
15| 2147483641 |
16| 2147483642 |
17| 2147483643 |
18| 2147483644 |
19| 2147483645 |
20| 2147483647 |
21+------------+
22	
23drop table if exists f1;
24create table f1 (
25  i int(11)  not null ,
26 primary key (`i`)
27)ENGINE=InnoDB AUTO_INCREMENT=2147483640 DEFAULT CHARSET=utf8;
28
29insert into f1 values (2147483644),(2147483645),(2147483646),(2147483647);
30
31select * from f1;
32
33+------------+
34| i          |
35+------------+
36| 2147483644 |
37| 2147483645 |
38| 2147483646 |
39| 2147483647 |
40+------------+