Question from newbie

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Can anyone explain to me why the following command:

mysql>insert into main (foot_lib) values

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

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

Many thanks

Re: Question from newbie

Quoted text here. Click to load it

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
I'm not trying to be condescending -- it's really a good book!

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:
Quoted text here. Click to load it

Site Timeline