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