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.
php学习之家http://www.444p.com
Server error information comes from the following files: www.444p.com版权所有
The Error values and the symbols in parentheses correspond to definitions in the include/mysqld_error.h MySQL source file.
The SQLSTATE values correspond to definitions in the include/sql_state.h MySQL source file. www.444p.com php学习之家
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. php学习之家http://www.444p.com
The Message values correspond to the error messages that are listed in the sql/share/english/errmsg.txt file. %d or %s represent numbers or strings that are substituted into the messages %when they are displayed.
www.444p.com版权所有
Because updates are frequent, it is possible that these files contain additional error information not listed here. www.444p.com
Error: 1000 SQLSTATE: HY000 (ER_HASHCHK) php学习之家
Message: hashchk php学习之家
Error: 1001 SQLSTATE: HY000 (ER_NISAMCHK)
www.444p.com版权所有
Message: isamchk
Error: 1002 SQLSTATE: HY000 (ER_NO) www.444p.com
Message: NO
Error: 1003 SQLSTATE: HY000 (ER_YES)
Message: YES
php学习之家http://www.444p.com
Error: 1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) php学习之家http://www.444p.com
Message: Can't create file '%s' (errno: %d) php学习之家http://www.444p.com
Error: 1005 SQLSTATE: HY000 (ER_CANT_CREATE_TABLE)
Message: Can't create table '%s' (errno: %d)
本文来自 www.444p.com
Error: 1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) php学习之家http://www.444p.com
Message: Can't create database '%s' (errno: %d) php学习之家
Error: 1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) 本文来自 www.444p.com
Message: Can't create database '%s'; database exists www.444p.com
Error: 1008 SQLSTATE: HY000 (ER_DB_DROP_EXISTS)
Message: Can't drop datebase '%s'; database doesn't exist
Error: 1009 SQLSTATE: HY000 (ER_DB_DROP_DELETE)
php学习之家http://www.444p.com
Message: Error dropping database (can't delete '%s', errno: %d) 本文来自 www.444p.com
Error: 1010 SQLSTATE: HY000 (ER_DB_DROP_RMDIR) php学习之家http://www.444p.com
Message: Error dropping database (can't rmdir '%s', errno: %d) php学习之家
Error: 1011 SQLSTATE: HY000 (ER_CANT_DELETE_FILE)
Message: Error on delete of '%s' (errno: %d)
Error: 1012 SQLSTATE: HY000 (ER_CANT_FIND_SYSTEM_REC)
本文来自 www.444p.com
Message: Can't read record in system table
php学习之家http://www.444p.com
Error: 1013 SQLSTATE: HY000 (ER_CANT_GET_STAT)
Message: Can't get status of '%s' (errno: %d)
php学习之家http://www.444p.com
Error: 1014 SQLSTATE: HY000 (ER_CANT_GET_WD)
Message: Can't get working directory (errno: %d)
Error: 1015 SQLSTATE: HY000 (ER_CANT_LOCK)
本文来自 www.444p.com
Message: Can't lock file (errno: %d)
Error: 1016 SQLSTATE: HY000 (ER_CANT_OPEN_FILE) php学习之家
Message: Can't open file: '%s' (errno: %d)
php学习之家
Error: 1017 SQLSTATE: HY000 (ER_FILE_NOT_FOUND) php学习之家
Message: Can't find file: '%s' (errno: %d)
www.444p.com版权所有
Error: 1018 SQLSTATE: HY000 (ER_CANT_READ_DIR)
php学习之家
Message: Can't read dir of '%s' (errno: %d)
Error: 1019 SQLSTATE: HY000 (ER_CANT_SET_WD) www.444p.com
Message: Can't change dir to '%s' (errno: %d) php学习之家http://www.444p.com
Error: 1020 SQLSTATE: HY000 (ER_CHECKREAD) www.444p.com php学习之家
Message: Record has changed since last read in table '%s'
Error: 1021 SQLSTATE: HY000 (ER_DISK_FULL) www.444p.com版权所有
Message: Disk full (%s); waiting for someone to free some space... 本文来自 www.444p.com
Error: 1022 SQLSTATE: 23000 (ER_DUP_KEY) 本文来自 www.444p.com
Message: Can't write; duplicate key in table '%s' 本文来自 www.444p.com
Error: 1023 SQLSTATE: HY000 (ER_ERROR_ON_CLOSE)
php学习之家
Message: Error on close of '%s' (errno: %d)
Error: 1024 SQLSTATE: HY000 (ER_ERROR_ON_READ)
Message: Error reading file '%s' (errno: %d)
Error: 1025 SQLSTATE: HY000 (ER_ERROR_ON_RENAME) www.444p.com
Message: Error on rename of '%s' to '%s' (errno: %d)
Error: 1026 SQLSTATE: HY000 (ER_ERROR_ON_WRITE) www.444p.com
Message: Error writing file '%s' (errno: %d)
Error: 1027 SQLSTATE: HY000 (ER_FILE_USED)
Message: '%s' is locked against change
www.444p.com
Error: 1028 SQLSTATE: HY000 (ER_FILSORT_ABORT) www.444p.com php学习之家
Message: Sort aborted www.444p.com php学习之家
Error: 1029 SQLSTATE: HY000 (ER_FORM_NOT_FOUND)
本文来自 www.444p.com
Message: View '%s' doesn't exist for '%s'
Error: 1030 SQLSTATE: HY000 (ER_GET_ERRNO) php学习之家
Message: Got error %d from storage engine www.444p.com版权所有
Error: 1031 SQLSTATE: HY000 (ER_ILLEGAL_HA) www.444p.com
Message: Table storage engine for '%s' doesn't have this option php学习之家
Error: 1032 SQLSTATE: HY000 (ER_KEY_NOT_FOUND) php学习之家http://www.444p.com
Message: Can't find record in '%s' php学习之家
Error: 1033 SQLSTATE: HY000 (ER_NOT_FORM_FILE) php学习之家
Message: Incorrect information in file: '%s' www.444p.com php学习之家
Error: 1034 SQLSTATE: HY000 (ER_NOT_KEYFILE)
本文来自 www.444p.com
Message: Incorrect key file for table '%s'; try to repair it www.444p.com php学习之家
Error: 1035 SQLSTATE: HY000 (ER_OLD_KEYFILE)
Message: Old key file for table '%s'; repair it!
Error: 1036 SQLSTATE: HY000 (ER_OPEN_AS_READONLY) php学习之家
Message: Table '%s' is read only 本文来自 www.444p.com
Error: 1037 SQLSTATE: HY001 (ER_OUTOFMEMORY) php学习之家http://www.444p.com
Message: Out of memory; restart server and try again (needed %d bytes) 本文来自 www.444p.com
Error: 1038 SQLSTATE: HY001 (ER_OUT_OF_SORTMEMORY) www.444p.com
Message: Out of sort memory; increase server sort buffer size
本文来自 www.444p.com
Error: 1039 SQLSTATE: HY000 (ER_UNEXPECTED_EOF) 本文来自 www.444p.com
Message: Unexpected EOF found when reading file '%s' (errno: %d) 本文来自 www.444p.com
Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR) www.444p.com php学习之家
Message: Too many connections www.444p.com版权所有
Error: 1041 SQLSTATE: HY000 (ER_OUT_OF_RESOURCES) www.444p.com版权所有
Message: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space www.444p.com
Error: 1042 SQLSTATE: 08S01 (ER_BAD_HOST_ERROR)
Message: Can't get hostname for your address www.444p.com版权所有
Error: 1043 SQLSTATE: 08S01 (ER_HANDSHAKE_ERROR) php学习之家http://www.444p.com
Message: Bad handshake www.444p.com
Error: 1044 SQLSTATE: 42000 (ER_DBACCESS_DENIED_ERROR)
Message: Access denied for user '%s'@'%s' to database '%s' www.444p.com
Error: 1045 SQLSTATE: 28000 (ER_ACCESS_DENIED_ERROR)
Message: Access denied for user '%s'@'%s' (using password: %s)
Error: 1046 SQLSTATE: 3D000 (ER_NO_DB_ERROR) www.444p.com
Message: No database selected php学习之家
Error: 1047 SQLSTATE: 08S01 (ER_UNKNOWN_COM_ERROR)
Message: Unknown command
Error: 1048 SQLSTATE: 23000 (ER_BAD_NULL_ERROR)
Message: Column '%s' cannot be null
www.444p.com
Error: 1049 SQLSTATE: 42000 (ER_BAD_DB_ERROR) php学习之家
Message: Unknown database '%s'
Error: 1050 SQLSTATE: 42S01 (ER_TABLE_EXISTS_ERROR)
Message: Table '%s' already exists www.444p.com
Error: 1051 SQLSTATE: 42S02 (ER_BAD_TABLE_ERROR)
Message: Unknown table '%s'
Error: 1052 SQLSTATE: 23000 (ER_NON_UNIQ_ERROR)
Message: Column '%s' in %s is ambiguous
Error: 1053 SQLSTATE: 08S01 (ER_SERVER_SHUTDOWN) php学习之家
Message: Server shutdown in progress www.444p.com
Error: 1054 SQLSTATE: 42S22 (ER_BAD_FIELD_ERROR) php学习之家
Message: Unknown column '%s' in '%s' www.444p.com版权所有
Error: 1055 SQLSTATE: 42000 (ER_WRONG_FIELD_WITH_GROUP) php学习之家http://www.444p.com
Message: '%s' isn't in GROUP BY www.444p.com版权所有
Error: 1056 SQLSTATE: 42000 (ER_WRONG_GROUP_FIELD) php学习之家
Message: Can't group on '%s' www.444p.com
Error: 1057 SQLSTATE: 42000 (ER_WRONG_SUM_SELECT) php学习之家http://www.444p.com
Message: Statement has sum functions and columns in same statement www.444p.com php学习之家
Error: 1058 SQLSTATE: 21S01 (ER_WRONG_VALUE_COUNT) php学习之家http://www.444p.com
Message: Column count doesn't match value count www.444p.com
Error: 1059 SQLSTATE: 42000 (ER_TOO_LONG_IDENT)
www.444p.com
Message: Identifier name '%s' is too long php学习之家http://www.444p.com
Error: 1060 SQLSTATE: 42S21 (ER_DUP_FIELDNAME) www.444p.com
Message: Duplicate column name '%s' www.444p.com版权所有
Error: 1061 SQLSTATE: 42000 (ER_DUP_KEYNAME)
www.444p.com
Message: Duplicate key name '%s'
Error: 1062 SQLSTATE: 23000 (ER_DUP_ENTRY) www.444p.com
Message: Duplicate entry '%s' for key %d www.444p.com版权所有
Error: 1063 SQLSTATE: 42000 (ER_WRONG_FIELD_SPEC) www.444p.com php学习之家
Message: Incorrect column specifier for column '%s' www.444p.com php学习之家
Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR)
Message: %s near '%s' at line %d www.444p.com
Error: 1065 SQLSTATE: 42000 (ER_EMPTY_QUERY)
Message: Query was empty php学习之家http://www.444p.com
Error: 1066 SQLSTATE: 42000 (ER_NONUNIQ_TABLE) 本文来自 www.444p.com
Message: Not unique table/alias: '%s' 本文来自 www.444p.com
Error: 1067 SQLSTATE: 42000 (ER_INVALID_DEFAULT) php学习之家
Message: Invalid default value for '%s' 本文来自 www.444p.com
Error: 1068 SQLSTATE: 42000 (ER_MULTIPLE_PRI_KEY)
Message: Multiple primary key defined
Error: 1069 SQLSTATE: 42000 (ER_TOO_MANY_KEYS) www.444p.com版权所有
Message: Too many keys specified; max %d keys allowed
php学习之家http://www.444p.com
Error: 1070 SQLSTATE: 42000 (ER_TOO_MANY_KEY_PARTS)
www.444p.com版权所有
Message: Too many key parts specified; max %d parts allowed php学习之家http://www.444p.com
Error: 1071 SQLSTATE: 42000 (ER_TOO_LONG_KEY)
php学习之家http://www.444p.com
Message: Specified key was too long; max key length is %d bytes www.444p.com php学习之家
Error: 1072 SQLSTATE: 42000 (ER_KEY_COLUMN_DOES_NOT_EXITS)
Message: Key column '%s' doesn't exist in table
Error: 1073 SQLSTATE: 42000 (ER_BLOB_USED_AS_KEY)
Message: BLOB column '%s' can't be used in key specification with the used table type
本文来自 www.444p.com
Error: 1074 SQLSTATE: 42000 (ER_TOO_BIG_FIELDLENGTH) www.444p.com
Message: Column length too big for column '%s' (max = %d); use BLOB instead php学习之家http://www.444p.com
Error: 1075 SQLSTATE: 42000 (ER_WRONG_AUTO_KEY)
Message: Incorrect table definition; there can be only one auto column and it must be defined as a key www.444p.com php学习之家
Error: 1076 SQLSTATE: HY000 (ER_READY)
Message: %s: ready for connections. Version: '%s' socket: '%s' port: %d
Error: 1077 SQLSTATE: HY000 (ER_NORMAL_SHUTDOWN) www.444p.com
Message: %s: Normal shutdown
Error: 1078 SQLSTATE: HY000 (ER_GOT_SIGNAL) php学习之家
Message: %s: Got signal %d. Aborting!
Error: 1079 SQLSTATE: HY000 (ER_SHUTDOWN_COMPLETE)
Message: %s: Shutdown complete php学习之家
Error: 1080 SQLSTATE: 08S01 (ER_FORCING_CLOSE) www.444p.com
Message: %s: Forcing close of thread %ld user: '%s'
本文来自 www.444p.com
Error: 1081 SQLSTATE: 08S01 (ER_IPSOCK_ERROR)
本文来自 www.444p.com
Message: Can't create IP socket www.444p.com版权所有
Error: 1082 SQLSTATE: 42S12 (ER_NO_SUCH_INDEX)
Message: Table '%s' has no index like the one used in CREATE INDEX; recreate the table 本文来自 www.444p.com
Error: 1083 SQLSTATE: 42000 (ER_WRONG_FIELD_TERMINATORS) php学习之家http://www.444p.com
Message: Field separator argument is not what is expected; check the manual
Error: 1084 SQLSTATE: 42000 (ER_BLOBS_AND_NO_TERMINATED)
www.444p.com
Message: You can't use fixed rowlength with BLOBs; please use 'fields terminated by' www.444p.com
Error: 1085 SQLSTATE: HY000 (ER_TEXTFILE_NOT_READABLE) www.444p.com
Message: The file '%s' must be in the database directory or be readable by all
Error: 1086 SQLSTATE: HY000 (ER_FILE_EXISTS_ERROR)
Message: File '%s' already exists www.444p.com
Error: 1087 SQLSTATE: HY000 (ER_LOAD_INFO)
Message: Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld
Error: 1088 SQLSTATE: HY000 (ER_ALTER_INFO)
php学习之家
Message: Records: %ld Duplicates: %ld
Error: 1089 SQLSTATE: HY000 (ER_WRONG_SUB_KEY) www.444p.com
Message: Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys php学习之家
Error: 1090 SQLSTATE: 42000 (ER_CANT_REMOVE_ALL_FIELDS)
Message: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
Error: 1091 SQLSTATE: 42000 (ER_CANT_DROP_FIELD_OR_KEY) www.444p.com php学习之家
Message: Can't DROP '%s'; check that column/key exists
Error: 1092 SQLSTATE: HY000 (ER_INSERT_INFO) php学习之家http://www.444p.com
Message: Records: %ld Duplicates: %ld Warnings: %ld 本文来自 www.444p.com
Error: 1093 SQLSTATE: HY000 (ER_UPDATE_TABLE_USED)
Message: You can't specify target table '%s' for update in FROM clause
Error: 1094 SQLSTATE: HY000 (ER_NO_SUCH_THREAD)
Message: Unknown thread id: %lu
Error: 1095 SQLSTATE: HY000 (ER_KILL_DENIED_ERROR)
Message: You are not owner of thread %lu
www.444p.com
Error: 1096 SQLSTATE: HY000 (ER_NO_TABLES_USED)
Message: No tables used
Error: 1097 SQLSTATE: HY000 (ER_TOO_BIG_SET) www.444p.com版权所有
Message: Too many strings for column %s and SET
php学习之家
Error: 1098 SQLSTATE: HY000 (ER_NO_UNIQUE_LOGFILE)
Message: Can't generate a unique log-filename %s.(1-999) www.444p.com
Error: 1099 SQLSTATE: HY000 (ER_TABLE_NOT_LOCKED_FOR_WRITE)
Message: Table '%s' was locked with a READ lock and can't be updated
php学习之家
Error: 1100 SQLSTATE: HY000 (ER_TABLE_NOT_LOCKED)
本文来自 www.444p.com
Message: Table '%s' was not locked with LOCK TABLES 本文来自 www.444p.com
Error: 1101 SQLSTATE: 42000 (ER_BLOB_CANT_HAVE_DEFAULT) www.444p.com
Message: BLOB/TEXT column '%s' can't have a default value php学习之家
Error: 1102 SQLSTATE: 42000 (ER_WRONG_DB_NAME)
Message: Incorrect database name '%s' www.444p.com版权所有
Error: 1103 SQLSTATE: 42000 (ER_WRONG_TABLE_NAME) php学习之家
Message: Incorrect table name '%s'
Error: 1104 SQLSTATE: 42000 (ER_TOO_BIG_SELECT) www.444p.com
Message: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error: 1105 SQLSTATE: HY000 (ER_UNKNOWN_ERROR)
Message: Unknown error php学习之家
Error: 1106 SQLSTATE: 42000 (ER_UNKNOWN_PROCEDURE)
php学习之家
Message: Unknown procedure '%s'
Error: 1107 SQLSTATE: 42000 (ER_WRONG_PARAMCOUNT_TO_PROCEDURE)
Message: Incorrect parameter count to procedure '%s' php学习之家
Error: 1108 SQLSTATE: HY000 (ER_WRONG_PARAMETERS_TO_PROCEDURE) php学习之家http://www.444p.com
Message: Incorrect parameters to procedure '%s' www.444p.com版权所有
Error: 1109 SQLSTATE: 42S02 (ER_UNKNOWN_TABLE)
Message: Unknown table '%s' in %s www.444p.com版权所有
Error: 1110 SQLSTATE: 42000 (ER_FIELD_SPECIFIED_TWICE) php学习之家
Message: Column '%s' specified twice 本文来自 www.444p.com
Error: 1111 SQLSTATE: HY000 (ER_INVALID_GROUP_FUNC_USE) php学习之家
Message: Invalid use of group function
Error: 1112 SQLSTATE: 42000 (ER_UNSUPPORTED_EXTENSION)
php学习之家
Message: Table '%s' uses an extension that doesn't exist in this MySQL version
www.444p.com版权所有
Error: 1113 SQLSTATE: 42000 (ER_TABLE_MUST_HAVE_COLUMNS)
Message: A table must have at least 1 column www.444p.com php学习之家
Error: 1114 SQLSTATE: HY000 (ER_RECORD_FILE_FULL) 本文来自 www.444p.com
Message: The table '%s' is full php学习之家
Error: 1115 SQLSTATE: 42000 (ER_UNKNOWN_CHARACTER_SET)
Message: Unknown character set: '%s' php学习之家
Error: 1116 SQLSTATE: HY000 (ER_TOO_MANY_TABLES) php学习之家
Message: Too many tables; MySQL can only use %d tables in a join php学习之家
Error: 1117 SQLSTATE: HY000 (ER_TOO_MANY_FIELDS)
www.444p.com版权所有
Message: Too many columns www.444p.com php学习之家
Error: 1118 SQLSTATE: 42000 (ER_TOO_BIG_ROWSIZE)
Message: Row size too large. The maximum row size for the used table type, not counting BLOBs, is %ld. You have to change some columns to TEXT or BLOBs www.444p.com
Error: 1119 SQLSTATE: HY000 (ER_STACK_OVERRUN)
Message: Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld -O thread_stack=#' to specify a bigger stack if needed 本文来自 www.444p.com
Error: 1120 SQLSTATE: 42000 (ER_WRONG_OUTER_JOIN)
本文来自 www.444p.com
Message: Cross dependency found in OUTER JOIN; examine your ON conditions
Error: 1121 SQLSTATE: 42000 (ER_NULL_COLUMN_IN_INDEX)
Message: Column '%s' is used with UNIQUE or INDEX but is not defined as NOT NULL
Error: 1122 SQLSTATE: HY000 (ER_CANT_FIND_UDF)
www.444p.com
Message: Can't load function '%s' www.444p.com php学习之家
Error: 1123 SQLSTATE: HY000 (ER_CANT_INITIALIZE_UDF)
本文来自 www.444p.com
Message: Can't initialize function '%s'; %s
Error: 1124 SQLSTATE: HY000 (ER_UDF_NO_PATHS)
Message: No paths allowed for shared library php学习之家
Error: 1125 SQLSTATE: HY000 (ER_UDF_EXISTS) php学习之家http://www.444p.com
Message: Function '%s' already exists
php学习之家
Error: 1126 SQLSTATE: HY000 (ER_CANT_OPEN_LIBRARY)
Message: Can't open shared library '%s' (errno: %d %s)
Error: 1127 SQLSTATE: HY000 (ER_CANT_FIND_DL_ENTRY) www.444p.com版权所有
Message: Can't find function '%s' in library' www.444p.com版权所有
Error: 1128 SQLSTATE: HY000 (ER_FUNCTION_NOT_DEFINED) 本文来自 www.444p.com
Message: Function '%s' is not defined
Error: 1129 SQLSTATE: HY000 (ER_HOST_IS_BLOCKED) php学习之家http://www.444p.com
Message: Host '%s' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
Error: 1130 SQLSTATE: HY000 (ER_HOST_NOT_PRIVILEGED)
Message: Host '%s' is not allowed to connect to this MySQL server
Error: 1131 SQLSTATE: 42000 (ER_PASSWORD_ANONYMOUS_USER)
php学习之家
Message: You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords
Error: 1132 SQLSTATE: 42000 (ER_PASSWORD_NOT_ALLOWED)
Message: You must have privileges to update tables in the mysql database to be able to change passwords for others
Error: 1133 SQLSTATE: 42000 (ER_PASSWORD_NO_MATCH) www.444p.com php学习之家
Message: Can't find any matching row in the user table
Error: 1134 SQLSTATE: HY000 (ER_UPDATE_INFO)
Message: Rows matched: %ld Changed: %ld Warnings: %ld
Error: 1135 SQLSTATE: HY000 (ER_CANT_CREATE_THREAD) php学习之家http://www.444p.com
Message: Can't create a new thread (errno %d); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug www.444p.com
Error: 1136 SQLSTATE: 21S01 (ER_WRONG_VALUE_COUNT_ON_ROW) php学习之家http://www.444p.com
Message: Column count doesn't match value count at row %ld
www.444p.com
Error: 1137 SQLSTATE: HY000 (ER_CANT_REOPEN_TABLE)
www.444p.com
Message: Can't reopen table: '%s'
www.444p.com
Error: 1138 SQLSTATE: 22004 (ER_INVALID_USE_OF_NULL) php学习之家http://www.444p.com
Message: Invalid use of NULL value php学习之家http://www.444p.com
Error: 1139 SQLSTATE: 42000 (ER_REGEXP_ERROR)
Message: Got error '%s' from regexp www.444p.com
Error: 1140 SQLSTATE: 42000 (ER_MIX_OF_GROUP_FUNC_AND_FIELDS) www.444p.com php学习之家
Message: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
www.444p.com
Error: 1141 SQLSTATE: 42000 (ER_NONEXISTING_GRANT) www.444p.com
Message: There is no such grant defined for user '%s' on host '%s' 本文来自 www.444p.com
Error: 1142 SQLSTATE: 42000 (ER_TABLEACCESS_DENIED_ERROR)
Message: %s command denied to user '%s'@'%s' for table '%s'
Error: 1143 SQLSTATE: 42000 (ER_COLUMNACCESS_DENIED_ERROR)
Message: %s command denied to user '%s'@'%s' for column '%s' in table '%s' www.444p.com php学习之家
Error: 1144 SQLSTATE: 42000 (ER_ILLEGAL_GRANT_FOR_TABLE)
Message: Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used
Error: 1145 SQLSTATE: 42000 (ER_GRANT_WRONG_HOST_OR_USER) php学习之家
Message: The host or user argument to GRANT is too long www.444p.com
Error: 1146 SQLSTATE: 42S02 (ER_NO_SUCH_TABLE) www.444p.com php学习之家
Message: Table '%s.%s' doesn't exist
Error: 1147 SQLSTATE: 42000 (ER_NONEXISTING_TABLE_GRANT)
Message: There is no such grant defined for user '%s' on host '%s' on table '%s' www.444p.com
Error: 1148 SQLSTATE: 42000 (ER_NOT_ALLOWED_COMMAND)
Message: The used command is not allowed with this MySQL version php学习之家
Error: 1149 SQLSTATE: 42000 (ER_SYNTAX_ERROR) www.444p.com php学习之家
Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use www.444p.com
Error: 1150 SQLSTATE: HY000 (ER_DELAYED_CANT_CHANGE_LOCK) www.444p.com
Message: Delayed insert thread couldn't get requested lock for table %s
Error: 1151 SQLSTATE: HY000 (ER_TOO_MANY_DELAYED_THREADS) www.444p.com
Message: Too many delayed threads in use
php学习之家
Error: 1152 SQLSTATE: 08S01 (ER_ABORTING_CONNECTION)
Message: Aborted connection %ld to db: '%s' user: '%s' (%s)
Error: 1153 SQLSTATE: 08S01 (ER_NET_PACKET_TOO_LARGE)
Message: Got a packet bigger than 'max_allowed_packet' bytes
Error: 1154 SQLSTATE: 08S01 (ER_NET_READ_ERROR_FROM_PIPE)
www.444p.com
Message: Got a read error from the connection pipe
php学习之家
Error: 1155 SQLSTATE: 08S01 (ER_NET_FCNTL_ERROR)
www.444p.com
Message: Got an error from fcntl()
本文来自 www.444p.com
Error: 1156 SQLSTATE: 08S01 (ER_NET_PACKETS_OUT_OF_ORDER) 本文来自 www.444p.com
Message: Got packets out of order
Error: 1157 SQLSTATE: 08S01 (ER_NET_UNCOMPRESS_ERROR)
Message: Couldn't uncompress communication packet www.444p.com
Error: 1158 SQLSTATE: 08S01 (ER_NET_READ_ERROR) php学习之家
Message: Got an error reading communication packets
Error: 1159 SQLSTATE: 08S01 (ER_NET_READ_INTERRUPTED) www.444p.com php学习之家
Message: Got timeout reading communication packets php学习之家
Error: 1160 SQLSTATE: 08S01 (ER_NET_ERROR_ON_WRITE)
Message: Got an error writing communication packets www.444p.com php学习之家
Error: 1161 SQLSTATE: 08S01 (ER_NET_WRITE_INTERRUPTED) 本文来自 www.444p.com
Message: Got timeout writing communication packets php学习之家
Error: 1162 SQLSTATE: 42000 (ER_TOO_LONG_STRING) php学习之家
Message: Result string is longer than 'max_allowed_packet' bytes
www.444p.com版权所有
Error: 1163 SQLSTATE: 42000 (ER_TABLE_CANT_HANDLE_BLOB) php学习之家
Message: The used table type doesn't support BLOB/TEXT columns 本文来自 www.444p.com
Error: 1164 SQLSTATE: 42000 (ER_TABLE_CANT_HANDLE_AUTO_INCREMENT)
Message: The used table type doesn't support AUTO_INCREMENT columns php学习之家http://www.444p.com
Error: 1165 SQLSTATE: HY000 (ER_DELAYED_INSERT_TABLE_LOCKED) www.444p.com
Message: INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES www.444p.com
Error: 1166 SQLSTATE: 42000 (ER_WRONG_COLUMN_NAME) php学习之家
Message: Incorrect column name '%s'
Error: 1167 SQLSTATE: 42000 (ER_WRONG_KEY_COLUMN)
Message: The used storage engine can't index column '%s' php学习之家
Error: 1168 SQLSTATE: HY000 (ER_WRONG_MRG_TABLE)
php学习之家http://www.444p.com
Message: All tables in the MERGE table are not identically defined www.444p.com php学习之家
Error: 1169 SQLSTATE: 23000 (ER_DUP_UNIQUE)
Message: Can't write, because of unique constraint, to table '%s'
Error: 1170 SQLSTATE: 42000 (ER_BLOB_KEY_WITHOUT_LENGTH) php学习之家http://www.444p.com
Message: BLOB/TEXT column '%s' used in key specification without a key length www.444p.com
Error: 1171 SQLSTATE: 42000 (ER_PRIMARY_CANT_HAVE_NULL) php学习之家http://www.444p.com
Message: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead 本文来自 www.444p.com
Error: 1172 SQLSTATE: 42000 (ER_TOO_MANY_ROWS) php学习之家http://www.444p.com
Message: Result consisted of more than one row 本文来自 www.444p.com
Error: 1173 SQLSTATE: 42000 (ER_REQUIRES_PRIMARY_KEY)
www.444p.com版权所有
Message: This table type requires a primary key
Error: 1174 SQLSTATE: HY000 (ER_NO_RAID_COMPILED)
Message: This version of MySQL is not compiled with RAID support
Error: 1175 SQLSTATE: HY000 (ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) www.444p.com
Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column www.444p.com php学习之家
Error: 1176 SQLSTATE: HY000 (ER_KEY_DOES_NOT_EXITS)
Message: Key '%s' doesn't exist in table '%s'
Error: 1177 SQLSTATE: 42000 (ER_CHECK_NO_SUCH_TABLE)
Message: Can't open table
php学习之家http://www.444p.com
Error: 1178 SQLSTATE: 42000 (ER_CHECK_NOT_IMPLEMENTED)
Message: The storage engine for the table doesn't support %s
php学习之家http://www.444p.com
Error: 1179 SQLSTATE: 25000 (ER_CANT_DO_THIS_DURING_AN_TRANSACTION) www.444p.com
Message: You are not allowed to execute this command in a transaction php学习之家
Error: 1180 SQLSTATE: HY000 (ER_ERROR_DURING_COMMIT) www.444p.com
Message: Got error %d during COMMIT
Error: 1181 SQLSTATE: HY000 (ER_ERROR_DURING_ROLLBACK)
www.444p.com
Message: Got error %d during ROLLBACK php学习之家
Error: 1182 SQLSTATE: HY000 (ER_ERROR_DURING_FLUSH_LOGS) www.444p.com php学习之家
Message: Got error %d during FLUSH_LOGS
Error: 1183 SQLSTATE: HY000 (ER_ERROR_DURING_CHECKPOINT)
本文来自 www.444p.com
Message: Got error %d during CHECKPOINT www.444p.com版权所有
Error: 1184 SQLSTATE: 08S01 (ER_NEW_ABORTING_CONNECTION)
Message: Aborted connection %ld to db: '%s' user: '%s' host: `%s' (%s) php学习之家
Error: 1185 SQLSTATE: HY000 (ER_DUMP_NOT_IMPLEMENTED)
Message: The storage engine for the table does not support binary table dump
php学习之家
Error: 1186 SQLSTATE: HY000 (ER_FLUSH_MASTER_BINLOG_CLOSED) php学习之家http://www.444p.com
Message: Binlog closed, cannot RESET MASTER
Error: 1187 SQLSTATE: HY000 (ER_INDEX_REBUILD) www.444p.com
Message: Failed rebuilding the index of dumped table '%s'
Error: 1188 SQLSTATE: HY000 (ER_MASTER) php学习之家
Message: Error from master: '%s'
php学习之家
Error: 1189 SQLSTATE: 08S01 (ER_MASTER_NET_READ) php学习之家http://www.444p.com
Message: Net error reading from master
本文来自 www.444p.com
Error: 1190 SQLSTATE: 08S01 (ER_MASTER_NET_WRITE)
Message: Net error writing to master
Error: 1191 SQLSTATE: HY000 (ER_FT_MATCHING_KEY_NOT_FOUND) www.444p.com
Message: Can't find FULLTEXT index matching the column list
Error: 1192 SQLSTATE: HY000 (ER_LOCK_OR_ACTIVE_TRANSACTION) www.444p.com php学习之家
Message: Can't execute the given command because you have active locked tables or an active transaction www.444p.com
Error: 1193 SQLSTATE: HY000 (ER_UNKNOWN_SYSTEM_VARIABLE) www.444p.com版权所有
Message: Unknown system variable '%s' www.444p.com php学习之家
Error: 1194 SQLSTATE: HY000 (ER_CRASHED_ON_USAGE) www.444p.com php学习之家
Message: Table '%s' is marked as crashed and should be repaired 本文来自 www.444p.com
Error: 1195 SQLSTATE: HY000 (ER_CRASHED_ON_REPAIR) www.444p.com
Message: Table '%s' is marked as crashed and last (automatic?) repair failed www.444p.com
Error: 1196 SQLSTATE: HY000 (ER_WARNING_NOT_COMPLETE_ROLLBACK)
www.444p.com
Message: Some non-transactional changed tables couldn't be rolled back 本文来自 www.444p.com
Error: 1197 SQLSTATE: HY000 (ER_TRANS_CACHE_FULL)
Message: Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again
php学习之家
Error: 1198 SQLSTATE: HY000 (ER_SLAVE_MUST_STOP) 本文来自 www.444p.com
Message: This operation cannot be performed with a running slave; run STOP SLAVE first
php学习之家
Error: 1199 SQLSTATE: HY000