Re: remove gaps in a table

J.O. Aho wrote:

> On 12/21/17 19:02, Thomas 'PointedEars' Lahn wrote:

>> 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:
>>>>> 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.

You must be joking.

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