In article <[EMAIL PROTECTED]>, "Dan Tappin" <[EMAIL PROTECTED]> writes:
>> -----Original Message----- >> From: Harald Fuchs >> Sent: Wednesday, September 22, 2004 9:39 AM >> To: [EMAIL PROTECTED] >> Subject: Re: Custom Auto-Increment Problem >> >> The only difference is when you delete rows inbetween. In this case >> id_calc will be less than id. > I stand corrected. Yes it can be calculated but however the deletion of rows makes > the calculation unreliable. The id number has > to be constant regardless of row deletion. I can't have the id changing thus that's > why I am storing it. But this means that the ids for each id_client are not any more consecutive, they're only unique. If you don't require that the ids are always consecutive, then why not use a single auto_increment id column which guarantees unique ids? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]