Question from newbie

Can anyone explain to me why the following command:

mysql>insert into main (foot_lib) values
(\pth\connectors\edge_connectors);

causes the following error:
--------------
insert into main (foot_lib) values (
--------------

ERROR:
Unknown command '\e'.
ERROR 1064 (42000): 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 'onnec
tors\edge_connectors)' at line 1
mysql>

Many thanks
NJH

Re: Question from newbie

"evillen" wrote in message
news:1140545806.800740.312150@g14g2000cwa.googlegroups.com.. .
> mysql>insert into main (foot_lib) values
> (\pth\connectors\edge_connectors);

String values must have quotes around them.

You might want to read a tutorial on SQL language.
Google for "mysql insert tutorial" and you will find many options.

You could also benefit from a book. "SQL for Dummies" is a good place to
start.
I'm not trying to be condescending -- it's really a good book!

Regards,
Bill K.

Re: Question from newbie

Thanks Bill, I'll look into getting a book. I have read the tutorial
that comes with the MySQL software, I must have missed the reference to
strings and quotes.

Bill Karwin wrote:
> "evillen" wrote in message
> news:1140545806.800740.312150@g14g2000cwa.googlegroups.com.. .
> > mysql>insert into main (foot_lib) values
> > (\pth\connectors\edge_connectors);
>
> String values must have quotes around them.
>
> You might want to read a tutorial on SQL language.
> Google for "mysql insert tutorial" and you will find many options.
>
> You could also benefit from a book. "SQL for Dummies" is a good place to
> start.
> I'm not trying to be condescending -- it's really a good book!
>
> Regards,
> Bill K.