This is what is prompted when importing a 66m sized sql file with the following picture
Need to be in the sql console, type:
SET GLOBAL max_allowed_packet = 1048576000;
SET GLOBAL group_concat_max_len=51200;
SET SESSION group_concat_max_len=51200;
Problem solving.
TWO. Use of complexsql statementWhen there is a group by statement, you need to enter it in the sql console:
SET @@GLOBAL.sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION'; (this method is temporary and valid for the current session)
Or add sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ ENGINE_SUBSTITUTION" (this method is permanent)
List of mysql Error Codes
mysql error code (memo)
Turn 1005: Failed to create table
1006: Failed to create database
1007: Database already exists, failed to create database
1008: Database does not exist, failed to delete database
1009: Failure to delete database due to inability to delete database file
1010: Failure to delete database due to inability to delete data directory
1011: Failed to delete database file
1012: Cannot read records in system table
1020: Record has been modified by another user
1021: The remaining space on the hard disk is not enough, please increase the free space on the hard disk.
1022: Duplicate keyword, failed to change record
1023: Error on closure
1024: Read file error
1025: An error occurred while changing the name
1026: Write file error
1032: Record does not exist
1036: The data table is read-only and cannot be modified.
1037: Insufficient system memory, please restart the database or restart the server
1038: Insufficient memory for sorting, increase sort buffer
1040: The maximum number of connections to the database has been reached, please increase the number of available connections to the database.
1041: Insufficient system memory
1042: Invalid hostname
1043: Invalid connection
1044: The current user does not have access to the database
1045: Cannot connect to database, wrong username or password
1048: Field cannot be empty
1049: Database does not exist
1050: Data sheet already exists
1051: Data sheet does not exist
1054: Field does not exist
1065: Invalid SQL statement, SQL statement is empty
1081: Socket connection cannot be established
1114: Data table is full and cannot hold any records
1116: Too many data tables open
1129: There is an abnormality in the database, please restart the database
1130: Failed to connect to database, no permission to connect to database
1133: Database user does not exist
1141: The current user is not authorized to access the database
1142: The current user is not authorized to access the data table
1143: The current user is not authorized to access the fields in the data table
1146: Data table does not exist
1147: Undefined user access to data tables
1149: SQL statement syntax errors
1158: Network error, a read error occurred, please check the network connection status
1159: Network error, read timeout, please check network connection status
1160: Network error, write error occurs, please check the network connection status
1161: Network error, write timeout, please check the network connection status
1062: Duplicate field values, entry failed
1169: Duplicate field value, failed to update record
1177: Failed to open data table
1180: Failure to submit a transaction
1181: Rollback transaction failed
1203: The connection established between the current user and the database has reached the maximum number of database connections, please increase the number of available database connections or restart the database.
1205: Lock timeout
1211: The current user does not have permission to create users
1216: Failed to check foreign key constraints, failed to update child table records
1217: Failed to check foreign key constraints, failed to delete or modify main table records
1226: The resources used by the current user have exceeded the allowed resources, please restart the database or restart the server.
1227: Insufficient privileges, you are not authorized to perform this operation
1235: MySQL version is too low to have this feature
Error: 1236 SQLSTATE: HY000 (ER_MASTER_FATAL_ERROR_READING_BINLOG) Message: Fatal error %d: '%s' from the main server was obtained while reading data from the binary log.
Error: 1237 SQLSTATE: HY000 (ER_SLAVE_IGNORED_TABLE) Message: The query was ignored from the SQL thread due to the "duplicate-*-table" rule.
Error: 1238 SQLSTATE: HY000 (ER_INCORRECT_GLOBAL_LOCAL_VAR) Message: variable '%s' is a %s variable.
Error: 1239 SQLSTATE: 42000 (ER_WRONG_FK_DEF) Message: Foreign key definition is incorrect for '%s': %s. [Page]
Error: 1240 SQLSTATE: HY000 (ER_KEY_REF_DO_NOT_MATCH_TABLE_REF) Message: key reference and table reference do not match.
Error: 1241 SQLSTATE: 21000 (ER_OPERAND_COLUMNS) Message: operand should contain %d columns.
Error: 1242 SQLSTATE: 21000 (ER_SUBQUERY_NO_1_ROW) Message: Subquery returned more than 1 row.
Error: 1243 SQLSTATE: HY000 (ER_UNKNOWN_STMT_HANDLER) Message: unknown preprocessor statement handle assigned to %s.
Error: 1244 SQLSTATE: HY000 (ER_CORRUPT_HELP_DB) Message: Help database crashed or does not exist.
Error: 1245 SQLSTATE: HY000 (ER_CYCLIC_REFERENCE) Message: circular reference to subquery.
Error: 1246 SQLSTATE: HY000 (ER_AUTO_CONVERT) Message: converting column '%s' from %s to %s.
Error: 1247 SQLSTATE: 42S22 (ER_ILLEGAL_REFERENCE) Message: reference '%s' is not supported (%s).
ERROR: 1248 SQLSTATE: 42000 (ER_DERIVED_MUST_HAVE_ALIAS) Message: All exported tables must have their own aliases.
Error: 1249 SQLSTATE: 01000 (ER_SELECT_REDUCED) Message: simplified selection %u during optimization.
Error: 1250 SQLSTATE: 42000 (ER_TABLENAME_NOT_ALLOWED_HERE) Message: table '%s' from a certain SELECT cannot be used in %s.
Error: 1251 SQLSTATE: 08004 (ER_NOT_SUPPORTED_AUTH_MODE) Message: The client does not support the authentication protocol requested by the server, please consider upgrading the MySQL client.
Error: 1252 SQLSTATE: 42000 (ER_SPATIAL_CANT_HAVE_NULL) Message: all parts of the SPATIAL index must be NOT NULL.
Error: 1253 SQLSTATE: 42000 (ER_COLLATION_CHARSET_MISMATCH) Message: for CHARACTER SET '%s', COLLATION '%s ' is not valid.
Error: 1254 SQLSTATE: HY000 (ER_SLAVE_WAS_RUNNING) Message: The slave server is running.
Error: 1255 SQLSTATE: HY000 (ER_SLAVE_WAS_NOT_RUNNING) Message: The slave server has stopped.
Error: 1256 SQLSTATE: HY000 (ER_TOO_BIG_FOR_UNCOMPRESS) Message: Uncompressed data is too large, the maximum size is %d (it is also possible, that the length of the uncompressed data is corrupted).
Error: 1257 SQLSTATE: HY000 (ER_ZLIB_Z_MEM_ERROR) Message: ZLIB, not enough memory.
Error: 1258 SQLSTATE: HY000 (ER_ZLIB_Z_BUF_ERROR) Message: ZLIB, There is not enough space in the output buffer (or, perhaps, the length of the unpacked data is corrupted).
Error: 1259 SQLSTATE: HY000 (ER_ZLIB_Z_DATA_ERROR) Message: ZLIB, input data is corrupted.
Error: 1260 SQLSTATE: HY000 (ER_CUT_VALUE_GROUP_CONCAT) Message: %d line truncated by GROUP_CONCAT().
Error: 1261 SQLSTATE: 01000 (ER_WARN_TOO_FEW_RECORDS) Message: row %ld does not contain data for all columns.
Error: 1262 SQLSTATE: 01000 (ER_WARN_TOO_MANY_RECORDS) Message: row %ld was unshortened and it contains more data than in the input column.
Error: 1263 SQLSTATE: 22004 (ER_WARN_NULL_TO_NOTNULL) Message: column was set to default value and NULL was supplied to NOT NULL column on row %ld.
Error: 1264 SQLSTATE: 22003 (ER_WARN_DATA_OUT_OF_RANGE) Message: adjusted out of range value for column '%s' on row %ld.
Error: 1265 SQLSTATE: 01000 (WARN_DATA_TRUNCATED) Message: truncated data for column '%s' on row %ld.
Error: 1266 SQLSTATE: HY000 (ER_WARN_USING_OTHER_HANDLER) Message: using storage engine %s for table %s. [Page].
ERROR: 1267 SQLSTATE: HY000 (ER_CANT_AGGREGATE_2COLLATIONS) MESSAGE: Illegal mix of proofreading (%s,%s) and (%s,%s) for operation '%s'.
Error: 1268 SQLSTATE: HY000 (ER_DROP_USER) Message: Unable to undo 1 or more requested users.
Error: 1269 SQLSTATE: HY000 (ER_REVOKE_GRANTS) Message: Unable to revoke all permissions for 1 or more requested user authorizations.
ERROR: 1270 SQLSTATE: HY000 (ER_CANT_AGGREGATE_3COLLATIONS) MESSAGE: Illegal mix of proofreading (%s,%s), (%s,%s) and (%s,%s) for operation '%s'.
Error: 1271 SQLSTATE: HY000 (ER_CANT_AGGREGATE_NCOLLATIONS) Message: Illegal mix of checksums for operation '%s'.
Error: 1272 SQLSTATE: HY000 (ER_VARIABLE_IS_NOT_STRUCT) Message: Variable '%s' is not a variable component (cannot be used as XXXX.variable_name).
Error: 1273 SQLSTATE: HY000 (ER_UNKNOWN_COLLATION) Message: unknown proofreading '%s'.
Error: 1274 SQLSTATE: HY000 (ER_SLAVE_IGNORED_SSL_PARAMS) Message: The SSL parameters in CHANGE MASTER are ignored because this MySQL slave server was compiled without SSL support, and subsequently, if an SSL-capable MySQL is started, you can use the these parameters.
Error: 1275 SQLSTATE: HY000 (ER_SERVER_IS_IN_SECURE_AUTH_MODE) Message: The server is running in "-secure-auth" mode but the '%s'@'%s' has 1 password in the old format. '%s'@'%s' has a password in the old format, please change the password to the new format.
ERROR: 1276 SQLSTATE: HY000 (ER_WARN_FIELD_RESOLVED) MESSAGE: The field or reference '%s%s%s%s%s%s' for SELECT #%d was identified in SELECT #%d.
Error: 1277 SQLSTATE: HY000 (ER_BAD_SLAVE_UNTIL_COND) Message: incorrect parameter or combination of parameters for START SLAVE UNTIL.
Error: 1278 SQLSTATE: HY000 (ER_MISSING_SKIP_SLAVE) Message: When performing step-by-step replication with START SLAVE UNTIL, it is recommended to use "-skip-slave-start " is recommended when performing step-by-step replication with START SLAVE UNTIL, otherwise problems may occur if an unanticipated restart of the slave mysqld server occurs.
Error: 1279 SQLSTATE: HY000 (ER_UNTIL_COND_IGNORED) Message: The SQL thread was not started and therefore the UNTIL option was ignored.
Error: 1280 SQLSTATE: 42000 (ER_WRONG_NAME_FOR_INDEX) Message: incorrect index name '%s'.
Error: 1281 SQLSTATE: 42000 (ER_WRONG_NAME_FOR_CATALOG) Message: incorrect directory name '%s'.
Error: 1282 SQLSTATE: HY000 (ER_WARN_QC_RESIZE) Message: Failed to set the size of the query cache to %lu, the new query cache size is %lu.
Error: 1283 SQLSTATE: HY000 (ER_BAD_FT_COLUMN) Message: column '%s' cannot be part of a FULLTEXT index.
Error: 1284 SQLSTATE: HY000 (ER_UNKNOWN_KEY_CACHE) Message: unknown key cache '%s'.
Error: 1285 SQLSTATE: HY000 (ER_WARN_HOSTNAME_WONT_WORK) Message: MySQL was started in "-skip-name-resolve" mode, and it must be restarted without this switch for the license to work. switch must be restarted in order for the license to work.
Error: 1286 SQLSTATE: 42000 (ER_UNKNOWN_STORAGE_ENGINE) Message: unknown table engine '%s'.
Error: 1287 SQLSTATE: HY000 (ER_WARN_DEPRECATED_SYNTAX) Message: '%s' is obsolete, use '%s' instead.
Error: 1288 SQLSTATE: HY000 (ER_NON_UPDATABLE_TABLE) Message: target table %s of %s is not updatable.
Error: 1289 SQLSTATE: HY000 (ER_FEATURE_DISABLED) Message: The '%s' feature has been disabled, to make it work you need to create MySQL with '%s'. [ Page]
Error: 1290 SQLSTATE: HY000 (ER_OPTION_PREVENTS_STATEMENT) Message: MySQL is running with the %s option, so the statement cannot be executed.
Error: 1291 SQLSTATE: HY000 (ER_DUPLICATED_VALUE_IN_TYPE) Message: column '%s' has duplicate value '%s' in %s.
Error: 1292 SQLSTATE: 22007 (ER_TRUNCATED_WRONG_VALUE) Message: truncated incorrect %s value: '%s'
ERROR: 1293 SQLSTATE: HY000 (ER_TOO_MUCH_AUTO_TIMESTAMP_COLS) MESSAGE: Incorrect table definition, in the DEFAULT or ON UPDATE clause, for CURRENT_TIMESTAMP, there can only be one TIMESTAMP column.
Error: 1294 SQLSTATE: HY000 (ER_INVALID_ON_UPDATE) Message: The ON UPDATE clause is invalid for column '%s'.
Error: 1295 SQLSTATE: HY000 (ER_UNSUPPORTED_PS) Message: this command is not yet supported in the preprocessing statement protocol.
Error: 1296 SQLSTATE: HY000 (ER_GET_ERRMSG) Message: error %d '%s' from %s.
Error: 1297 SQLSTATE: HY000 (ER_GET_TEMPORARY_ERRMSG) Message: temporary error %d '%s' from %s.
Error: 1298 SQLSTATE: HY000 (ER_UNKNOWN_TIME_ZONE) Message: unknown or incorrect time zone: '%s'
Error: 1299 SQLSTATE: HY000 (ER_WARN_INVALID_TIMESTAMP) Message: invalid TIMESTAMP value exists in column '%s' of row %ld.
Error: 1300 SQLSTATE: HY000 (ER_INVALID_CHARACTER_STRING) Message: invalid %s string: '%s'
Error: 1301 SQLSTATE: HY000 (ER_WARN_ALLOWED_PACKET_OVERFLOWED) Message: The result of %s() is greater than max_allowed_packet (%ld) and has been truncated.
Error: 1302 SQLSTATE: HY000 (ER_CONFLICTING_DECLARATIONS) Message: conflict statement: '%s%s' and '%s%s'
Error: 1303 SQLSTATE: 2F003 (ER_SP_NO_RECURSIVE_CREATE) Message: %s could not be created from another storage subroutine.
Error: 1304 SQLSTATE: 42000 (ER_SP_ALREADY_EXISTS) Message: %s %s already exists.
Error: 1305 SQLSTATE: 42000 (ER_SP_DOES_NOT_EXIST) Message: %s %s does not exist.
Error: 1306 SQLSTATE: HY000 (ER_SP_DROP_FAILED) Message: DROP %s %s failure
Error: 1307 SQLSTATE: HY000 (ER_SP_STORE_FAILED) Message: CREATE %s %s failed.
Error: 1308 SQLSTATE: 42000 (ER_SP_LILABEL_MISMATCH) Message: %s No matching tag: %s
Error: 1309 SQLSTATE: 42000 (ER_SP_LABEL_REDEFINE) Message: redefine label %s
Error: 1310 SQLSTATE: 42000 (ER_SP_LABEL_MISMATCH) Message: no match for end label %s
Error: 1311 SQLSTATE: 01000 (ER_SP_UNINIT_VAR) Message: Uninitialized variable %s is being referenced.
Error: 1312 SQLSTATE: 0A000 (ER_SP_BADSELECT) Message: PROCEDURE %s could not return the result set in the given scenario.
Error: 1313 SQLSTATE: 42000 (ER_SP_BADRETURN) Message: RETURN is allowed only in FUNCTION.
Error: 1314 SQLSTATE: 0A000 (ER_SP_BADSTATEMENT) Message: %s is not allowed in the stored program.
Error: 1315 SQLSTATE: 42000 (ER_UPDATE_LOG_DEPRECATED_IGNORED) Message: the update log has been discarded and replaced with a binary log, SET SQL_LOG_UPDATE is ignored.
Error: 1316 SQLSTATE: 42000 (ER_UPDATE_LOG_DEPRECATED_TRANSLATED) Message: the update log has been dropped and replaced with a binary log, and SET SQL_LOG_UPDATE has been truncated to SET SQL_LOG_BIN. [Page].
Error: 1317 SQLSTATE: 70100 (ER_QUERY_INTERRUPTED) Message: Query execution was interrupted.
Error: 1318 SQLSTATE: 42000 (ER_SP_WRONG_NO_OF_ARGS) Message: incorrect number of parameters for %s %s, expected to be %u but was %u.
Error: 1319 SQLSTATE: 42000 (ER_SP_COND_MISMATCH) Message: undefined CONDITION: %s
Error: 1320 SQLSTATE: 42000 (ER_SP_NORETURN) Message: no RETURN found in FUNCTION %s.
Error: 1321 SQLSTATE: 2F005 (ER_SP_NORETURNEND) Message: missing RETURN at end of FUNCTION %s.
Error: 1322 SQLSTATE: 42000 (ER_SP_BAD_CURSOR_QUERY) Message: cursor statement must be SELECT.
Error: 1323 SQLSTATE: 42000 (ER_SP_BAD_CURSOR_SELECT) Message: cursor SELECT must not have INTO.
Error: 1324 SQLSTATE: 42000 (ER_SP_CURSOR_MISMATCH) Message: undefined CURSOR: %s
Error: 1325 SQLSTATE: 24000 (ER_SP_CURSOR_ALREADY_OPEN) Message: Cursor Opened
Error: 1326 SQLSTATE: 24000 (ER_SP_CURSOR_NOT_OPEN) Message: Cursor not open
Error: 1327 SQLSTATE: 42000 (ER_SP_UNDECLARED_VAR) Message: Undeclared variable: %s
Error: 1328 SQLSTATE: HY000 (ER_SP_WRONG_NO_OF_FETCH_ARGS) Message: incorrect number of FETCH variables.
Error: 1329 SQLSTATE: 02000 (ER_SP_FETCH_NO_DATA) Message: no data for FETCH.
Error: 1330 SQLSTATE: 42000 (ER_SP_DUP_PARAM) Message: Duplicate parameter: %s
Error: 1331 SQLSTATE: 42000 (ER_SP_DUP_VAR) Message: Duplicate variable: %s Error: 1332 SQLSTATE: 42000 (ER_SP_DUP_COND) Message: Duplicate condition: %s
Error: 1333 SQLSTATE: 42000 (ER_SP_DUP_CURS) Message: Duplicate cursor: %s
Error: 1334 SQLSTATE: HY000 (ER_SP_CANT_ALTER) Message: ALTER %s %s failed.
Error: 1335 SQLSTATE: 0A000 (ER_SP_SUBSELECT_NYI) Message: Subselect values are not supported.
Error: 1336 SQLSTATE: 0A000 (ER_STMT_NOT_ALLOWED_IN_SF_OR_TRG) Message: %s is not allowed in stored functions or triggered programs.
Error: 1337 SQLSTATE: 42000 (ER_SP_VARCOND_AFTER_CURSHNDLR) Message: variable or conditional statement following a cursor or handle statement.
Error: 1338 SQLSTATE: 42000 (ER_SP_CURSOR_AFTER_HANDLER) Message: cursor statement after handle statement.
Error: 1339 SQLSTATE: 20000 (ER_SP_CASE_NOT_FOUND) Message: for CASE statement, Case not found.
Error: 1340 SQLSTATE: HY000 (ER_FPARSER_TOO_BIG_FILE) Message: profile '%s' is too large.
Error: 1341 SQLSTATE: HY000 (ER_FPARSER_BAD_HEADER) Message: mutilated file type title in file '%s'.
Error: 1342 SQLSTATE: HY000 (ER_FPARSER_EOF_IN_COMMENT) Message: file ended unexpectedly while parsing '%s'.
Error: 1343 SQLSTATE: HY000 (ER_FPARSER_ERROR_IN_PARAMETER) Message: error parsing parameter '%s' (line: '%s').
Error: 1344 SQLSTATE: HY000 (ER_FPARSER_EOF_IN_UNKNOWN_PARAMETER) Message: file ended unexpectedly when skipping unknown parameter '%s'.
Error: 1345 SQLSTATE: HY000 (ER_VIEW_NO_EXPLAIN) Message: EXPLAIN/SHOW could not be issued, lack of permissions to base table.
Error: 1346 SQLSTATE: HY000 (ER_FRM_UNKNOWN_TYPE) Message: file '%s' has unknown type '%s' in its header. [Page]
Error: 1347 SQLSTATE: HY000 (ER_WRONG_OBJECT) Message: '%s.%s' is not %s.
Error: 1348 SQLSTATE: HY000 (ER_NONUPDATEABLE_COLUMN) Message: column '%s' is not updatable.
Error: 1349 SQLSTATE: HY000 (ER_VIEW_SELECT_DERIVED) Message: view's SELECT contains subquery in FROM clause.
Error: 1350 SQLSTATE: HY000 (ER_VIEW_SELECT_CLAUSE) Message: view's SELECT contains '%s' clause.
Error: 1351 SQLSTATE: HY000 (ER_VIEW_SELECT_VARIABLE) Message: SELECT of view contains 1 variable or parameter.
Error: 1352 SQLSTATE: HY000 (ER_VIEW_SELECT_TMPTABLE) Message: view's SELECT references temporary table '%s'.
Error: 1353 SQLSTATE: HY000 (ER_VIEW_WRONG_LIST) Message: the SELECT of the view and the field list of the view have different column counts.
Error: 1354 SQLSTATE: HY000 (ER_WARN_VIEW_MERGE) Message: at this point, the view merge algorithm cannot be used here (assuming the algorithm is not defined).
Error: 1355 SQLSTATE: HY000 (ER_WARN_VIEW_WITHOUT_KEY) Message: The view that is being updated does not have the full key of its base table.
Error: 1356 SQLSTATE: HY000 (ER_VIEW_INVALID) Message: View '%s.%s' references an invalid table, column, or function, or the view's defining/calling program lacks the privileges to use them.
Error: 1357 SQLSTATE: HY000 (ER_SP_NO_DROP_SP) Message: could not undo or change %s from another storage subroutine.
Error: 1358 SQLSTATE: HY000 (ER_SP_GOTO_IN_HNDLR) Message: GOTO is not allowed in the storage subroutine handle.
Error: 1359 SQLSTATE: HY000 (ER_TRG_ALREADY_EXISTS) Message: Trigger program already exists.
Error: 1360 SQLSTATE: HY000 (ER_TRG_DOES_NOT_EXIST) Message: Trigger program does not exist.
Error: 1361 SQLSTATE: HY000 (ER_TRG_ON_VIEW_OR_TEMP_TABLE) Message: '%s' of the triggered program is a view or temporary table.
Error: 1362 SQLSTATE: HY000 (ER_TRG_CANT_CHANGE_ROW) Message: update of %s row is not allowed in %strigger.
Error: 1363 SQLSTATE: HY000 (ER_TRG_NO_SUCH_ROW_IN_TRG) Message: there is no %s line in the %s trigger program.
Error: 1364 SQLSTATE: HY000 (ER_NO_DEFAULT_FOR_FIELD) Message: field '%s' has no default value.
Error: 1365 SQLSTATE: 22012 (ER_DIVISION_BY_ZERO) Message: divided by zero.
Error: 1366 SQLSTATE: HY000 (ER_TRUNCATED_WRONG_VALUE_FOR_FIELD) Message: incorrect %s value, '%s', for column '%s' on row %ld '.
Error: 1367 SQLSTATE: 22007 (ER_ILLEGAL_VALUE_FOR_TYPE) Message: illegal %s '%s' value was found during parsing.
Error: 1368 SQLSTATE: HY000 (ER_VIEW_NONUPD_CHECK) Message: CHECK OPTION on view '%s.%s' cannot be updated.
Error: 1369 SQLSTATE: HY000 (ER_VIEW_CHECK_FAILED) Message: CHECK OPTION FAILED, '%s.%s'
Error: 1370 SQLSTATE: 42000 (ER_PROCACCESS_DENIED_ERROR) Message: for subroutine '%s', denied user '%s'@ '%s' to use the %s command.
Error: 1371 SQLSTATE: HY000 (ER_RELAY_LOG_FAIL) Message: Failed to clear old relay log, %s
Error: 1372 SQLSTATE: HY000 (ER_PASSWD_LENGTH) Message: Password mix should be in %d bitshexadecimalNumbers.
Error: 1373 SQLSTATE: HY000 (ER_UNKNOWN_TARGET_BINLOG) Message: target log not found in binlog index. [Page]
Error: 1374 SQLSTATE: HY000 (ER_IO_ERR_LOG_INDEX_READ) Message: I/O error while reading log index file.
Error: 1375 SQLSTATE: HY000 (ER_BINLOG_PURGE_PROHIBITED) Message: server configuration does not allow binlog purge.
Error: 1376 SQLSTATE: HY000 (ER_FSEEK_FAIL) Message: fseek() failed.
Error: 1377 SQLSTATE: HY000 (ER_BINLOG_PURGE_FATAL_ERR) Message: fatal error during log purge.
Error: 1378 SQLSTATE: HY000 (ER_LOG_IN_USE) Message: The clearable log is in use and cannot be cleared.
Error: 1379 SQLSTATE: HY000 (ER_LOG_PURGE_UNKNOWN_ERR) Message: unknown error during log purge.
Error: 1380 SQLSTATE: HY000 (ER_RELAY_LOG_INIT) Message: Failed to initialize relay log location, %s
Error: 1381 SQLSTATE: HY000 (ER_NO_BINARY_LOGGING) Message: The binary logging feature is not used.
Error: 1382 SQLSTATE: HY000 (ER_RESERVED_SYNTAX) Message: '%s' syntax is reserved for internal MySQL server use.
Error: 1383 SQLSTATE: HY000 (ER_WSAS_FAILED) Message: WSAStartup failed.
Error: 1384 SQLSTATE: HY000 (ER_DIFF_GROUPS_PROC) Message: It is not yet possible to handle the procedure with a different group.
Error: 1385 SQLSTATE: HY000 (ER_NO_GROUP_FOR_PROC) Message: For this procedure, SELECT must have 1 group.
Error: 1386 SQLSTATE: HY000 (ER_ORDER_WITH_PROC) Message: cannot use the ORDER clause with this procedure.
Error: 1387 SQLSTATE: HY000 (ER_LOGGING_PROHIBIT_CHANGING_OF) Message: the binary logging feature and the replication feature prohibit changes to the global server %s.
Error: 1388 SQLSTATE: HY000 (ER_NO_FILE_MAPPING) Message: Unable to map file: %s, errno: %d
Error: 1389 SQLSTATE: HY000 (ER_WRONG_MAGIC) Message: error in %s
Error: 1390 SQLSTATE: HY000 (ER_PS_MANY_PARAM) Message: preprocessing statement contains too many placeholders.
Error: 1391 SQLSTATE: HY000 (ER_KEY_PART_0) Message: the length of the key part '%s' cannot be zero.
Error: 1392 SQLSTATE: HY000 (ER_VIEW_CHECKSUM) Message: view text checksum failed.
Error: 1393 SQLSTATE: HY000 (ER_VIEW_MULTIUPDATE) Message: Unable to change more than 1 base table via union view '%s.%s'.
Error: 1394 SQLSTATE: HY000 (ER_VIEW_NO_INSERT_FIELD_LIST) Message: can't insert federated view '%s.%s' without field list.
Error: 1395 SQLSTATE: HY000 (ER_VIEW_DELETE_MERGE_VIEW) Message: can't delete from federated view '%s.%s'.
Error: 1396 SQLSTATE: HY000 (ER_CANNOT_USER) Message: operation %s failed for %s.
Error: 1397 SQLSTATE: XAE04 (ER_XAER_NOTA) Message: XAER_NOTA: Unknown XID
Error: 1398 SQLSTATE: XAE05 (ER_XAER_INVAL) Message: XAER_INVAL: Invalid parameter (or unsupported command)
Error: 1399 SQLSTATE: XAE07 (ER_XAER_RMFAIL) Message: XAER_RMFAIL: Command cannot be executed when global transaction is in %s state.
Error: 1400 SQLSTATE: XAE09 (ER_XAER_OUTSIDE) Message: XAER_OUTSIDE: Some work was done outside the global transaction.
Error: 1401 SQLSTATE: XAE03 (ER_XAER_RMERR) Message: XAER_RMERR: Fatal error in transaction branch, please check data consistency.
Error: 1402 SQLSTATE: XA100 (ER_XA_RBROLLBACK) Message: XA_RBROLLBACK: Rolled back transaction branch. [Page]
Error: 1403 SQLSTATE: 42000 (ER_NONEXISTING_PROC_GRANT) Message: no such authorization was defined on subroutine '%s' for the user on host '%s'. This type of authorization defined for '%s' on host '%s' is not available on subroutine '%s'.
Error: 1404 SQLSTATE: HY000 (ER_PROC_AUTO_GRANT_FAIL) Message: Could not grant EXECUTE and ALTER ROUTINE privileges.
Error: 1405 SQLSTATE: HY000 (ER_PROC_AUTO_REVOKE_FAIL) Message: Unable to revoke all privileges on relinquished subroutine.
Error: 1406 SQLSTATE: 22001 (ER_DATA_TOO_LONG) Message: data too long for column '%s' on row %ld.
Error: 1407 SQLSTATE: 42000 (ER_SP_BAD_SQLSTATE) Message: bad SQLSTATE: '%s'
Error: 1408 SQLSTATE: HY000 (ER_STARTUP) Message: %s, Connection ready; Version, '%s'; Socket, '%s'; Port, %d %s
Error: 1409 SQLSTATE: HY000 (ER_LOAD_FROM_FIXED_SIZE_ROWS_TO_VAR) Message: Cannot load values into a variable from a file with fixed-size rows.
Error: 1410 SQLSTATE: 42000 (ER_CANT_CREATE_USER_WITH_GRANT) Message: User creation with GRANT is not allowed.
Error: 1411 SQLSTATE: HY000 (ER_WRONG_VALUE_FOR_TYPE) Message: incorrect %s value, '%s', for function %s
Error: 1412 SQLSTATE: HY000 (ER_TABLE_DEF_CHANGED) Message: The table definition has changed, please try the transaction again.
Error: 1413 SQLSTATE: 42000 (ER_SP_DUP_HANDLER) Message: Duplicate handle declared in same block.
Error: 1414 SQLSTATE: 42000 (ER_SP_NOT_VAR_ARG) Message: the OUT or INOUT parameter of subroutine %s is not a variable.
Error: 1415 SQLSTATE: 0A000 (ER_SP_NO_RETSET) Message: not allowed to return result set from %s.
Error: 1416 SQLSTATE: 22003 (ER_CANT_CREATE_GEOMETRY_OBJECT) Message: could not retrieve the geometry object from the data sent to the GEOMETRY field.
Error: 1417 SQLSTATE: HY000 (ER_FAILED_ROUTINE_BREAK_BINLOG) Message: 1 subroutine failed with no NO SQL or READS SQL DATA in its declaration and the binary logging feature is enabled so that if a non-transactional table is updated, the binary log loses information about its changes.
Error: 1418 SQLSTATE: HY000 (ER_BINLOG_UNSAFE_ROUTINE) Message: There is no DETERMINISTIC, NO SQL, or READS SQL DATA in the subroutine's in its declarations and the binary logging feature is enabled (you may intend to use the less secure log_bin_trust_routine_creators variable). trust_routine_creators variable).
Error: 1419 SQLSTATE: HY000 (ER_BINLOG_CREATE_ROUTINE_NEED_SUPER) Message: You don't have SUPER privileges and the binary logging feature is enabled (you may be planning to use the less secure log_bin_trust_routine_creators variable) The
Error: 1420 SQLSTATE: HY000 (ER_EXEC_STMT_WITH_OPEN_CURSOR) Message: could not execute this preprocessor statement, which has an open cursor associated with it. Please reset the statement and execute it again.
Error: 1421 SQLSTATE: HY000 (ER_STMT_HAS_NO_OPEN_CURSOR) Message: statement (%lu) has no open cursor.
Error: 1422 SQLSTATE: HY000 (ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG) Message: Explicit or implicit commits are not allowed in stored functions or triggered programs.
Error: 1423 SQLSTATE: HY000 (ER_NO_DEFAULT_FOR_VIEW_FIELD) Message: fields in the base table of view '%s.%s' do not have default values.
Error: 1424 SQLSTATE: HY000 (ER_SP_NO_RECURSION) Message: Recursive storage subroutines are not allowed. [Page]
Error: 1425 SQLSTATE: 42000 (ER_TOO_BIG_SCALE) Message: too large a scale %d was specified for column '%s'. maximum %d.
Error: 1426 SQLSTATE: 42000 (ER_TOO_BIG_PRECISION) Message: too high a precision %d was specified for column '%s'. maximum %d.
Error: 1427 SQLSTATE: 42000 (ER_M_BIGGER_THAN_D) Message: for float(M,D), double(M,D) or decimal(M,D), M must >= D (column '%s').
Error: 1428 SQLSTATE: HY000 (ER_WRONG_LOCK_OF_SYSTEM_TABLE) Message: Cannot combine write locking of system '%s.%s' table with other tables.
Error: 1429 SQLSTATE: HY000 (ER_CONNECT_TO_FOREIGN_DATA_SOURCE) Message: unable to connect to external data source, database '%s'!
Error: 1430 SQLSTATE: HY000 (ER_QUERY_ON_FOREIGN_DATA_SOURCE) Message: There was a problem processing a query acting on an external data source. Data source error: '%s'
Error: 1431 SQLSTATE: HY000 (ER_FOREIGN_DATA_SOURCE_DOESNT_EXIST) Message: The external data source you are trying to reference does not exist. Data source error: '%s'
Error: 1432 SQLSTATE: HY000 (ER_FOREIGN_DATA_STRING_INVALID_CANT_CREATE) Message: Unable to create union table. The data source connection string '%s' is not in the correct format.
Error: 1433 SQLSTATE: HY000 (ER_FOREIGN_DATA_STRING_INVALID) Message: data source connection string '%s' is not in the correct format.
Error: 1434 SQLSTATE: HY000 (ER_CANT_CREATE_FEDERATED_TABLE) Message: Unable to create federated table. External data source error: '%s'
Error: 1435 SQLSTATE: HY000 (ER_TRG_IN_WRONG_SCHEMA) Message: The trigger program is in the wrong scenario.
Error: 1436 SQLSTATE: HY000 (ER_STACK_OVERRUN_NEED_MORE) Message: thread_stack_overflowed, %ld bytes stack used %ld bytes and needs %ld bytes. Please use 'mysqld -O thread_stack=#' to specify a larger stack.
Error: 1437 SQLSTATE: 42000 (ER_TOO_LONG_BODY) Message: subroutine body for '%s' is too long.
Error: 1438 SQLSTATE: HY000 (ER_WARN_CANT_DROP_DEFAULT_KEYCACHE) Message: Unable to undo default keycache.
Error: 1439 SQLSTATE: 42000 (ER_TOO_BIG_DISPLAYWIDTH) Message: display width out of range for column '%s' (max = %d)
Error: 1440 SQLSTATE: XAE08 (ER_XAER_DUPID) Message.
Error: 1441 SQLSTATE: 22008 (ER_DATETIME_FUNCTION_OVERFLOW) Message: datetime function, %s field overflowed.
Error: 1442 SQLSTATE: HY000 (ER_CANT_UPDATE_USED_TABLE_IN_SF_OR_TRG) Message: Cannot update table '%s' in a stored function/trigger program because it is already in use by the statement that called the stored function/trigger program. '.
Error: 1443 SQLSTATE: HY000 (ER_VIEW_PREVENT_UPDATE) Message: the definition of table '%s' does not allow operation %s to be performed on table '%s'.
Error: 1444 SQLSTATE: HY000 (ER_PS_NO_RECURSION) Message: preprocessor statement contains stored subroutine calls that reference the same statement. Execution of preprocessor statements in this type of recursion is not allowed.
Error: 1445 SQLSTATE: HY000 (ER_SP_CANT_SET_AUTOCOMMIT) Message: It is not allowed to set autocommit from a stored function or trigger program.
Error: 1446 SQLSTATE: HY000 (ER_NO_VIEW_USER) Message: view definer not fully qualified.
Error: 1447 SQLSTATE: HY000 (ER_VIEW_FRM_NO_USER) Message: view %s.%s has no definer information (old table format). The current user will be treated as the definer. Please recreate the view! [Page]
Error: 1448 SQLSTATE: HY000 (ER_VIEW_OTHER_USER) Message: SUPER privileges are required to create views with %s@%s definers.
Error: 1449 SQLSTATE: HY000 (ER_NO_SUCH_USER) Message: %s@%s not registered.
Error: 1450 SQLSTATE: HY000 (ER_FORBID_SCHEMA_CHANGE) Message: changing scheme from '%s' to '%s' is not allowed.
Error: 1451 SQLSTATE: 23000 (ER_ROW_IS_REFERENCED_2) Message: cannot delete or update parent row, foreign key constraint failed (%s).
Error: 1452 SQLSTATE: 23000 (ER_NO_REFERENCED_ROW_2) Message: could not add or update child rows, foreign key constraint failed (%s).
Error: 1453 SQLSTATE: 42000 (ER_SP_BAD_VAR_SHADOW) Message: must use the...Reference a variable, or rename a variable.
Error: 1454 SQLSTATE: HY000 (ER_PARTITION_REQUIRES_VALUES_ERROR) Message: %s PARTITIONING requires VALUES %s definition for each partition.
Error: 1455 SQLSTATE: HY000 (ER_PARTITION_WRONG_VALUES_ERROR) Message: only %s PARTITIONING can use VALUES %s in partition definition.
Error: 1456 SQLSTATE: HY000 (ER_PARTITION_MAXVALUE_ERROR) Message: MAXVALUE can only be used in the last 1 partition definition.
Error: 1457 SQLSTATE: HY000 (ER_PARTITION_SUBPARTITION_ERROR) Message: subpartitions can only be hashed and keyed partitions.
Error: 1458 SQLSTATE: HY000 (ER_PARTITION_WRONG_NO_PART_ERROR) Message: The wrong number of partitions was defined, which does not match the previous setting.
Error: 1459 SQLSTATE: HY000 (ER_PARTITION_WRONG_NO_SUBPART_ERROR) Message: the wrong number of subpartitions was defined, which does not match the previous setting.
Error: 1460 SQLSTATE: HY000 (ER_CONST_EXPR_IN_PARTITION_FUNC_ERROR) Message: Constant/random expressions are not allowed in partition (subpartition) functions.
Error: 1461 SQLSTATE: HY000 (ER_NO_CONST_EXPR_IN_RANGE_OR_LIST_ERROR) Message: expressions in RANGE/LIST VALUES must be constants.
Error: 1462 SQLSTATE: HY000 (ER_FIELD_NOT_FOUND_PART_ERROR) Message: Field from the Partition Function Field List was not found in the table.
Error: 1463 SQLSTATE: HY000 (ER_LIST_OF_FIELDS_ONLY_IN_HASH_ERROR) Message: field lists are allowed only in KEY partitions.
Error: 1464 SQLSTATE: HY000 (ER_INCONSISTENT_PARTITION_INFO_ERROR) Message: The partition information in the frm file does not match what can be written to the frm file.
Error: 1465 SQLSTATE: HY000 (ER_PARTITION_FUNC_NOT_ALLOWED_ERROR) Message: %s function returned an error type.
Error: 1466 SQLSTATE: HY000 (ER_PARTITIONS_MUST_BE_DEFINED_ERROR) Message: for %s partitions, each partition must be defined.
ERROR: 1467 SQLSTATE: HY000 (ER_RANGE_NOT_INCREASING_ERROR) MESSAGE: The VALUES LESS THAN value must be strictly increased for each partition.
Error: 1468 SQLSTATE: HY000 (ER_INCONSISTENT_TYPE_OF_FUNCTIONS_ERROR) Message: the VALUES value must have the same type as the partition function.
incorrect：1469 SQLSTATE: HY000 (ER_MULTIPLE_DEF_CONST_IN_LIST_PART_ERROR) messages：Multiple definition of same constant in list partitioning
Error: 1470 SQLSTATE: HY000 (ER_PARTITION_ENTRY_ERROR) Message: The partition function cannot be used independently in a query.
Error: 1471 SQLSTATE: HY000 (ER_MIX_HANDLER_ERROR) Message: Combinations of handles in partitions are not allowed in this MySQL version. [Page]
Error: 1472 SQLSTATE: HY000 (ER_PARTITION_NOT_DEFINED_ERROR) Message: For partitioning engines it is necessary to define all %s.
Error: 1473 SQLSTATE: HY000 (ER_TOO_MANY_PARTITIONS_ERROR) Message: Too many partitions defined.
Error: 1474 SQLSTATE: HY000 (ER_SUBPARTITION_ERROR) Message: for subpartitions, only RANGE/LIST partitions can be mixed with HASH/KEY partitions.
Error: 1475 SQLSTATE: HY000 (ER_CANT_CREATE_HANDLER_FILE) Message: Unable to create specific handle file.
Error: 1476 SQLSTATE: HY000 (ER_BLOB_FIELD_IN_PART_FUNC_ERROR) Message.
Error: 1477 SQLSTATE: HY000 (ER_CHAR_SET_IN_PART_FIELD_ERROR) Message: VARCHAR is only allowed if binary proofreading is selected for the partition function.
Error: 1478 SQLSTATE: HY000 (ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF) Message: %s needs to contain all files in the partition function.
Error: 1479 SQLSTATE: HY000 (ER_NO_PARTS_ERROR) Message: number of %s = 0 is not a permitted value.
Error: 1480 SQLSTATE: HY000 (ER_PARTITION_MGMT_ON_NONPARTITIONED) Message: Unable to perform partition management on non-partitioned table.
Error: 1481 SQLSTATE: HY000 (ER_DROP_PARTITION_NON_EXISTENT) Message: the error in the partition list has changed.
Error: 1482 SQLSTATE: HY000 (ER_DROP_LAST_PARTITION) Message: Cannot delete all partitions, use DROP TABLE instead.
Error: 1483 SQLSTATE: HY000 (ER_COALESCE_ONLY_ON_HASH_PARTITION) Message: COALESCE PARTITION can only be used on HASH/KEY partitions.
Error: 1484 SQLSTATE: HY000 (ER_ONLY_ON_RANGE_LIST_PARTITION) Message: %s PARTITION can only be used on RANGE/LIST partitions.
Error: 1485 SQLSTATE: HY000 (ER_ADD_PARTITION_SUBPART_ERROR) Message: Attempted to increase partition with wrong number of subpartitions.
Error: 1486 SQLSTATE: HY000 (ER_ADD_PARTITION_NO_NEW_PARTITION) Message: At least 1 partition must be added.
Error: 1487 SQLSTATE: HY000 (ER_COALESCE_PARTITION_NO_PARTITION) Message: Must merge at least 1 partition.
Error: 1488 SQLSTATE: HY000 (ER_REORG_PARTITION_NOT_EXIST) Message: The number of partitions reorganized exceeds the number of existing partitions.