Re: remove gaps in a table

[Quoted] J.O. Aho wrote:

> For you if you want completely gapless order numbers, don't delete, when
> an order is "deleted", you generate a new order which is the complete
> opposite of the original order, […]

[Quoted] [Quoted] It is infinitely easier and makes much more sense to have a field that says “if I have a certain value, this order was made but canceled later”. And that is what is usually done. Usually the type of that field is BOOLEAN or INT.

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