Re: How to get machine independent unique id??

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

RE: How to get machine independent unique id??

Many thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 8:00 PM To: mysql@lists.mysql.com Subject: Re: How to get machine independent unique id?? Isn't UUID() unique for each system it runs on?? -- Chris Quoting Dan Buettner

How to get machine independent unique id??

Hi all.. I have a scenario of many client databases and one central database.. 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)

Re: How to get machine independent unique id??

Neeraj - One idea might be to use both a client ID field and a record ID field to uniquely identify records. This approach has benefits (easy to add clients, doesn't require as much client setup or planning) and a potentially big drawback (no one unique record identifier). Another would be

Re: How to get machine independent unique id??

Isn't UUID() unique for each system it runs on?? -- Chris Quoting Dan Buettner [EMAIL PROTECTED]: Neeraj - One idea might be to use both a client ID field and a record ID field to uniquely identify records. This approach has benefits (easy to add clients, doesn't require as much

Re: How to get machine independent unique id??

On 6/1/06, Neeraj [EMAIL PROTECTED] wrote: Hi all.. Hi, try not to put 8 line breaks on each paragraph please ;-) I have a scenario of many client databases and one central database.. Implemented or project? Is there any way to get a unique ids across all databases (by any way) ,