Re: getting NULL in auto_increment column
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 that's why you declare it NOT NULL when you create it. ---John Holmes... - 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
Re: getting NULL in auto_increment column
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? - 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
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
RE: getting NULL in auto_increment column
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