Only thing I could guess is that at some point in your code you are executing:
INSERT INTO a VALUES ("NOW()")
instead, which for me on 5.0.21 results in 0000-00-00 00:00:00
Perhaps you have a function in your code that automatically
quotes/escapes data prior to inserting or updating... that would
likely do it.
Dan
On 8/25/06, Chris Knipe <[EMAIL PROTECTED]> wrote:
Doh.. Wrong email ;)
INSERT INTO a VALUES (NOW()) ?
Regards,
Chris.
----- Original Message -----
From: "Renato Golin" <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <mysql@lists.mysql.com>
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/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
