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]

Reply via email to