How to get the next auto-increment id?

[Euan T]

Also note that some databases (such as those being used in master-master replication) actually increment their IDs by 2 rather than 1, which is configurable in the database settings. Really, you're going about this all wrong. If you're having to guess ID values, you've failed in your architecture design.