14,982
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
+ ERROR 1052
(+ ERROR 1052) |
|||
| Line 204: | Line 204: | ||
Solution: [[SQL syntax debug]] | Solution: [[SQL syntax debug]] | ||
== ERROR 1052 - Column 'column_name' in field list is ambiguous == | |||
Message: Error Code: 1052. Column 'column_name' in field list is ambiguous | |||
Cause: Since 'column_name' is present in 2 or more tables ...<ref>[https://stackoverflow.com/questions/19351633/error-code-1052-column-admin-id-in-field-list-is-ambiguous mysql - Error Code: 1052 Column 'admin_id' in field list is ambiguous - Stack Overflow]</ref> | |||
Solution: Add table name alias. | |||
== ERROR 1054 - Unknown column in 'where clause' == | == ERROR 1054 - Unknown column in 'where clause' == | ||