MySQL: Auto increment with even or odd numbers only?

Question

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!

Answer 1

As mentioned by Juergen you could do that at system level instead of session level by making following change (or adding) in my.ini file:

auto-increment-increment = 2
auto-increment-offset = 1

or

auto-increment-increment = 2
auto-increment-offset = 2

Basically this is much used in Master-Master replication setup.

Answer 2

try

SET @@auto_increment_increment=2;
SET @@auto_increment_offset=2;