MySQL commands: Difference between revisions

Jump to navigation Jump to search
m
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'
Message: [Err] 1054 - Unknown column 'xxx' in 'where clause'


solution
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.

Navigation menu