Jump to content



  • Please log in to reply
1 reply to this topic

#1 Anansie

  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 31 May 2003 - 09:00 PM

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.

#2 effigy

  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 31 May 2003 - 09:27 PM

try using single quotes, i think back quotes are just for table names.
Regexp | Unicode Article | Letter Database

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users