MySQL Forums
Forum List  »  MySQL Workbench

Re: MySQL Workbench Error Code 1054
Posted by: J C
Date: July 15, 2022 10:23AM

Hello,

I am having an issue with MySQL Community Server Workbench. I input this command on MySQL File Queries and get this error

Command:
use CIA_DATA;

SELECT * FROM new_table;

SELECT Country, GDP, Electricity;
FROM new_table;
WHERE GDP < 4000;
ORDER BY Electricity;

select now(); database();

Error:
22:03:14 SELECT Country, GDP, Electricity LIMIT 0, 50000 Error Code: 1054. Unknown column 'Country' in 'field list' 0.000 sec


Please let me know what mistakes I have made. Keep in mind that my Result Grid has these field names/columns:
Water, Sanitation, GDP, Life, Underweight, Literacy, Electricity, Country

Thanks,
J C

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Workbench Error Code 1054
1280
J C
July 15, 2022 10:23AM


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.