MySQL - Error 1054 : Unknown column in 'field list' when column actually exists.
I have a simple update query that is failing with the following errror...
Error 1054 : Unknown column 'Display' in 'field list'
The column does exist in the database and I have checked to make sure there are no spaces or anything quirky like that going on. I have tried moving, dropping, and re-creating the columns with no success. I am using MySQL version 5.6.17 The code that produces the error is as follows...
2. Do you use column permissions at all?
3. What happens if you run a query to show the columns?
Open in new window
What's the output there?