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
