Mysql Sqlstate 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 Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization Language mysql error codes and messages Structure Globalization Data Types Functions and Operators SQL Statement Syntax The InnoDB Storage mysql error php Engine Alternative Storage Engines High Availability and Scalability Replication MySQL Cluster NDB 7.2 Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL mysql errors and solutions Performance Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.5 Frequently Asked Questions Errors, Error Codes, and Common Problems Sources of Error Information Types of Error Values Server Error mysql errors log 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 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
Mysql Error Code 1062
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 Restrictions and Limits Indexes MySQL Glossary Related Documentation MySQL 5.5 Release Notes Download this Manual PDF (US Ltr) - 26.7Mb PDF (A4) - 26.7Mb PDF (RPM) - 25.8Mb EPUB - 6.7Mb HTML Download (TGZ) - 6.4Mb HTML Download (Zip) - 6.5Mb HTML Download (RPM) - 5.5Mb Eclipse Doc Plugin (TGZ) - 7.1Mb Eclipse Doc Plugin (Zip) - 8.8Mb Man Pages (TGZ) - 165.9Kb Man Pages (Zip
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General
Mysql Sqlstate 45000
Information Installing and Upgrading MySQL Using MySQL as a Document mysql codes list Store Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization Language Structure Globalization mysql codes for creating tables Data Types Functions and Operators SQL Statement Syntax The InnoDB Storage Engine Alternative Storage Engines High Availability and Scalability Replication MySQL Cluster NDB 7.5 https://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema MySQL sys Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.7 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 http://dev.mysql.com/doc/en/error-messages-server.html 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 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 Proble
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 you find it useful! 1000SQLSTATE: HY000 (ER_HASHCHK) hashchk1001SQLSTATE: HY000 (ER_NISAMCHK) isamchk1002SQLSTATE: HY000 (ER_NO) NO1003SQLSTATE: HY000 (ER_YES) YES1004SQLSTATE: HY000 http://ftp.nchu.edu.tw/MySQL/doc/refman/4.1/en/error-messages-server.html (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 create database mysql error '%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 status of mysql error code '%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 (ER_KEY_NOT_FOUND) Can't find record in '%s'10
Documentation Library Table of Contents MySQL 5.5 Manual MySQL 5.4 Manual MySQL 5.1 Manual MySQL 5.0 Manual MySQL 3.23/4.0/4.1 Manual Search manual: MySQL 3.23, 4.0, 4.1 Reference Manual :: A Errors, Error Codes, and Common Problems :: A.3 Server Error Codes and Messages « A.2 Types of Error Values A.4 Client Error Codes and Messages » Section Navigation [Toggle] A Errors, Error Codes, and Common ProblemsA.1 Sources of Error Information A.2 Types of Error Values A.3 Server Error Codes and Messages A.4 Client Error Codes and Messages A.5 Problems and Common Errors A.3. Server Error Codes and Messages MySQL programs have access to several types of error information when the server returns an error. For example, the mysql client program displays errors using the following format: shell> /UdmComment0 ERROR 1146 (42S02): Table 'test.no_such_table' doesn't exist The message displayed contains three types of information: A numeric error code (UdmComment9). This number is MySQL-specific and is not portable to other database systems. A five-character SQLSTATE value (UdmComment8). The values are specified by ANSI SQL and ODBC and are more standardized. Not all MySQL error numbers are mapped to SQLSTATE error codes. The value UdmComment7 (general error) is used for unmapped errors. A message string that provides a textual description of the error. Server error information comes from the following source files. For details about the way that error information is defined, see the MySQL Internals manual, available at http://dev.mysql.com/doc/. The Error values and the symbols in parentheses correspond to definitions in the UdmComment6 MySQL source file. The SQLSTATE values correspond to definitions in the UdmComment5 MySQL source file. SQLSTATE error codes are displayed only if you use MySQL version 4.1 and up. SQLSTATE codes were added for compatibility with X/Open, ANSI, and ODBC behavior. The Message values correspond to the error messages that are listed in the UdmComment4 file. UdmComment3 and UdmComment2 represent numbers and strings, respectively, that are substituted into the messages when they are displayed. Because updates are frequent, it is possible that those files will contain additional error information not listed here. Error: UdmComment1 SQLSTATE: UdmComment0 (UdmComment9) Message: hashchk Error: UdmComment8 SQLSTATE: UdmComment7 (U