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 ?

BTW I am using JBoss to access the DB.

Thanks a lot in advance,

Regards

Stefan

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to