14,982
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
m
→ERROR 1052 - Column 'column_name' in field list is ambiguous
(+ ERROR 1052) |
|||
| Line 210: | Line 210: | ||
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> | 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: | Solution: Remain only one table name 'column_name' OR adding the table name alias. | ||
== ERROR 1054 - Unknown column in 'where clause' == | == ERROR 1054 - Unknown column in 'where clause' == | ||