MySQL Forums :: Newbie :: Unique columns over two tables


Advanced Search

Unique columns over two tables
Posted by: Richard Thompson ()
Date: March 30, 2009 10:57AM

My application has two tables which require the id column from each table to be unique across both tables. The current setup has both id columns form each table set up as an auto incremented integer, which obvisouly could result in matches between them.

Can anyone recommend a way if making these columns contain unique id's across both tables but still have an automated way of generating the data?

Thanks

Options: ReplyQuote


Subject Written By Posted
Unique columns over two tables Richard Thompson 03/30/2009 10:57AM
Re: Unique columns over two tables Rick James 03/31/2009 08:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.