On 9 Oct 2002, at 13:14, Lawrence S. Stephens III wrote: > When I INSERT a record, that field is empty so that the default value > is inserted into the field automatically (at least that's what I think).
If your query is setting the column to the empty string, then you're setting it to the empty string, not the default value. To get the default value (before MySQL 4.0.3), you have to omit that column from the INSERT statement: http://www.mysql.com/doc/en/INSERT.html -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- 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