Message-ID: <568AE2A1.2070103@ssf.com.mx>
Date: Mon, 04 Jan 2016 15:22:41 -0600
From: OTHONIEL ALEJANDRO GUTIERREZ <othoniel@ssf.com.mx>
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.7.0
MIME-Version: 1.0
To: Ricardo Sansores <ricardo@ssf.mx>
Subject: bug
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

DROP DATABASE IF EXISTS D20;
CREATE DATABASE D20;
CREATE TABLE D20.`t1` (`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
`value` CHAR( 1 ) NOT NULL) ENGINE = InnoDB;
CREATE TABLE D20.`t2` (`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
`value` CHAR( 1 ) NOT NULL) ENGINE = InnoDB;
INSERT INTO D20.`t1`(`value`) VALUES('a'),('b');
INSERT INTO D20.`t2`(`value`) SELECT `value` FROM D20.`t1`;
INSERT INTO D20.`t2`(`value`) VALUES('c');
SELECT * FROM D20.`t1`;
SELECT * FROM D20.`t2`;

-- 
http://stackoverflow.com/questions/12226105/mysql-auto-increment-jumps-when-insert-select