Shankar Unni wrote:
> I tried setting a TIMESTAMP column (nullable, not first timestamp in
> that table) in mysql 3.23.38) to NULL, but it seems to get the value
> 00000000000000. Is it not possible to set a timestamp column to NULL?
It's even worse: if you explicitly insert the value NULL (as in the keyword
"null"), it inserts now() instead.
Try:
create table foo (t timestamp, u timestamp);
insert into foo(t) values('');
// inserts 0000.... in both t and u.
insert into foo(t,u) values (null,null);
// inserts the value of now() into both t and u.
Is this a bug, or a feature I missed in the documentation?
--
Shankar.
---------------------------------------------------------------------
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
