15,013
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
m
→Err 1054 - Unknown column in 'where clause'
| Line 100: | Line 100: | ||
==== Err 1054 - Unknown column in 'where clause' ==== | ==== Err 1054 - Unknown column in 'where clause' ==== | ||
Message: [Err] 1054 - Unknown column 'xxx' in 'where clause' | |||
Solution: | |||
# check the column name 'xxx' if exists | # check the column name 'xxx' if exists | ||
# if the column name 'xxx' was combined 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. | # if the column name 'xxx' was combined 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. | ||