Error code list for MySQL database
- 2020-05-06 11:45:10
- OfStack
MySQL error code list:
1005: table creation failed
1006: database creation failed
1007: database already exists, database creation failed
1008: database does not exist, database deletion failed
1009: the database file could not be deleted, resulting in a database deletion failure
Unable to delete data directory causes database deletion failure
1011: database file deletion failed
Unable to read records
in system tables
1020: the record has been modified by another user
There is not enough space left on the hard disk. Please increase the available space on the hard disk
1022: keyword repeat, change record failure
Error
: closed
1024: read file error
Error
while changing name
1026: write file error
1032: records do not exist
1036: the data table is read-only and cannot be modified
1037: the system is out of memory, please restart the database or restart the server
1038: there is not enough memory for sorting. Please increase the sort buffer
1040: the maximum number of connections reached to the database, please increase the number of connections available to the database
1041: system out of memory
1042: invalid hostname
1043: invalid connection
1044: the current user does not have access to the database
1045: unable to connect to database, username or password error
1048: the field cannot be null
1049: database does not exist
1050: the data table already exists
1051: data table does not exist
(SQLSTATE: 42S22 )
1065: invalid SQL statement, SQL statement is empty
Unable to establish Socket connection
1114: the data table is full and cannot hold any records
1116: too many data tables open
1129: there is an exception in the database. Please restart the database
1130: connection to database failed, no permission to connect to database
1133:
does not exist for database users
1141: the current user does not have access to database
1142: the current user has no access to the data table
1143: the current user has no access to the fields
in the data table
1146: data table does not exist
1147: undefined user access to data tables
1149: SQL statement syntax error
1158: network error, read error, please check network connection status
1159: network error, read timeout, please check network connection status
1160: network error, write error, please check network connection status
1161: network error, write timeout, please check network connection status
1062: the field value is repeated, the library fails
1064: syntax errors, common as comments - without Spaces
1169: field value repeats, update record fails
1177: opening data table failed
1180: commit transaction failed
1181: rollback transaction failed
1193: variables are not declared, and
occurs when writing stored procedures
1203: the maximum number of connections made between the current user and the database has reached the database. Please increase the number of database connections available or restart the database
1205: lock timeout
1211: the current user does not have permission to create user
1216: foreign key constraint check failed, update subtable record failed
1217: foreign key constraint check failed, deletion or modification of master table record failed
1226: the current user is using more resources than allowed. Please restart the database or the server
1227: insufficient permissions, you are not authorized to do this operation
1235: MySQL version is too low to have this feature
1005: table creation failed
1006: database creation failed
1007: database already exists, database creation failed
1008: database does not exist, database deletion failed
1009: the database file could not be deleted, resulting in a database deletion failure
Unable to delete data directory causes database deletion failure
1011: database file deletion failed
Unable to read records
in system tables
1020: the record has been modified by another user
There is not enough space left on the hard disk. Please increase the available space on the hard disk
1022: keyword repeat, change record failure
Error
: closed
1024: read file error
Error
while changing name
1026: write file error
1032: records do not exist
1036: the data table is read-only and cannot be modified
1037: the system is out of memory, please restart the database or restart the server
1038: there is not enough memory for sorting. Please increase the sort buffer
1040: the maximum number of connections reached to the database, please increase the number of connections available to the database
1041: system out of memory
1042: invalid hostname
1043: invalid connection
1044: the current user does not have access to the database
1045: unable to connect to database, username or password error
1048: the field cannot be null
1049: database does not exist
1050: the data table already exists
1051: data table does not exist
(SQLSTATE: 42S22 )
1065: invalid SQL statement, SQL statement is empty
Unable to establish Socket connection
1114: the data table is full and cannot hold any records
1116: too many data tables open
1129: there is an exception in the database. Please restart the database
1130: connection to database failed, no permission to connect to database
1133:
does not exist for database users
1141: the current user does not have access to database
1142: the current user has no access to the data table
1143: the current user has no access to the fields
in the data table
1146: data table does not exist
1147: undefined user access to data tables
1149: SQL statement syntax error
1158: network error, read error, please check network connection status
1159: network error, read timeout, please check network connection status
1160: network error, write error, please check network connection status
1161: network error, write timeout, please check network connection status
1062: the field value is repeated, the library fails
1064: syntax errors, common as comments - without Spaces
1169: field value repeats, update record fails
1177: opening data table failed
1180: commit transaction failed
1181: rollback transaction failed
1193: variables are not declared, and
occurs when writing stored procedures
1203: the maximum number of connections made between the current user and the database has reached the database. Please increase the number of database connections available or restart the database
1205: lock timeout
1211: the current user does not have permission to create user
1216: foreign key constraint check failed, update subtable record failed
1217: foreign key constraint check failed, deletion or modification of master table record failed
1226: the current user is using more resources than allowed. Please restart the database or the server
1227: insufficient permissions, you are not authorized to do this operation
1235: MySQL version is too low to have this feature