Re: Next Unique Number - Generation

2011-07-22 Thread Prabhat Kumar
Assign each server a number and prefix/append that number to the unique > ID. > I will suggest you above, append -A for first machine and -B for second machine. -Prabhat On Thu, Jul 21, 2011 at 12:13 PM, Daevid Vincent wrote: > I can think of several ways to accomplish this (or close to it)

RE: Next Unique Number - Generation

2011-07-21 Thread Daevid Vincent
I can think of several ways to accomplish this (or close to it). * Assign each server a number and prefix/append that number to the unique ID. * initialize each table on each server at a different huge number so they don't ever collide: ALTER TABLE `students` AUTO_INCREMENT=1

Re: Next Unique Number - Generation

2011-07-20 Thread Vikram A
: Next Unique Number - Generation Hi in ur database define the 2 numbers as auto increment. Neil Martins Exactus Corporation Pvt. Limited ISO 9001:2000 certified 1st floor, Raheja Plaza, LBS Marg, Ghatkopar (West), Mumbai 400 086 India T: (9122) 66505900 F: (9122) 22040826 Url:www.exactuscorp.com