Jump to content

Archived

This topic is now archived and is closed to further replies.

Anansie

INSERTING

Recommended Posts

Hello!

I am learning how to use MySQL and i have this little problem with inserting values; after i type this:

 

INSERT INTO books (author, title) VALUES (`William Shakespeare`, `Hamlet`);

 

the message I receive is :

Unknown column `William Shakespeare` in `field list`.

 

What is wrong? I would appreciate if i receive a little help.

Share this post


Link to post
Share on other sites

try using single quotes, i think back quotes are just for table names.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.