Is it possible to have auto increment field which generates even or odd numbers (skips the opposite)? The reason I am asking is because I want to share auto increment between two tables. Other ways for achieving it are welcomed.
Thanks in advance!
解决方案
You can offset one table's auto increment field from the other, i.e. one table starts ids from 1 while the other starts from 1000000 (or some other value chosen depending on your usage pattern).
CREATE TABLE table1 (id BIGINT UNSIGNED AUTO_INCREMENT);
CREATE TABLE table2 (id BIGINT UNSIGNED AUTO_INCREMENT) AUTO_INCREMENT = 1000000;
You can also choose your autoincrement column type according to your needs. BIGINT UNSIGNED's range is 0..18446744073709551615, which should cover most cases.