On 6/1/06, Neeraj <[EMAIL PROTECTED]> wrote: > > Is there any way to get a unique ids across all databases (by any way) , > because records from all the databases are finally get stored on a central > database. And the ids of transaction (a record) must remain unique in > central database. > The easiest way, without any replication setup, might be to give all your client databases a unique database_id. Then in your central database database_id.client_transaction_id is guaranteed unique.
Regards, Paul -- Paul B van den Berg, Manager InterAction database, http://www.iadb.nl Dept of Social Pharmacy, Pharmacoepidemiology and Pharmacotherapeutics Groningen University Institute for Drug Exploration, tel +31 503633331 A Deusinglaan 1, 9713AV Groningen, Netherlands, fax +31 503632772 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]