文档介绍:This chapter lists the errors that may appear when you call MySQL from any host language The first list displays server error messages The second list displays client program messages
Server error information comes from the following files:
The Error values and the symbols in parentheses correspond to definitions in the include/mysqld_errorh MySQL source file
The SQLSTATE values correspond to definitions in the include/sql_stateh MySQL source file
SQLSTATE error codes are displayed only if you use MySQL version 41 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 sql/share/english/errmsgtxt file %d or %s represent numbers or strings that are substituted into the messages %when they are displayed
Because updates are frequent, it is possible that these files contain additional error information not listed here
Error: 1000 SQLSTATE: HY000 (ER_HASHCHK)
Message: hashchk
Error: 1001 SQLSTATE: HY000 (ER_NISAMCHK)
Message: isamchk
Error: 1002 SQLSTATE: HY000 (ER_NO)
Message: NO
Error: 1003 SQLSTATE: HY000 (ER_YES)
Message: YES
Error: 1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE)
Message: Can't create file '%s' (errno: %d)
Error: 1005 SQLSTATE: HY000 (ER_CANT_CREATE_TABLE)
Message: Can't create table '%s' (errno: %d)
Error: 1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB)
Message: Can't create database '%s' (errno: %d)
Error: 1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS)
Message: Can't create database '%s'; database exists
Error: 1008 SQLSTATE: HY000 (ER_DB_DROP_EXISTS)
Message: Can't drop database '%s'; database doesn't exist
Error: 1009 SQLSTATE: HY000 (ER_DB_DROP_DELETE)
Message: Error dropping database (can't delete '%s', errno: %d)
Error: 1010 SQLSTATE: HY000 (ER_DB_DROP_RMDIR)
Message: Error dropping database (can't rmdir '%s', errno: %d)
Error: 1011 SQLSTATE: HY000 (ER_CANT_DELETE_FILE)
Message: Error on d