MySQL Error Codes

MySQL Error Codes: Complete reference of MySQL 8.0 server error codes (numeric codes like… Searchable index with fixes, code examples, and official sources.

12 error codes MySQL Last verified 2026-08-19

All 12 error codes

1062 Duplicate Entry Duplicate entry '%s' for key %s 1064 SQL Syntax Error %s near '%s' at line %s 1045 Access Denied for User Access denied for user '%s'@'%s' (using password: %s) 1146 Table Doesn't Exist Table '%s.%s' doesn't exist 1451 Foreign Key Constraint Fails on Delete or Update Cannot delete or update a parent row: a foreign key constraint fails (%s) 1452 Foreign Key Constraint Fails on Insert Cannot add or update a child row: a foreign key constraint fails (%s) 1048 Column Cannot Be Null Column '%s' cannot be null 1054 Unknown Column Unknown column '%s' in '%s' 1215 Cannot Add Foreign Key Constraint Cannot add foreign key constraint 1205 Lock Wait Timeout Exceeded Lock wait timeout exceeded; try restarting transaction 1213 Deadlock Found When Trying to Get Lock Deadlock found when trying to get lock; try restarting transaction 1364 Field Doesn't Have a Default Value Field '%s' doesn't have a default value

Official Sources