On 17 Sep 2008, at 22:34, Jerry Schwartz wrote:
> Our Japanese partners will notice and will ask. Similar things have
> come up
> I want to be pro-active.
Notice what? Why would it be bad? What type of data are we dealing
If each row requires a unique ID use an autonumber. If your partners
don't understand that deleted items will create gaps, explain it to
them. IMHO you're creating a problem that doesn't exist.
If you just need sequential numbers for display purposes, generate
them when you do the displaying. There's no need for those numbers to
be in the database.
>> -----Original Message-----
>> From: Stut [mailto:stuttle@stripped]
>> Sent: Wednesday, September 17, 2008 5:17 PM
>> To: Jerry Schwartz
>> Cc: mysql@stripped
>> Subject: Re: Finding gaps
>> On 17 Sep 2008, at 22:12, Jerry Schwartz wrote:
>>> I have records that should be sequentially (not auto-increment)
>>> but there are gaps. Is there any elegant way of finding the gaps?
>> Why do they need to be sequential? When this requirement comes up
>> usually for illogical reasons.