Mysql Sql Error Codes
Contents |
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.5 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL mysql error php Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization
Mysql Errors And Solutions
Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax The InnoDB Storage Engine Alternative Storage
Mysql Sqlstate
Engines High Availability and Scalability Replication MySQL Cluster NDB 7.2 Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition
Mysql Error Code 1062
MySQL Workbench MySQL 5.5 Frequently Asked Questions Errors, Error Codes, and Common Problems Sources of Error Information Types of Error Values Server Error Codes and Messages Client Error Codes and Messages Problems and Common Errors How to Determine What Is Causing a Problem Common Errors When Using MySQL Programs Access denied Can't connect to [local] mysql errors log MySQL server Lost connection to MySQL server Client does not support authentication protocol Password Fails When Entered Interactively Host 'host_name' is blocked Too many connections Out of memory MySQL server has gone away Packet Too Large Communication Errors and Aborted Connections The table is full Can't create/write to file Commands out of sync Ignoring user Table 'tbl_name' doesn't exist Can't initialize character set File Not Found and Similar Errors Table-Corruption Issues Administration-Related Issues Problems with File Permissions How to Reset the Root Password What to Do If MySQL Keeps Crashing How MySQL Handles a Full Disk Where MySQL Stores Temporary Files How to Protect or Change the MySQL Unix Socket File Time Zone Problems Query-Related Issues Case Sensitivity in String Searches Problems Using DATE Columns Problems with NULL Values Problems with Column Aliases Rollback Failure for Nontransactional Tables Deleting Rows from Related Tables Solving Problems with No Matching Rows Problems with Floating-Point Values Optimizer-Related Issues Table Definition-Related Issues Problems with ALTER TABLE TEMPORARY Table Pro
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.5 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Tutorial mysql sqlstate 45000 MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization Language mysql codes list Structure Globalization Data Types Functions and Operators SQL Statement Syntax The InnoDB Storage Engine Alternative Storage Engines mysql codes for creating tables High Availability and Scalability Replication MySQL Cluster NDB 7.2 Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL https://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html Workbench MySQL 5.5 Frequently Asked Questions Errors, Error Codes, and Common Problems Sources of Error Information Types of Error Values Server Error Codes and Messages Client Error Codes and Messages Problems and Common Errors How to Determine What Is Causing a Problem Common Errors When Using MySQL Programs Access denied Can't connect to [local] MySQL server Lost https://dev.mysql.com/doc/refman/5.5/en/error-handling.html connection to MySQL server Client does not support authentication protocol Password Fails When Entered Interactively Host 'host_name' is blocked Too many connections Out of memory MySQL server has gone away Packet Too Large Communication Errors and Aborted Connections The table is full Can't create/write to file Commands out of sync Ignoring user Table 'tbl_name' doesn't exist Can't initialize character set File Not Found and Similar Errors Table-Corruption Issues Administration-Related Issues Problems with File Permissions How to Reset the Root Password What to Do If MySQL Keeps Crashing How MySQL Handles a Full Disk Where MySQL Stores Temporary Files How to Protect or Change the MySQL Unix Socket File Time Zone Problems Query-Related Issues Case Sensitivity in String Searches Problems Using DATE Columns Problems with NULL Values Problems with Column Aliases Rollback Failure for Nontransactional Tables Deleting Rows from Related Tables Solving Problems with No Matching Rows Problems with Floating-Point Values Optimizer-Related Issues Table Definition-Related Issues Problems with ALTER TABLE TEMPORARY Table Problems Known Issues in MySQL Restrict
Error Codes MySQL Error Codes Windows System Errors About this database This is a free public resource. It is https://www.briandunning.com/error-codes/?source=MySQL unmoderated and operates on the "public virtue" system. I hope http://www.fromdual.com/mysql-error-codes-and-messages-1600-1649 you find it useful! 1000SQLSTATE: HY000 (ER_HASHCHK) hashchk1001SQLSTATE: HY000 (ER_NISAMCHK) isamchk1002SQLSTATE: HY000 (ER_NO) NO1003SQLSTATE: HY000 (ER_YES) YES1004SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file '%s' (errno: %d)1005SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Can't create table '%s' (errno: %d)1006SQLSTATE: HY000 (ER_CANT_CREATE_DB) Can't create database '%s' (errno: %d)1007SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Can't sql error create database '%s'; database exists1008SQLSTATE: HY000 (ER_DB_DROP_EXISTS) Can't drop database '%s'; database doesn't exist1009SQLSTATE: HY000 (ER_DB_DROP_DELETE) Error dropping database (can't delete '%s', errno: %d)1010SQLSTATE: HY000 (ER_DB_DROP_RMDIR) Error dropping database (can't rmdir '%s', errno: %d)1011SQLSTATE: HY000 (ER_CANT_DELETE_FILE) Error on delete of '%s' (errno: %d)1012SQLSTATE: HY000 (ER_CANT_FIND_SYSTEM_REC) Can't read record in system table1013SQLSTATE: HY000 (ER_CANT_GET_STAT) Can't get mysql sql error status of '%s' (errno: %d)1014SQLSTATE: HY000 (ER_CANT_GET_WD) Can't get working directory (errno: %d)1015SQLSTATE: HY000 (ER_CANT_LOCK) Can't lock file (errno: %d)1016SQLSTATE: HY000 (ER_CANT_OPEN_FILE) Can't open file: '%s' (errno: %d)1017SQLSTATE: HY000 (ER_FILE_NOT_FOUND) Can't find file: '%s' (errno: %d)1018SQLSTATE: HY000 (ER_CANT_READ_DIR) Can't read dir of '%s' (errno: %d)1019SQLSTATE: HY000 (ER_CANT_SET_WD) Can't change dir to '%s' (errno: %d)1020SQLSTATE: HY000 (ER_CHECKREAD) Record has changed since last read in table '%s'1021SQLSTATE: HY000 (ER_DISK_FULL) Disk full (%s); waiting for someone to free some space...1022SQLSTATE: 23000 (ER_DUP_KEY) Can't write; duplicate key in table '%s'1023SQLSTATE: HY000 (ER_ERROR_ON_CLOSE) Error on close of '%s' (errno: %d)1024SQLSTATE: HY000 (ER_ERROR_ON_READ) Error reading file '%s' (errno: %d)1025SQLSTATE: HY000 (ER_ERROR_ON_RENAME) Error on rename of '%s' to '%s' (errno: %d)1026SQLSTATE: HY000 (ER_ERROR_ON_WRITE) Error writing file '%s' (errno: %d)1027SQLSTATE: HY000 (ER_FILE_USED) '%s' is locked against change1028SQLSTATE: HY000 (ER_FILSORT_ABORT) Sort aborted1029SQLSTATE: HY000 (ER_FORM_NOT_FOUND) View '%s' doesn't exist for '%s'1030SQLSTATE: HY000 (ER_GET_ERRNO) Got error %d from storage engine1031SQLSTATE: HY000 (ER_ILLEGAL_HA) Table storage engine for '%s' doesn't have this option1032SQLSTATE: HY000
Message: Creation context of view `%s`.`%s' is invalid Error: 1601 SQLSTATE: HY000 (ER_SR_INVALID_CREATION_CTX) Message: Creation context of stored routine `%s`.`%s` is invalid Error: 1602 SQLSTATE: HY000 (ER_TRG_CORRUPTED_FILE) Message: Corrupted TRG file for table `%s`.`%s` Error: 1603 SQLSTATE: HY000 (ER_TRG_NO_CREATION_CTX) Message: Triggers for table `%s`.`%s` have no creation context Error: 1604 SQLSTATE: HY000 (ER_TRG_INVALID_CREATION_CTX) Message: Trigger creation context of table `%s`.`%s` is invalid Error: 1605 SQLSTATE: HY000 (ER_EVENT_INVALID_CREATION_CTX) Message: Creation context of event `%s`.`%s` is invalid Error: 1606 SQLSTATE: HY000 (ER_TRG_CANT_OPEN_TABLE) Message: Cannot open table for trigger `%s`.`%s` Error: 1607 SQLSTATE: HY000 (ER_CANT_CREATE_SROUTINE) Message: Cannot create stored routine `%s`. Check warnings Error: 1608 SQLSTATE: HY000 (ER_NEVER_USED) Message: Ambiguous slave modes combination. %s Error: 1609 SQLSTATE: HY000 (ER_NO_FORMAT_DESCRIPTION_EVENT_BEFORE_BINLOG_STATEMENT) Message: The BINLOG statement of type `%s` was not preceded by a format description BINLOG statement. Error: 1610 SQLSTATE: HY000 (ER_SLAVE_CORRUPT_EVENT) Message: Corrupted replication event was detected Error: 1611 SQLSTATE: HY000 (ER_LOAD_DATA_INVALID_COLUMN) Message: Invalid column reference (%s) in LOAD DATA Error: 1612 SQLSTATE: HY000 (ER_LOG_PURGE_NO_FILE) Message: Being purged log %s was not found Error: 1613 SQLSTATE: XA106 (ER_XA_RBTIMEOUT) Message: XA_RBTIMEOUT: Transaction branch was rolled back: took too long Error: 1614 SQLSTATE: XA102 (ER_XA_RBDEADLOCK) Message: XA_RBDEADLOCK: Transaction branch was rolled back: deadlock was detected Error: 1615 SQLSTATE: HY000 (ER_NEED_REPREPARE) Message: Prepared statement needs to be re-prepared Error: 1616 SQLSTATE: HY000 (ER_DELAYED_NOT_SUPPORTED) Message: DELAYED option not supported for table '%s' Error: 1617 SQLSTATE: HY000 (WARN_NO_MASTER_INFO) Message: The master info structure does not exist Error: 1618 SQLSTATE: HY000 (WARN_OPTION_IGNORED) Message: <%s> option ignored Error: 1619 SQLSTATE: HY000 (WARN_PLUGIN_DELETE_BUILTIN) Message: Built-in plugins cannot be deleted Error: 1620 SQLSTATE: HY000 (WARN_PLUGIN_BUSY) Message: Plugin is busy and will be uninstalled on shutdown Error: 1621 SQLSTATE: HY000 (ER_VARIABLE_IS_READONLY) Message: %s variable '%s' is read-only. Use SET %s to assign the value Error: 1622 SQLSTATE: HY000 (E