RE: How to get machine independent unique id??

2006-06-02 Thread Neeraj
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 Bue

Re: How to get machine independent unique id??

2006-06-02 Thread Paul B van den Berg
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

Re: How to get machine independent unique id??

2006-06-01 Thread Daniel da Veiga
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) , be

Re: How to get machine independent unique id??

2006-06-01 Thread cknipe
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??

2006-06-01 Thread Dan Buettner
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