15,013
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
m
→Err 1054 - Unknown column in 'where clause'
| Line 104: | Line 104: | ||
Solution: | Solution: | ||
# check the column name 'xxx' if exists | # check the column name 'xxx' if exists | ||
# if the column name 'xxx' was | # if the column name 'xxx' was computed by the [http://dev.mysql.com/doc/refman/5.7/en/example-user-variables.html User-Defined Variables]. Enclosed the whole query into another parent derived query. | ||
<pre> | <pre> | ||
-- The query which met the error message: [Err] 1054 - Unknown column 'rank' in 'where clause' | -- The query which met the error message: [Err] 1054 - Unknown column 'rank' in 'where clause' | ||