Mark writes:
> When I do a describe statement, I see some default values assigned > automatically to columns in the table. What statement will assign a column > to blank, so that there is no default value assigned? Short answer: you can't. There was a long thread about this a week or two ago, and apparently the lack of default-free columns is due to some internal details, as well at to the paradigm of letting applications verify data instead of having the RDBMS do it. Note though that for strings, ENUMs and SETs you can specify a default of '', the special ENUM value '' and the empty set respectively. Also, columns that can be NULL can have a default of NULL. On an altogether unrelated matter: Your time zone is set to pacific time, but your time reveals that you're somewhere on the American east coast. You might want to correct your TZ. //C - defaults to being tired -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- 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