> -----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. Dan T -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]