From: Prabhat Kumar
Date: May 10 2010 1:50pm
Subject: Re: Out of range value for column 'datestamp' at row 1
List-Archive: http://lists.mysql.com/mysql/221543
Message-Id: <AANLkTimJyPSP4o3KhNbvklEMMU2SR6V6qhZyLU1TttKX@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0016362841ec61076504863db1ad

--0016362841ec61076504863db1ad
Content-Type: text/plain; charset=ISO-8859-1

Thanks, It worked :)

On Mon, May 10, 2010 at 6:25 PM, Jay Ess <lists@stripped> wrote:

> On 2010-05-09 13:29, Prabhat Kumar wrote:
>
>> INSERT INTO myTable_info (id,range, total_qt, qt_correct, finish_time,
>> username, datestamp) VALUES (NULL,'Kumar', '20', '17', '111', 'Prabhat','*
>> NOW()');*
>>
>> Last_SQL_Error: Error 'You have an error in your SQL syntax; check the
>> manual that corresponds to your MySQL server version for the right syntax
>>
>> I think problem with* `datestamp` datetime NOT NULL default '0000-00-00
>> 00:00:00',*
>>
>> Can any one please suggest me, how to deal with this error.
>>
>>
> Remove the ' around NOW(). ' Makes NOW() a literal string and not a
> function call.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prabhat@stripped
>
>


-- 
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile     : 91-9987681929
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

--0016362841ec61076504863db1ad--