Paul DuBois wrote:
manner. AUTO_INCREMENT columns are for use only with *positive* integers,
and any attempt to use them otherwise will eventually cause you grief.
Just to point out, a lot of people get confused about the definition of positive integers, especially in how it relates to zero. A link to Dr. Math might help, fwiw: http://mathforum.org/dr.math/faq/faq.integers.html :)
However, I'd be careful to point out in the docs (and I haven't checked lately, so it may be there) that this does in fact mean that the smallest value an AUTO_INCREMENT column should hold is the positive integer value 1.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd. (SQL)
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
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
