42 error codes for the mysql platform
AkousaMySQL 1005MySQL cannot create the table due to a constraint or configuration error.
MySQL 1007The database cannot be created because it already exists.
MySQL 1044The user does not have access to the specified database.
MySQL 1045Authentication failed with the provided credentials.
MySQL 1049The specified database does not exist.
MySQL 1054The specified column does not exist in the table.
MySQL 1062An INSERT or UPDATE would create a duplicate value in a unique index.
MySQL 1064The SQL statement contains a syntax error.
MySQL 1146The referenced table does not exist in the database.
MySQL 1215MySQL cannot create the foreign key due to a definition mismatch.
MySQL 1217A foreign key constraint prevents deletion of a parent row.
MySQL 1264A numeric value exceeds the valid range for the column.
MySQL 1366The string contains characters invalid for the column's character set.
MySQL 1451A foreign key prevents modification of a referenced parent row.
MySQL 1452A foreign key prevents adding a child row because the parent does not exist.
MySQL 1213A deadlock was detected between concurrent transactions.
MySQL 1205A lock wait exceeded the configured timeout.
MySQL 2002MySQL client cannot connect through the local socket file.
MySQL 2003The client cannot establish a TCP connection to the server.
MySQL 2006The connection to the MySQL server was lost.
MySQL 2013The connection was lost during a query.
MySQL 1040The maximum number of MySQL connections has been exceeded.
MySQL 1114The table has reached its maximum size.
MySQL 1153The query or result exceeds max_allowed_packet.
MySQL 1227The operation requires a privilege the user does not have.
MySQL 1236The replication slave encountered an error reading the binary log.
MySQL 1048An INSERT or UPDATE tried to set a NOT NULL column to NULL.
MySQL 1060A column name appears more than once in the table definition.
MySQL 1071The index key length exceeds the storage engine maximum.
MySQL 1091The column or key to drop does not exist.
MySQL 1118The row size exceeds the storage engine maximum.
MySQL 1136The INSERT column count does not match the values count.
MySQL 1142The user lacks the required table-level privilege.
MySQL 1149The SQL statement contains a syntax error (legacy format).
MySQL 1292A value was truncated or is invalid during type conversion.
MySQL 1364A NOT NULL field was not given a value and has no default.
MySQL 1406The data value exceeds the column's maximum length.
MySQL 2014MySQL client commands are being issued out of order.
MySQL 1169A write to a unique index with IGNORE was skipped.
MySQL 1461The maximum number of prepared statements has been reached.
MySQL 1025An error occurred while renaming a table or dropping a foreign key.
MySQL 1065An empty query was sent to the MySQL server.