Paul DuBois wrote:
> Feature you missed. Have a look here:
>
> http://www.mysql.com/doc/D/A/DATETIME.html
Thanks. I wonder how I missed that.
Of course, the page lies somewhat: it says that if you omit the column in
an insert, it should get set to now(), but the following example shows it
doesn't - notice that "u" is omitted in the insert, but gets set to 0
instead of now().
>> create table foo (t timestamp, u timestamp);
>> insert into foo(t) values('');
>> // inserts 0000.... in both t and u.
Not that I want to get into an "aha! Gotcha!" thing, of course.
P.S. The reason I went with TIMESTAMP instead of DATETIME is for storage
efficiency (I'm logging millions of events into a table), but at the same
time, I'm logging different kinds of events to the table, and some have
additional timestamps that are only applicable for those variants (which is
why I would like to set the column to NULL for the other cases).
Anyway, sigh!.
Thanks,
--
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
