MySQL 오류 코드

• 1045Access denied for user (using password: YES/NO)
• 1062Duplicate entry for key
• 1213Deadlock found when trying to get lock; try restarting transaction
• 1205Lock wait timeout exceeded; try restarting transaction
• 1040Too many connections
• 1064You have an error in your SQL syntax
• 1146Table doesn't exist
• 1054Unknown column in field list
• 2002Can't connect to local MySQL server through socket
• 2003Can't connect to MySQL server (TCP/IP)
• 2006MySQL server has gone away
• 1114The table is full
• 1215Cannot add foreign key constraint
• 1451Cannot delete or update a parent row: a foreign key constraint fails
• 1452Cannot add or update a child row: a foreign key constraint fails
• 1366Incorrect string/integer value for column
• 1044Access denied for user to database
• 1264Out of range value for column
• 1052Column 'x' in field list is ambiguous
• 1136Column count doesn't match value count
• 1048Column 'x' cannot be null
• 1292Incorrect datetime value / truncated incorrect value
• 1406Data too long for column
• 1071Specified key was too long; max key length is 767 bytes
• 1050Table already exists
• 1051Unknown table 'x'
• 1091Can't DROP 'x'; check that column/key exists
• 1093You can't specify target table 'x' for update in FROM clause
• 1305PROCEDURE does not exist
• 1227Access denied; you need (at least one of) the PRIVILEGE
• 3730Cannot drop table referenced by a foreign key constraint
• 2013Lost connection to MySQL server during query
• 1153Got a packet bigger than 'max_allowed_packet' bytes
• 1969MariaDB: Query execution was interrupted (max_statement_time exceeded)
• 1927MariaDB: ER_CONNECTION_KILLED: Connection was killed (연결이 종료됨)
• 1290ER_OPTION_PREVENTS_STATEMENT: running with the --read-only option (--read-only 옵션으로 실행 중)
• 1836ER_READ_ONLY_MODE: Running in read-only mode (읽기 전용 모드로 실행 중)
• 3819ER_CHECK_CONSTRAINT_VIOLATED: Check constraint is violated (CHECK 제약 조건 위반)
• 1118ER_TOO_BIG_ROWSIZE: Row size too large
• 1170ER_BLOB_KEY_WITHOUT_LENGTH: BLOB/TEXT column used in key specification without a key length (키 길이 없이 BLOB/TEXT 컬럼을 키에 사용함)
• 1592ER_BINLOG_UNSAFE_STATEMENT: Unsafe statement written to the binary log (binary log에 안전하지 않은 문장 기록)
• 3140ER_INVALID_JSON_TEXT: Invalid JSON text
• 1526ER_NO_PARTITION_FOR_GIVEN_VALUE: Table has no partition for value (해당 값에 대한 파티션 없음)
• 1049Unknown database 'name'
• 1364Field 'name' doesn't have a default value (필드에 기본값 없음)
• 1206The total number of locks exceeds the lock table size (전체 락 수가 락 테이블 크기 초과)
• 1236Got fatal error 1236 from master when reading data from binary log (binary log 읽기 중 master로부터 치명적 오류 1236 수신)
• 1129Host 'host' is blocked because of many connection errors (연결 오류가 많아 호스트 차단됨)
• 1194Table 'name' is marked as crashed and should be repaired (테이블이 crashed로 표시되어 복구 필요)
• 1615Prepared statement needs to be re-prepared (prepared statement 재준비 필요)
• 1553Cannot drop index needed in a foreign key constraint (외래 키 제약 조건에 필요한 인덱스 삭제 불가)
• 3948Loading local data is disabled; this must be enabled on both the client and server sides (로컬 데이터 로드가 비활성화됨. 클라이언트와 서버 양쪽에서 활성화 필요)
• 1075Incorrect table definition; there can be only one auto column and it must be defined as a key (잘못된 테이블 정의. auto 컬럼은 하나만 가능하며 키로 정의해야 함)
• 1055Expression not in GROUP BY (only_full_group_by) (GROUP BY에 없는 표현식)
• 1267Illegal mix of collations
• 1030Got error N from storage engine
• 1197Multi-statement transaction required more than 'max_binlog_cache_size' (다중 문장 트랜잭션이 'max_binlog_cache_size'보다 많은 공간을 요구함)
• 1785Statement violates GTID consistency
• 3024Query execution was interrupted, maximum statement execution time exceeded (쿼리 실행이 중단됨. 최대 문장 실행 시간 초과)
• 1298Unknown or incorrect time zone
• 1418Function has none of DETERMINISTIC, NO SQL, or READS SQL DATA (binary logging enabled) (함수에 DETERMINISTIC, NO SQL, READS SQL DATA 중 어느 것도 없음)
• 1231Variable can't be set to the value of ... (변수를 해당 값으로 설정할 수 없음)