At 23:41 +0000 1/4/02, David Ayliffe wrote: >I have created a test table with: > >CREATE TABLE TimeTest ( >Time1 TIMESTAMP(4), >Time2 TIMESTAMP(8), >Time3 TIMESTAMP(10), >Time4 TIMESTAMP(12), >Time5 TIMESTAMP(14)); > >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* TIMESTAMP column. http://www.mysql.com/doc/D/A/DATETIME.html > >Please > > >Thanks >DA --------------------------------------------------------------------- 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
