List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:August 25 2006 3:02pm
Subject:Re: MySQL NOW() function producing 0000-00-00 00:00:00
View as plain text  
Doh.. Wrong email ;)

INSERT INTO a VALUES (NOW()) ?


Regards,
Chris.

----- Original Message ----- 
From: "Renato Golin" <renato@stripped>
To: "Chris Knipe" <savage@stripped>
Cc: <jeremiah.foster@stripped>; <mysql@stripped>
Sent: Friday, August 25, 2006 4:30 PM
Subject: Re: MySQL NOW() function producing 0000-00-00 00:00:00


> Chris Knipe wrote:
>> After patiently injecting at about 400 queries per seconds, a couple of 
>> hours later, I had about 5 million records in a table.  Not a single one 
>> of them experienced the above....
>
> It's one every 5 million and 1 entries... try again ;)
>
> Also, maybe (very improbable) it can be the way you are using NOW() within 
> the query. Can you show us the query ?
>
> cheers,
> --renato
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
> 

Thread
MySQL NOW() function producing 0000-00-00 00:00:00Jeremiah Foster25 Aug
  • Re: MySQL NOW() function producing 0000-00-00 00:00:00Renato Golin25 Aug
  • Re: MySQL NOW() function producing 0000-00-00 00:00:00Chris Knipe25 Aug
    • Re: MySQL NOW() function producing 0000-00-00 00:00:00Renato Golin25 Aug
  • Re: MySQL NOW() function producing 0000-00-00 00:00:00Chris Knipe25 Aug
    • Re: MySQL NOW() function producing 0000-00-00 00:00:00Renato Golin25 Aug
    • Re: Re: MySQL NOW() function producing 0000-00-00 00:00:00Dan Buettner25 Aug