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 <[EMAIL PROTECTED]> 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
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
