Mysql common error code explanation

This article adds to my favorites the error messages that I often encounter during mysql development. If you need them, please refer to them.

This article adds to my favorites the error messages that I often encounter during mysql development. If you need them, please refer to them.

#1005 failed to create the table
#1006 creation failed
#1007 failed to create the database because the database already exists
#1008 failed to delete the database because the database does not exist
#1009 failed to delete the database because the database file cannot be deleted
#1010 failed to delete the database because the data directory cannot be deleted
#1011 failed to delete the database file
#1012 records in the system table cannot be read.
#1020 the record has been modified by another user
#1021 insufficient space remaining for the hard disk. please increase the available space for the hard disk
#1022 duplicate keywords, change record failed
#1023 An error occurred while disabling
#1024 file read error
#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 data table does not exist
#1054 the field does not exist
#1065 invalid SQL statement. The SQL statement is empty.
#1081 cannot establish a 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 data table does not exist
#1147 the user's access to the data table is not defined
#1149 SQL statement syntax error
#1158 network error. A read error occurs. Check the network connection status.
#1159 network error. Read timeout. Check network connection status
#1160 network error. A write error occurs. Check the network connection status.
#1161 network error, write timeout. Check network connection status
#1062 duplicate Field Values, warehouse receiving failed
#1169 the field value is repeated and the update record fails.
#1177 failed to open the data table
#1180 failed to submit the transaction
#1181 failed to roll back the transaction
#1203 The maximum number of connections established between the current user and the database to 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 due to insufficient Permissions

# MySQL 1235 version is too low and does not have this function