Re: remove gaps in a table

From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Fri, 22 Dec 2017 09:37:03 +0000
Message-ID: <p1ijnv$i7p$3_at_dont-email.me>

On 21/12/17 18:02, Thomas 'PointedEars' Lahn wrote:
> J.O. Aho wrote:
>

[Quoted] >> On 12/20/17 20:27, J�rgen Exner wrote:
>>> On Wed, 20 Dec 2017 19:20:09 +0100, "J.O. Aho" <user_at_example.net> wrote
>>> in comp.databases.mysql:
>>>> For you if you want completely gapless order numbers, don't delete, when
>>>
>>> ACK. Mark the order as "deleted" but never remove it from the DB. That
>>> is the correct way to go.

>
> Full ACK.
>

>>>> an order is "deleted", you generate a new order which is the complete
>>>> opposite of the original order, so if the original order is for 3 nails
>>>> of a value of 3 dollars, then the new one is for -3 nails for the value
>>>> of -3 dollars. This way you have gapless order numbers for the
>>>> accounting department and the numbers would be correct from an
>>>> accounting point of view.
>>> That is nuts. How would e.g. shipping package and send -3 nails?
>>
>> Yes, but you have a nuts requirement in the first place and accountants
>> seems to like things nuts like this. ;)

>
> Your logic is flawed. Consider shipping costs, for example.
>
Those go in the table called 'overheads'

-- 
Religion is regarded by the common people as true, by the wise as 
foolish, and by the rulers as useful.

(Seneca the Younger, 65 AD)

Received on Fri Dec 22 2017 - 10:37:03 CET