We had this discussion here a couple of days ago. There are
versions of MySQL who behave this way, but it is mostly not
considered the correct way. So you may as well get used to the
idea that an autoincremented field is doomed to increment no
matter what.
> That got me thinking...say you have a list of 500 people, and you delete
> the
> person with id 500 (The Person with the very last ID). Now, your ID's go
> up
> to 499. Now say someone else is added. Would they have an id of 500 or
> 501? For me it would be 500, which would create a security problem, but I
> very well could be doing something wrong. Is this a typical behavior?
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
