1day/원데이/하루/일용직/호스팅/서버호스팅/자료실/강좌/커뮤니티
웹호스팅    |  도메인등록    |  홈페이지 관리 서비스    |   문의하기    |  강좌    |  서비스 안내 및 가격
HOME
회원로그인
ID:
PW:

     0 분
     12 분
 
웹호스팅
서비스이용안내
웹호스팅 신청방법
서비스이용약관
호스팅 신청하기
입금내용 알리기
신청리스트 *
입금리스트 *
도메인신청리스트
고객지원 FAQ
문의하기
고객지원
파일질라설정(ftp)
pop3란?
SMTP란?
아웃룩세팅법
네임서버
   1차 : ns1.1day.co.kr
..........222.234.223.31
   2차 : ns2.1day.co.kr
..........222.234.223.32
계좌번호 안내
....우리은행(원데이)
....1005-902-808446
이메일 문의
.... 1day@1day.co.kr
전화번호안내
   고객지원
   T. 050-6447-2515
자료실/강좌
HTML 태그
자바스크립트강좌
리눅스기초강좌
리눅스중급강좌
 


MySQL 에러코드별 에러메세지 입니다.
 1day  | 2005·08·16 18:08 | HIT : 396,260 | VOTE : 13,749 |
-------------------------------------------------------
mysql error code
-------------------------------------------------------

* 1000번 ~ 1050번 *

1000번 :  hashchk

1001번 :  isamchk

1002번 :O

1003번 :  YES

1004번 :  Can't create file %-.64s (errno: %d)

1005번 :  Can't create table %-.64s (errno: %d)

1006번 :  Can't create database %-.64s. (errno: %d)

1007번 :  Can't create database %-.64s. Database exists

1008번 :  Can't drop database %-.64s.   Database doesn exist

1009번 :  Error dropping database (Can't delete %-.64s errno: %d)

1010번 :  Error dropping database (Can't rmdir %-.64s errno: %d)

1011번 :  Error on delete of %-.64s (errno: %d)

1012번 :  Can't read record in system table

1013번 :  Can't gstatus of %-.64s (errno: %d)

1014번 :  Can't gworking directory (errno: %d)

1015번 :  Can't lock file (errno: %d)

1016번 :  Can't open file: %-.64s.   (errno: %d)

1017번 :  Can't find file: %-.64s (errno: %d)

1018번 :  Can't read dir of %-.64s (errno: %d)

1019번 :  Can't change dir to %-.64s (errno: %d)

1020번 :  Record has changed since last read in table %-.64s

1021번 :  Disk full (%s). Waiting for someone to free some space....

1022번 :  Can't write, duplicate key in table %-.64s

1023번 :  Error on close of %-.64s (errno: %d)

1024번 :  Error reading file %-.64s (errno: %d)

1025번 :  Error on rename of %-.64s to %-.64s (errno: %d)

1026번 :  Error writing file %-.64s (errno: %d)

1027%-.64s is locked against change

1028번 :  Sort aborted

1029번 :  View %-.64s doesn exist for %-.64s

1030번 :  Got error %d from table handler

1031번 :  able handler for %-.64s doesn have this option

1032번 :  Can't find record in %-.64s

1033번 :  Incorrect information in file: %-.64s

1034번 :  Incorrect key file for table: %-.64s.   Try to repair it

1035번 :  Old key file for table %-.64s번 :  ; Repair it!

1036번 :  able %-.64s is read only

1037번 :  Out of memory. Restart daemon and try again (needed %d bytes)

1038번 :  Out of sort memory. Increase daemon sort buffer size

1039번 :  Unexpected eof found when reading file %-.64s (errno: %d)

1040번 :  many connections

1041번 :  Out of memory; Check if mysqld or some other process uses all available memory.
                 If not you may have to use ulimit to allow mysqld to use more memory or you can add more swap space

1042번 :  Can't ghostname for your address

1043번 :  Bad handshake

1044번 :  Access denied for user: %-.32s@%-.64s to database %-.64s

1045번 :  Access denied for user: %-.32s@%-.64s (Using password: %s)

1046번 :o Database Selected

1047번 :  Unknown command

1048번 :  Column %-.64s cannot be null

1049번 :  Unknown database %-.64s

1050번 :  able %-.64s already exists


* 1051번 ~ 1100번 *

1051번 :  Unknown table %-.64s

1052번 :  Column: %-.64s in %-.64s is ambiguous

1053번 :  Server shutdown in progress

1054번 :  Unknown column %-.64s in %-.64s

1055번 :  %-.64s isn in GROUP BY

1056번 :  Can't group on %-.64s

1057번 :  Statement has sum functions and columns in same statement

1058번 :  Column count doesn match value count

1059번 :  Identifier name %-.100s is tlong

1060번 :  Duplicate column name %-.64s

1061번 :  Duplicate key name %-.64s

1062번 :  Duplicate entry %-.64s for key %d

1063번 :  Incorrect column specifier for column %-.64s

1064번 :  %s near %-.80s at line %d

1065번 :  Query was empty

1066번 :ot unique table/alias: %-.64s

1067번 :  Invalid default value for %-.64s

1068번 :  Multiple primary key defined

1069번 :  many keys specified. Max %d keys allowed

1070번 :  many key parts specified. Max %d parts allowed

1071번 :  Specified key was tlong. Max key length is %d

1072번 :  Key column %-.64s doesn exist in table

1073번 :  BLOB column %-.64s Can't be used in key specification with the used table type

1074번 :  big column length for column %-.64s (max = %d). Use BLOB instead

1075번 :  Incorrect table definition;
                 There can only be one auto column and it must be defined as a key

1076번 :  %s: ready for connections

1077번 :  %s: Normal shutdown번

1078번 :  %s: Got signal %d. Aborting!

1079번 :  %s: Shutdown Complete번 :

1080번 :  %s: Forcing close of thread %ld user: %-.32s

1081번 :  Can't create IP socket

1082번 :  able %-.64s has no index like the one used in CREATE INDEX. Recreate the table

1083번 :  Field separator argument is not what is expected. Check the manual

1084번 :  You Can't use fixed rowlength with BLOBs. Please use fields terminated by.  

1085번 :  he file %-.64s must be in the database directory or be readable by all

1086번 :  File %-.80s already exists

1087번 :  Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld

1088번 :  Records: %ld Duplicates: %ld

1089번 :  Incorrect sub part key.
                 The used key part isn a string, the used length is longer than the key part or the table handler doesn      support unique sub keys

1090번 :  You Can't delete all columns with ALTER TABLE. Use DROP TABLE instead

1091번 :  Can't DROP %-.64s. Check that column/key exists

1092번 :  Records: %ld Duplicates: %ld Warnings: %ld

1093번 :  INSERT TABLE %-.64s isn allowed in FROM table list

1094번 :  Unknown thread id: %lu

1095번 :  You are not owner of thread %lu

1096번 :o tables used

1097번 :  many strings for column %-.64s and SET

1098번 :  Can't generate a unique log-filename %-.64s.(1-999)

1099번 :  able %-.64s was locked with a READ lock and Can't be updated

1100번 :  able %-.64s was not locked with LOCK TABLES


* 1101번 ~ 1150번 *

1101번 :  BLOB column %-.64s Can't have a default value

1102번 :  Incorrect database name %-.100s

1103번 :  Incorrect table name %-.100s

1104번 :  he SELECT would examine tmany records and probably take a very long time.
                 Check your WHERE and use SOPTION SQL_BIG_SELECTS=1 if the SELECT is ok

1105번 :  Unknown error

1106번 :  Unknown procedure %-.64s

1107번 :  Incorrect parameter count to procedure %-.64s

1108번 :  Incorrect parameters to procedure %-.64s

1109번 :  Unknown table %-.64s in %-.32s

1110번 :  Column %-.64s specified twice

1111번 :  Invalid use of group function

1112번 :  able %-.64s uses an extension that doesn exist in this MySQL version

1113번 :  A table must have at least 1 column

1114번 :  he table %-.64s is full

1115번 :  Unknown character set: %-.64s

1116번 :  many tables. MySQL can only use %d tables in a join

1117번 :  many columns

1118번 :  big row size. The maximum row size, not counting BLOBs, is %d.
                 You have to change some fields to BLOBs

1119번 :  hread stack overrun: Used: %ld of a %ld stack.
                 Use mysqld -O thread_stack=# to specify a bigger stack if needed

1120번 :  Cross dependency found in OUTER JOIN. Examine your ON conditions

1121번 :  Column %-.64s is used with UNIQUE or INDEX but is not defined as NOT NULL

1122번 :  Can't load function %-.64s

1123번 :  Can't initialize function %-.64s번 :  ; %-.80s

1124번 :o paths allowed for shared library

1125번 :  Function %-.64s already exist

1126번 :  Can't open shared library %-.64s (errno: %d %-.64s)

1127번 :  Can't find function %-.64s in library

1128번 :  Function %-.64s is not defined

1129번 :  Host %-.64s is blocked because of many connection errors.
                 Unblock with mysqladmin flush-hosts

1130번 :  Host %-.64s is not allowed to connect to this MySQL server

1131번 :  You are using MySQL as an anonymous users and anonymous users are not allowed to change passwords

1132번 :  You must have privileges to update tables in the mysql database to be able to change passwords for others

1133번 :  Can't find any matching row in the user table

1134번 :  Rows matched: %ld Changed: %ld Warnings: %ld

1135번 :  Can't create a new thread (errno %d).
                 If you are not out of available memory, you can consult the manual for a possible OS-dependent bug

1136번 :  Column count doesn match value count at row %ld

1137번 :  Can't reopen table: %-.64s

1138번 :  Invalid use of NULL value

1139번 :  Got error %-.64s from regexp

1140번 :  Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause

1141번 :  here is no such grant defined for user %-.32s on host %-.64s

1142번 :  %-.16s command denied to user: %-.32s@%-.64s for table %-.64s

1143번 :  %-.16s command denied to user: %-.32s@%-.64s for column %-.64s in table %-.64s

1144번 :  Illegal GRANT/REVOKE command. Please consult the manual which privileges can be used.

1145번 :  he host or user argument to GRANT is tlong

1146번 :  able %-.64s.%-.64s doesn exist

1147번 :  here is no such grant defined for user %-.32s on host %-.64s on table %-.64s

1148번 :  he used command is not allowed with this MySQL version

1149번 :  You have an error in your SQL syntax

1150번 :  Delayed insert thread couldn grequested lock for table %-.64s


* 1151번 ~ 1200번 *

1151번 :  many delayed threads in use

1152번 :  Aborted connection %ld to db: %-.64s user: %-.32s (%-.64s)

1153번 :  Got a packbigger than 번 :  max_allowed_packet

1154번 :  Got a read error from the connection pipe

1155번 :  Got an error from fcntl()

1156번 :  Got packets out of order

1157번 :  Couldn uncompress communication packet

1158번 :  Got an error reading communication packets

1159번 :  Got timeout reading communication packets

1160번 :  Got an error writing communication packets

1161번 :  Got timeout writing communication packets

1162번 :  Result string is longer than max_allowed_packet

1163번 :  he used table type doesn support BLOB/TEXT columns

1164번 :  he used table type doesn support AUTO_INCREMENT columns

1165번 :  INSERT DELAYED Can't be used with table %-.64s because it is locked with LOCK TABLES

1166번 :  Incorrect column name %-.100s

1167번 :  he used table handler Can't index column %-.64s

1168번 :  All tables in the MERGE table are not identically defined

1169번 :  Can't write, because of unique constraint, to table %-.64s

1170번 :  BLOB column %-.64s used in key specification without a key length

1171번 :  All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

1172번 :  Result consisted of more than one row

1173번 :  his table type requires a primary key

1174번 :  his version of MySQL is not compiled with RAID support

1175번 :  You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

1176번 :  Key %-.64s doesn exist in table %-.64s

1177번 :  Can't open table

1178번 :  he handler for the table doesn support check/repair

1179번 :  You are not allowed to execute this command in a transaction

1180번 :  Got error %d during COMMIT

1181번 :  Got error %d during ROLLBACK

1182번 :  Got error %d during FLUSH_LOGS

1183번 :  Got error %d during CHECKPOINT

1184번 :  Aborted connection %ld to db: %-.64s user: %-.32s host: `%-.64s (%-.64s)

1185번 :  he handler for the table does not support binary table dump

1186번 :  Binlog closed, cannot RESMASTER

1187번 :  Failed rebuilding the index of dumped table %-.64s

1188번 :  Error from master: %-.64s

1189번 :  error reading from master

1190번 :  error writing to master

1191번 :  Can't find FULLTEXT index matching the column list

1192번 :  Can't execute the given command because you have active locked tables or an active transaction

1193번 :  Unknown system variable %-.64

1194번 :  able %-.64s is marked as crashed and should be repaired

1195번 :  able %-.64s is marked as crashed and last (automatic?) repair failed

1196번 :  Warning: Some non-transactional changed tables couldn be rolled back

1197번 :  Multi-statement transaction required more than   max_binlog_cache_size bytes of storage. Increase this mysqld variable and try again

1198번 :  his operation cannot be performed with a running slave, run SLAVE STOP first

1199번 :  his operation requires a running slave, configure slave and do SLAVE START


* 1200번 ~ 1217번 *

1200번 :  he server is not configured as slave, fix in config file or with CHANGE MASTER TO

1201번 :  Could not initialize master info structure, check permisions on master.info

1202번 :  Could not create slave thread, check system resources

1203번 :  User %-.64s has already more than max_user_connections active connections

1204번 :  You may only use constant expressions with SET

1205번 :  Lock wait timeout exceeded; Try restarting transaction

1206번 :  he total number of locks exceeds the lock table size

1207번 :  Update locks cannot be acquired during a READ UNCOMMITTED transaction

1208번 :  DROP DATABASE not allowed while thread is holding global read lock

1209번 :  CREATE DATABASE not allowed while thread is holding global read lock

1210번 :  Wrong arguments to %s

1211번 :  %-.32s@%-.64s is not allowed to create new users

1212번 :  Incorrect table definition; All MERGE tables must be in the same database

1213번 :  Deadlock found when trying to glock; Try restarting transaction

1214번 :  he used table type doesn support FULLTEXT indexes

1215번 :  Cannot add foreign key constraint

1216번 :  Cannot add a child row: a foreign key constraint fails

1217번 :  Cannot delete a parent row: a foreign key constraint fails


출처 : 데이터베이스.sarang.net/
         -------------------------------------------------------
mysql error code
-------------------------------------------------------

* 1000번 ~ 1050번 *

1000번 :  hashchk

1001번 :  isamchk

1002번 :O

1003번 :  YES

1004번 :  Can't create file %-.64s (errno: %d)

1005번 :  Can't create table %-.64s (errno: %d)

1006번 :  Can't create database %-.64s. (errno: %d)

1007번 :  Can't create database %-.64s. Database exists

1008번 :  Can't drop database %-.64s.   Database doesn exist

1009번 :  Error dropping database (Can't delete %-.64s errno: %d)

1010번 :  Error dropping database (Can't rmdir %-.64s errno: %d)

1011번 :  Error on delete of %-.64s (errno: %d)

1012번 :  Can't read record in system table

1013번 :  Can't gstatus of %-.64s (errno: %d)

1014번 :  Can't gworking directory (errno: %d)

1015번 :  Can't lock file (errno: %d)

1016번 :  Can't open file: %-.64s.   (errno: %d)

1017번 :  Can't find file: %-.64s (errno: %d)

1018번 :  Can't read dir of %-.64s (errno: %d)

1019번 :  Can't change dir to %-.64s (errno: %d)

1020번 :  Record has changed since last read in table %-.64s

1021번 :  Disk full (%s). Waiting for someone to free some space....

1022번 :  Can't write, duplicate key in table %-.64s

1023번 :  Error on close of %-.64s (errno: %d)

1024번 :  Error reading file %-.64s (errno: %d)

1025번 :  Error on rename of %-.64s to %-.64s (errno: %d)

1026번 :  Error writing file %-.64s (errno: %d)

1027%-.64s is locked against change

1028번 :  Sort aborted

1029번 :  View %-.64s doesn exist for %-.64s

1030번 :  Got error %d from table handler

1031번 :  able handler for %-.64s doesn have this option

1032번 :  Can't find record in %-.64s

1033번 :  Incorrect information in file: %-.64s

1034번 :  Incorrect key file for table: %-.64s.   Try to repair it

1035번 :  Old key file for table %-.64s번 :  ; Repair it!

1036번 :  able %-.64s is read only

1037번 :  Out of memory. Restart daemon and try again (needed %d bytes)

1038번 :  Out of sort memory. Increase daemon sort buffer size

1039번 :  Unexpected eof found when reading file %-.64s (errno: %d)

1040번 :  many connections

1041번 :  Out of memory; Check if mysqld or some other process uses all available memory.
                 If not you may have to use ulimit to allow mysqld to use more memory or you can add more swap space

1042번 :  Can't ghostname for your address

1043번 :  Bad handshake

1044번 :  Access denied for user: %-.32s@%-.64s to database %-.64s

1045번 :  Access denied for user: %-.32s@%-.64s (Using password: %s)

1046번 :o Database Selected

1047번 :  Unknown command

1048번 :  Column %-.64s cannot be null

1049번 :  Unknown database %-.64s

1050번 :  able %-.64s already exists


* 1051번 ~ 1100번 *

1051번 :  Unknown table %-.64s

1052번 :  Column: %-.64s in %-.64s is ambiguous

1053번 :  Server shutdown in progress

1054번 :  Unknown column %-.64s in %-.64s

1055번 :  %-.64s isn in GROUP BY

1056번 :  Can't group on %-.64s

1057번 :  Statement has sum functions and columns in same statement

1058번 :  Column count doesn match value count

1059번 :  Identifier name %-.100s is tlong

1060번 :  Duplicate column name %-.64s

1061번 :  Duplicate key name %-.64s

1062번 :  Duplicate entry %-.64s for key %d

1063번 :  Incorrect column specifier for column %-.64s

1064번 :  %s near %-.80s at line %d

1065번 :  Query was empty

1066번 :ot unique table/alias: %-.64s

1067번 :  Invalid default value for %-.64s

1068번 :  Multiple primary key defined

1069번 :  many keys specified. Max %d keys allowed

1070번 :  many key parts specified. Max %d parts allowed

1071번 :  Specified key was tlong. Max key length is %d

1072번 :  Key column %-.64s doesn exist in table

1073번 :  BLOB column %-.64s Can't be used in key specification with the used table type

1074번 :  big column length for column %-.64s (max = %d). Use BLOB instead

1075번 :  Incorrect table definition;
                 There can only be one auto column and it must be defined as a key

1076번 :  %s: ready for connections

1077번 :  %s: Normal shutdown번

1078번 :  %s: Got signal %d. Aborting!

1079번 :  %s: Shutdown Complete번 :

1080번 :  %s: Forcing close of thread %ld user: %-.32s

1081번 :  Can't create IP socket

1082번 :  able %-.64s has no index like the one used in CREATE INDEX. Recreate the table

1083번 :  Field separator argument is not what is expected. Check the manual

1084번 :  You Can't use fixed rowlength with BLOBs. Please use fields terminated by.  

1085번 :  he file %-.64s must be in the database directory or be readable by all

1086번 :  File %-.80s already exists

1087번 :  Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld

1088번 :  Records: %ld Duplicates: %ld

1089번 :  Incorrect sub part key.
                 The used key part isn a string, the used length is longer than the key part or the table handler doesn      support unique sub keys

1090번 :  You Can't delete all columns with ALTER TABLE. Use DROP TABLE instead

1091번 :  Can't DROP %-.64s. Check that column/key exists

1092번 :  Records: %ld Duplicates: %ld Warnings: %ld

1093번 :  INSERT TABLE %-.64s isn allowed in FROM table list

1094번 :  Unknown thread id: %lu

1095번 :  You are not owner of thread %lu

1096번 :o tables used

1097번 :  many strings for column %-.64s and SET

1098번 :  Can't generate a unique log-filename %-.64s.(1-999)

1099번 :  able %-.64s was locked with a READ lock and Can't be updated

1100번 :  able %-.64s was not locked with LOCK TABLES


* 1101번 ~ 1150번 *

1101번 :  BLOB column %-.64s Can't have a default value

1102번 :  Incorrect database name %-.100s

1103번 :  Incorrect table name %-.100s

1104번 :  he SELECT would examine tmany records and probably take a very long time.
                 Check your WHERE and use SOPTION SQL_BIG_SELECTS=1 if the SELECT is ok

1105번 :  Unknown error

1106번 :  Unknown procedure %-.64s

1107번 :  Incorrect parameter count to procedure %-.64s

1108번 :  Incorrect parameters to procedure %-.64s

1109번 :  Unknown table %-.64s in %-.32s

1110번 :  Column %-.64s specified twice

1111번 :  Invalid use of group function

1112번 :  able %-.64s uses an extension that doesn exist in this MySQL version

1113번 :  A table must have at least 1 column

1114번 :  he table %-.64s is full

1115번 :  Unknown character set: %-.64s

1116번 :  many tables. MySQL can only use %d tables in a join

1117번 :  many columns

1118번 :  big row size. The maximum row size, not counting BLOBs, is %d.
                 You have to change some fields to BLOBs

1119번 :  hread stack overrun: Used: %ld of a %ld stack.
                 Use mysqld -O thread_stack=# to specify a bigger stack if needed

1120번 :  Cross dependency found in OUTER JOIN. Examine your ON conditions

1121번 :  Column %-.64s is used with UNIQUE or INDEX but is not defined as NOT NULL

1122번 :  Can't load function %-.64s

1123번 :  Can't initialize function %-.64s번 :  ; %-.80s

1124번 :o paths allowed for shared library

1125번 :  Function %-.64s already exist

1126번 :  Can't open shared library %-.64s (errno: %d %-.64s)

1127번 :  Can't find function %-.64s in library

1128번 :  Function %-.64s is not defined

1129번 :  Host %-.64s is blocked because of many connection errors.
                 Unblock with mysqladmin flush-hosts

1130번 :  Host %-.64s is not allowed to connect to this MySQL server

1131번 :  You are using MySQL as an anonymous users and anonymous users are not allowed to change passwords

1132번 :  You must have privileges to update tables in the mysql database to be able to change passwords for others

1133번 :  Can't find any matching row in the user table

1134번 :  Rows matched: %ld Changed: %ld Warnings: %ld

1135번 :  Can't create a new thread (errno %d).
                 If you are not out of available memory, you can consult the manual for a possible OS-dependent bug

1136번 :  Column count doesn match value count at row %ld

1137번 :  Can't reopen table: %-.64s

1138번 :  Invalid use of NULL value

1139번 :  Got error %-.64s from regexp

1140번 :  Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause

1141번 :  here is no such grant defined for user %-.32s on host %-.64s

1142번 :  %-.16s command denied to user: %-.32s@%-.64s for table %-.64s

1143번 :  %-.16s command denied to user: %-.32s@%-.64s for column %-.64s in table %-.64s

1144번 :  Illegal GRANT/REVOKE command. Please consult the manual which privileges can be used.

1145번 :  he host or user argument to GRANT is tlong

1146번 :  able %-.64s.%-.64s doesn exist

1147번 :  here is no such grant defined for user %-.32s on host %-.64s on table %-.64s

1148번 :  he used command is not allowed with this MySQL version

1149번 :  You have an error in your SQL syntax

1150번 :  Delayed insert thread couldn grequested lock for table %-.64s


* 1151번 ~ 1200번 *

1151번 :  many delayed threads in use

1152번 :  Aborted connection %ld to db: %-.64s user: %-.32s (%-.64s)

1153번 :  Got a packbigger than 번 :  max_allowed_packet

1154번 :  Got a read error from the connection pipe

1155번 :  Got an error from fcntl()

1156번 :  Got packets out of order

1157번 :  Couldn uncompress communication packet

1158번 :  Got an error reading communication packets

1159번 :  Got timeout reading communication packets

1160번 :  Got an error writing communication packets

1161번 :  Got timeout writing communication packets

1162번 :  Result string is longer than max_allowed_packet

1163번 :  he used table type doesn support BLOB/TEXT columns

1164번 :  he used table type doesn support AUTO_INCREMENT columns

1165번 :  INSERT DELAYED Can't be used with table %-.64s because it is locked with LOCK TABLES

1166번 :  Incorrect column name %-.100s

1167번 :  he used table handler Can't index column %-.64s

1168번 :  All tables in the MERGE table are not identically defined

1169번 :  Can't write, because of unique constraint, to table %-.64s

1170번 :  BLOB column %-.64s used in key specification without a key length

1171번 :  All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

1172번 :  Result consisted of more than one row

1173번 :  his table type requires a primary key

1174번 :  his version of MySQL is not compiled with RAID support

1175번 :  You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

1176번 :  Key %-.64s doesn exist in table %-.64s

1177번 :  Can't open table

1178번 :  he handler for the table doesn support check/repair

1179번 :  You are not allowed to execute this command in a transaction

1180번 :  Got error %d during COMMIT

1181번 :  Got error %d during ROLLBACK

1182번 :  Got error %d during FLUSH_LOGS

1183번 :  Got error %d during CHECKPOINT

1184번 :  Aborted connection %ld to db: %-.64s user: %-.32s host: `%-.64s (%-.64s)

1185번 :  he handler for the table does not support binary table dump

1186번 :  Binlog closed, cannot RESMASTER

1187번 :  Failed rebuilding the index of dumped table %-.64s

1188번 :  Error from master: %-.64s

1189번 :  error reading from master

1190번 :  error writing to master

1191번 :  Can't find FULLTEXT index matching the column list

1192번 :  Can't execute the given command because you have active locked tables or an active transaction

1193번 :  Unknown system variable %-.64

1194번 :  able %-.64s is marked as crashed and should be repaired

1195번 :  able %-.64s is marked as crashed and last (automatic?) repair failed

1196번 :  Warning: Some non-transactional changed tables couldn be rolled back

1197번 :  Multi-statement transaction required more than   max_binlog_cache_size bytes of storage. Increase this mysqld variable and try again

1198번 :  his operation cannot be performed with a running slave, run SLAVE STOP first

1199번 :  his operation requires a running slave, configure slave and do SLAVE START


* 1200번 ~ 1217번 *

1200번 :  he server is not configured as slave, fix in config file or with CHANGE MASTER TO

1201번 :  Could not initialize master info structure, check permisions on master.info

1202번 :  Could not create slave thread, check system resources

1203번 :  User %-.64s has already more than max_user_connections active connections

1204번 :  You may only use constant expressions with SET

1205번 :  Lock wait timeout exceeded; Try restarting transaction

1206번 :  he total number of locks exceeds the lock table size

1207번 :  Update locks cannot be acquired during a READ UNCOMMITTED transaction

1208번 :  DROP DATABASE not allowed while thread is holding global read lock

1209번 :  CREATE DATABASE not allowed while thread is holding global read lock

1210번 :  Wrong arguments to %s

1211번 :  %-.32s@%-.64s is not allowed to create new users

1212번 :  Incorrect table definition; All MERGE tables must be in the same database

1213번 :  Deadlock found when trying to glock; Try restarting transaction

1214번 :  he used table type doesn support FULLTEXT indexes

1215번 :  Cannot add foreign key constraint

1216번 :  Cannot add a child row: a foreign key constraint fails

1217번 :  Cannot delete a parent row: a foreign key constraint fails


출처 : 데이터베이스.sarang.net/
        
     
  MySQL 에러코드별 에러메세지 입니다.  1day 05·08·16 396260
14   인터넷의 뿌리 TCP/IP 네트워크 바로알기  1day 04·02·12 21283
13   레드햇 시스템 최신으로 유지하기  1day 04·02·03 21006
12   Sendmail 메일서버의 스팸릴레이 대응방법  1day 04·02·01 22312
11   침해사고 대응방법 및 절차  1day 04·02·01 21096
10   네트워크 스니핑 기술 및 방지대책  1day 04·02·01 22425
9   윈도우 NT서버 및 IIS 보안 관리  1day 04·02·01 26682
8   Solaris Network Kernel Tunning for Security  1day 04·01·31 24554
7   안전한 유닉스 프로그래밍을 위한 지침서 V.0.7  1day 04·01·30 22829
6   Abnormal IP Packets  1day 04·01·28 23858
5   DNS 안전운용가이드  1day 04·01·20 23510
4   MTX 웜바이러스 분석 보고서  1day 04·01·17 21701
3   IP Fragmentation을 이용한 공격기술들  1day 04·01·14 22626
2   리눅스 시스템 관리자를 위한 보안 지침Ⅰ  1day 04·01·14 21229
1   운영체제와 커널 차원에서의 튜닝 및 보..  1day 04·01·11 21226
1
Copyright 1999-2018 Zeroboard / skin by GGAMBO
Copyright (c) 2003~2004 by 1day all rights reserved.