MySQL Forums
Forum List  »  Newbie

INSERT INTO ERROR 1054 (42S22): Unknown column 'Anderson' in 'field list'
Posted by: Josh Reardon
Date: July 12, 2012 06:17PM

I'm reading Head First SQL.

Tried WAMP, then built a LAMP (Sun) virutalbox.

mysql> INSERT INTO my_contacts (last_name, first_name, email, gender, birthday, profession, location, status, interests, seeking)
VALUES
(`Anderson`, `Jillian`, `jill_anderson@breakneckpizza.net`, `F`, `1980-09-05`, `Technical Writer`, `Palo Alto, CA`, `Single`, `Kayaking, Reptiles`, `Relationship, Friends`);

ERROR 1054 (42S22): Unknown column 'Anderson' in 'field list'

*** mate?
Single quote or ` backtick? Please elaborate on this.. I thought it was single quote but started reading like it should be back tick.

Much thanks in advance!

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.