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  


Related articles: