You may try an "INSERT INTO TimeTest set Time5='2002-1-2'" and see if at least Time1 gets populated...
In the worst case you can INSERT INTO TimeTest (now(), now(), now(), now(), now()); David Ayliffe wrote: > NO, not originally but I have now and it seems to make no difference! > Any other ideas? > > -----Original Message----- > From: Bogdan Stancescu [mailto:[EMAIL PROTECTED]] > Sent: 05 January 2002 00:12 > To: David Ayliffe > Cc: 'MySQL' > Subject: Re: OK - Simple Timestamps problem getting the better of me! > > 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