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'. 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
