Jump to content


Photo

INSERTING


  • Please log in to reply
1 reply to this topic

#1 Anansie

Anansie
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 31 May 2003 - 09:00 PM

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.

#2 effigy

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
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users