From: Eric Bergen
Date: June 27 2004 4:23pm
Subject: Re: insert into text field
List-Archive: http://lists.mysql.com/mysql/167973
Message-Id: <11b1bd9904062709237bc670d@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

desc is a reserved word. 
http://dev.mysql.com/doc/mysql/en/Reserved_words.html

In most cases to use desc as a column you will have to escape it with backticks 
like this `desc`.

-Eric

On Sat, 26 Jun 2004 16:19:37 +0530, Nitin <nitinmehta@stripped> wrote:
> 
> Hi all,
> 
> There's a problem. When I try to inert into table with
> 
> insert into schedule (owner, desc, sch_for, status) values ('a', 'b', 'c', 'd')
> 
> I get error
> 
> You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc, sch_for, status) values'
> 
> The desc field is of 'text' datatype. If that's the reason, what is the right syntax to insert into text field?
> 
> Please help me
> 
> Thanks in advance
>