"Stefan Schuster" <[EMAIL PROTECTED]> wrote: > Hi, > > I have a question about auto_increment: > > I have 2 tables, on of them holds my "online transactions", the other > one the "offline transactions". Every transaction is created in the > first table (call it t1) and then moved to t2. The id is generated using > auto_increment. > > My problem is that the id's should be unique across both > tables. If I dont restart the server this works fine, but if I > restart it, mySQL assigns the lowest number for the new row in > t1, but this id exits already in t2 which results in an error > if I try to move from t1 to t2. > > I hope I explained the problem in a appropriate way. > > How can I tell mySQL to hold the auto_increment counter for > Table t1 persistent ?
Do you use InnoDB tables? If so, it's a known behavior. If you restart MySQL server InnoDB may reuse old value for AUTO_INCREMENT column. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
