Error Code List of MySQL database

MySQL Error Code List:

1005: An error occurred while creating the table.

1006: database creation failed

1007: the database already exists. An error occurred while creating the database.

1008: the database does not exist. An error occurred while deleting the database.

1009: the database file cannot be deleted, leading to database deletion failure.

1010: failed to delete database because the data directory cannot be deleted

1011: An error occurred while deleting the database file.

1012: records in the system table cannot be read.

1020: the record has been modified by another user

1021: The remaining space on the hard disk is insufficient. please increase the available space on the hard disk.

1022: duplicate keywords. failed to change the record

1023: An error occurred while disabling the service.

1024: An error occurred while reading the file.

1025: An error occurred while changing the name

1026: file write error

1032: the record does not exist

1036: The data table is read-only and cannot be modified.

1037: The system memory is insufficient. Restart the database or restart the server.

1038: the memory used for sorting is insufficient. Increase the sorting buffer.

1040: Maximum number of connections to the database. Increase the number of available connections to the database.

1041: insufficient system memory

1042: Invalid Host Name

1043: Invalid connection

1044: the current user is not authorized to access the database

1045: the database cannot be connected. The user name or password is incorrect.

1048: The field cannot be blank

1049: the database does not exist.

1050: The data table already exists.

1051: The data table does not exist.

1054: The field does not exist (sqlstate: 42s22)

1065: Invalid SQL statement. The SQL statement is empty.

1081: cannot establish socket connection

1114: The data table is full and cannot accommodate any records

1116: too many open data tables

1129: Database exception. Restart the database.

1130: failed to connect to the database. You are not authorized to connect to the database.

1133: the 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 fields in the data table.

1146: The data table does not exist.

1147: the user's access permission to the data table is not defined.

1149: SQL statement syntax error

1158: network error. Read error. Check the network connection status.

1159: network error. Read timeout. Check the network connection status.

1160: network error. A write error occurs. Check the network connection status.

1161: network error. Write timeout. Check the network connection status.

1062: The field value is repeated and the Database Import fails.

1064: syntax error. Common Errors include comments without spaces.

1169: The field value is repeated and the update record fails.

1177: An error occurred while opening the data table.

1180: Transaction submission failed

1181: Transaction rollback failed

1193: the variable is not declared and often occurs when the stored procedure is written.

1203: the maximum number of connections established between the current user and the database to reach the database. Increase the number of available database connections or restart the database.

1205: lock timeout

1211: the current user does not have the permission to create a user

1216: failed to check foreign key constraints and failed to update sub-table records

1217: failed to check foreign key constraints, failed to delete or modify the primary Table Record

1226: The resource used by the current user has exceeded the allowed resource. Please restart the database or the server.

1227: You are not authorized to perform this operation.

1235: mysql version is too low and does not have this function