Re: remove gaps in a table

From: Thomas 'PointedEars' Lahn <PointedEars_at_web.de>
Date: Thu, 21 Dec 2017 19:02:06 +0100
Message-ID: <2127140.M88JOD1kPO_at_PointedEars.de>

[Quoted] J.O. Aho wrote:

> 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. ;)

[Quoted] [Quoted] Your logic is flawed. Consider shipping costs, for example.

-- 
PointedEars
Zend Certified PHP Engineer <http://www.zend.com/en/yellow-pages/ZEND024953>
<https://github.com/PointedEars> | <http://PointedEars.de/wsvn>
Twitter: _at_PointedEars2 | Please do not cc me./Bitte keine Kopien per E-Mail.

Received on Thu Dec 21 2017 - 19:02:06 CET