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