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
Subject
Views
Written By
Posted
Re: MySQL Workbench Error Code 1054
1999
July 15, 2022 10:23AM
634
July 15, 2022 08:16PM
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.