gerald_clark writes:
>Danny wrote:
>
>>Can you update an auto_increment with NULL in MySQL? Obviously if you
>>try and put a NULL in directly it will increment to the next integer. 
>>Is there some way to actually get a NULL in there instead of the
>>integer?
>>  
>>
>No.
>Why would you want to?

Because I have a column that is normally NULL since I normally don't
have information about that column. Occasionally I acquire information
about it and assign it to a category. AUTO_INCREMENT is useful because
I don't have to think about what the next new category will be. 
Instead of NULL I could use 0, if I don't have information, but NULL
would be the more natural state for lack of information. No biggy
though.

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

Reply via email to