Thanks, It worked :) On Mon, May 10, 2010 at 6:25 PM, Jay Ess <li...@netrogenic.com> 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.prab...@gmail.com > > -- 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
