mysql auto increment.

mysql_auto_increment.sql

drop table if exists s_test_mysql_auto_increment;
create table s_test_mysql_auto_increment(id int primary key auto_increment, value int);

insert into s_test_mysql_auto_increment(value) values (10000);
SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME   = 's_test_mysql_auto_increment';

insert into s_test_mysql_auto_increment(value) values (10001);
SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME   = 's_test_mysql_auto_increment';

insert into s_test_mysql_auto_increment(value) values (10002);
SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME   = 's_test_mysql_auto_increment';

insert into s_test_mysql_auto_increment(id, value) values (1000, 10002);
SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME   = 's_test_mysql_auto_increment';

insert into s_test_mysql_auto_increment(id, value) values (500, 10002);
SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME   = 's_test_mysql_auto_increment';

insert into s_test_mysql_auto_increment(value) values (10002);
SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME   = 's_test_mysql_auto_increment';