Saving auto increment in MySQL

Posted by oshafran on Stack Overflow See other posts from Stack Overflow or by oshafran
Published on 2010-02-08T08:08:45Z Indexed on 2010/06/13 0:02 UTC
Read the original article Hit count: 260

Hello, I am trying to sync between 2 tables: I have active table where has auto_increment, and I have archive table with the same values. I would like both ID's to be unique (between the tables as well) - I mean, I would like to save auto incremenet, and if I UNION both table I still have uniqness. How can I do that? Is there a possibility to save auto increment when mysql is off?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about unique