At 23:41 +0000 1/4/02, David Ayliffe wrote:
>I have created a test table with:
>CREATE TABLE TimeTest (
>This works fine! No problemo
>Now ALL I am trying to do is insert the current time and date into each
>field in the table!! That's all.
>I'm not new to MySQL or its operation but this has really got the better
>of me. Maybe its because its 11:40PM after a day of work but can
>someone please tell me how I can insert a row of current time and date
>into a table with different column definitions!
>I have tried:
>INSERT INTO TimeTest (NULL, NULL, NULL, NULL, NULL);
>I have tried NOW, 'NULL'.
NOW() would work better than NOW.
NULL will insert the current date and time only into the *first*