MySQL Errors
Browse common MySQL error codes with clear explanations of what triggers each error and how to resolve it.
Connection
5Authentication & Authorization
7Query Syntax & Logic
6- 1054Unknown Column in 'field list'
- 1055SELECT list is not in GROUP BY clause and contains nonaggregated column; this is incompatible with sql_mode=only_full_group_by
- 1064You Have an Error in Your SQL Syntax
- 1093Can't Specify Target Table for Update in FROM Clause in MySQL
- 1111Invalid use of group function
- 1175You are using safe update mode
Table & Schema
2Data Integrity
15- 1048Column Cannot Be Null in MySQL
- 1062Duplicate Entry for Key in MySQL
- 1205Lock Wait Timeout Exceeded in MySQL
- 1213Deadlock found when trying to get lock
- 1215Cannot add foreign key constraint
- 1216Cannot add or update a child row: a foreign key constraint fails
- 1217Cannot delete or update a parent row
- 1264Out of Range Value for Column in MySQL
- 1267Illegal Mix of Collations in MySQL
- 1292Truncated Incorrect Value in MySQL
- 1364Field Doesn't Have a Default Value in MySQL
- 1366Incorrect String Value in MySQL
- 1406Data Too Long for Column in MySQL
- 1451Cannot delete or update a parent row
- 1452Cannot Add or Update a Child Row in MySQL