[thelist] auto-increment with mysql

Frank lists at frankmarion.com
Fri Jul 18 03:20:11 CDT 2003


At 03:36 PM 2003-07-18 +1000, you wrote:
>>Why an unsigned int, instead of simply int?
>
>One virtually never has negative values in an identity column. By using
>an unsigned int instead of an int, you're effectively doubling the
>number of values a column can have.


HA! That's pretty clever. I wouldn't have thought of it. Cool.


--
Frank Marion     lists at frankmarion.com      Keep the signal high.  



More information about the thelist mailing list