MySQL Forums
Forum List  »  Newbie

Error 1054
Posted by: Donna Worley
Date: December 07, 2018 09:23AM

I keep getting Error 1054 "Unknown Column" on the below in MySQL Workbench. My Customer table is already set up. I was getting syntax errors earlier when there were spaces in my text so I removed them. What am I doing wrong?

insert into Customer
values (1,‘ContemporaryCasuals’,‘1355S.HinesBlvd.’,‘Gainesville’,‘FL’,32601);
insert into Customer
values (2, ‘ValueFurniture’,‘15145S.W.17thSt.’,‘Plano’,‘TX’,75094);
insert into Customer
values (3, ‘HomeFurnishings’,‘1900AllardAve.’,‘Albany’,‘NY’,12209);
insert into Customer
values (4, ‘EasternFurniture’,‘1925BeltlineRd.’,‘Carteret’,‘NJ’,07008);
insert into Customer
values (5, ‘Impressions’,‘5595WestcottCt.’,‘Sacramento’,‘CA’,94206);
insert into Customer
values (6, ‘FurnitureGallery’, ‘325FlatironDr.’,‘Boulder’,‘CO’,80514);

Options: ReplyQuote


Subject
Written By
Posted
Error 1054
December 07, 2018 09:23AM
December 07, 2018 12:43PM
December 07, 2018 02:22PM


Sorry, only registered users may post in this forum.

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.