On 17 Sep 2008, at 22:34, Jerry Schwartz wrote:
Our Japanese partners will notice and will ask. Similar things have
come up
before.
I want to be pro-active.
Notice what? Why would it be bad? What type of data are we dealing
with here?
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.
-Stut
--
http://stut.net/
-----Original Message-----
From: Stut [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2008 5:17 PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Finding gaps
On 17 Sep 2008, at 22:12, Jerry Schwartz wrote:
I have records that should be sequentially (not auto-increment)
numbered,
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
it's
usually for illogical reasons.
-Stut
--
http://stut.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
