Códigos de erro do MySQL
- 1045Access denied for user (using password: YES/NO)
- 1062Duplicate entry for key
- 1213Deadlock found when trying to get lock; try restarting transaction
- 1205Lock wait timeout exceeded; try restarting transaction
- 1040Too many connections
- 1064You have an error in your SQL syntax
- 1146Table doesn't exist
- 1054Unknown column in field list
- 2002Can't connect to local MySQL server through socket
- 2003Can't connect to MySQL server (TCP/IP)
- 2006MySQL server has gone away
- 1114The table is full
- 1215Cannot add foreign key constraint
- 1451Cannot delete or update a parent row: a foreign key constraint fails
- 1452Cannot add or update a child row: a foreign key constraint fails
- 1366Incorrect string/integer value for column
- 1044Access denied for user to database
- 1264Out of range value for column
- 1052Column 'x' in field list is ambiguous
- 1136Column count doesn't match value count
- 1048Column 'x' cannot be null
- 1292Incorrect datetime value / truncated incorrect value
- 1406Data too long for column
- 1071Specified key was too long; max key length is 767 bytes
- 1050Table already exists
- 1051Unknown table 'x'
- 1091Can't DROP 'x'; check that column/key exists
- 1093You can't specify target table 'x' for update in FROM clause
- 1305PROCEDURE does not exist
- 1227Access denied; you need (at least one of) the PRIVILEGE
- 3730Cannot drop table referenced by a foreign key constraint
- 2013Lost connection to MySQL server during query
- 1153Got a packet bigger than 'max_allowed_packet' bytes
- 1969MariaDB: Query execution was interrupted (max_statement_time exceeded)
- 1927MariaDB: ER_CONNECTION_KILLED: Connection was killed (a conexão foi encerrada)
- 1290ER_OPTION_PREVENTS_STATEMENT: running with the --read-only option (em execução com a opção --read-only)
- 1836ER_READ_ONLY_MODE: Running in read-only mode (em execução no modo somente leitura)
- 3819ER_CHECK_CONSTRAINT_VIOLATED: Check constraint is violated (a constraint CHECK foi violada)
- 1118ER_TOO_BIG_ROWSIZE: Row size too large
- 1170ER_BLOB_KEY_WITHOUT_LENGTH: BLOB/TEXT column used in key specification without a key length (coluna BLOB/TEXT usada em uma chave sem comprimento de chave)
- 1592ER_BINLOG_UNSAFE_STATEMENT: Unsafe statement written to the binary log (comando inseguro gravado no binary log)
- 3140ER_INVALID_JSON_TEXT: Invalid JSON text
- 1526ER_NO_PARTITION_FOR_GIVEN_VALUE: Table has no partition for value (a tabela não tem nenhuma partição para o valor)
- 1049Unknown database 'name'
- 1364Field 'name' doesn't have a default value (o campo não tem valor padrão)
- 1206The total number of locks exceeds the lock table size (o número total de locks excede o tamanho da tabela de locks)
- 1236Got fatal error 1236 from master when reading data from binary log (erro fatal 1236 do master ao ler o binary log)
- 1129Host 'host' is blocked because of many connection errors (host bloqueado por excesso de erros de conexão)
- 1194Table 'name' is marked as crashed and should be repaired (tabela marcada como corrompida; deve ser reparada)
- 1615Prepared statement needs to be re-prepared (o prepared statement precisa ser preparado novamente)
- 1553Cannot drop index needed in a foreign key constraint (não é possível remover um índice exigido por uma constraint de foreign key)
- 3948Loading local data is disabled; this must be enabled on both the client and server sides (o carregamento de dados locais está desabilitado; deve ser habilitado no cliente e no servidor)
- 1075Incorrect table definition; there can be only one auto column and it must be defined as a key (definição de tabela incorreta; só pode haver uma coluna automática e ela deve ser definida como chave)
- 1055Expression not in GROUP BY (only_full_group_by) (expressão que não está no GROUP BY)
- 1267Illegal mix of collations
- 1030Got error N from storage engine
- 1197Multi-statement transaction required more than 'max_binlog_cache_size' (a transação com vários comandos exigiu mais que 'max_binlog_cache_size')
- 1785Statement violates GTID consistency
- 3024Query execution was interrupted, maximum statement execution time exceeded (execução da consulta interrompida; tempo máximo de execução excedido)
- 1298Unknown or incorrect time zone
- 1418Function has none of DETERMINISTIC, NO SQL, or READS SQL DATA (binary logging enabled) (a função não tem DETERMINISTIC, NO SQL nem READS SQL DATA)
- 1231Variable can't be set to the value of ... (não é possível atribuir esse valor à variável)