It does not sound like your data is properly normalized. You might want to take a look at the way you have things set up, this sounds like it cause problems later on.
-----Original Message----- From: Danny [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 1:54 PM To: [EMAIL PROTECTED] Subject: Re: getting NULL in auto_increment column 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 --------------------------------------------------------------------- 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
