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