Carl, Monday, April 15, 2002, 11:29:10 PM, you wrote: CM> One of our developers pointed out something to me today and I can't explain. CM> When we created a table with timestamp as one of the column types and "not CM> null" the "describe table" command shows that nulls are allowed for the CM> timestamp column. However, a "show create table" command shows the not null CM> for the timestamp column. Which is correct? How do I make the column not CM> null?
SHOW CREATE TABLE shows you CREATE TABLE statement that is used for creating your table. DESCRIBE <table> give you info about your table. If you read section 6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types in the MySQL manual, you may know that inserting NULL value in the TIMESTAMP column gives you the same result if you use function NOW(). So, default value NULL in the output of DESCRIBE <table> and definition column as NOT NULL in the SHOW CREATE TABLE do not confront to each other. CM> Carl McNamee -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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