Spaces were not the problem here. "desc" is a reserved word, which makes it
a poor choice for a column name, as you'll have to quote it with backticks
(~) every time you use it.
Michael
Nitin wrote:
> Solved.
>
>
> ----- Original Message -----
> From: <mysql-list-replies@stripped>
> To: "Nitin" <nitinmehta@stripped>
> Sent: Saturday, June 26, 2004 4:33 PM
> Subject: Re: insert into text field
>
>
>
>>look *carefully* at the insert syntax, paying attention to spaces and
>>the like:
>>
>> INSERT INTO tbl_name () VALUES()
>>
>>the error message gives a good hint too.
>>
>>---------- Original Message ----------
>>
>>>From: Nitin <nitinmehta@stripped>
>>>To: MySQL Mailing List <mysql@stripped>
>>>Date: Saturday, June 26, 2004 04:19:37 PM +0530
>>>Subject: insert into text field
>>>
>>>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
>>
>>---------- End Original Message ----------
>>
>
>
>
