Re: remove gaps in a table

From: (wrong string) ürgen Exner <jurgenex_at_hotmail.com>
Date: Tue, 19 Dec 2017 15:29:53 -0800
Message-ID: <kq7j3d12gqqs0ggpibfm8pqul1s3jbogag_at_4ax.com>


[Quoted] [Quoted] On Tue, 19 Dec 2017 22:03:16 +0100, mireero <mireero_at_free.fr> wrote in comp.databases.mysql:

[...]
>I'm looking for a way to "reduce" the order_number, to remove gaps, that
>is to obtain:
[...]
>I guess we could just iterate on all rows and set the order_number,
>beginning from 1 but I have the feeling I'm missing something.
>
>Note: in the real table, there are thousands of rows.

[Quoted] Are you sure this is a good idea? I just imagine a customer calling:

"Good morning. This is ACME Corporation customer support. How may I help you".
"Good morning. We have an issue with our last order. The order number is 12345".
"Just a second, let me look this up. Ah, yes, I see. What is the problem with the 50 anal beads?"
"Anal beads? This is the Jesuit Convent of xyz and I am calling about the order for 30 rosaries!".

jue Received on Wed Dec 20 2017 - 00:29:53 CET

Original text of this message