Did you define the columns as NOT NULL? Bogdan
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'. > > 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 --------------------------------------------------------------------- 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
