Mysql错误代码大全.docx
《Mysql错误代码大全.docx》由会员分享,可在线阅读,更多相关《Mysql错误代码大全.docx(28页珍藏版)》请在冰豆网上搜索。
Mysql错误代码大全
Mysql错误代码大全
Mysql错误代码
Mysql错误代码分为两部分,老版本一部分,4.1版本为新的部分
第一部分:
mysql的出错代码表,根据mysql的头文件mysql/include/mysqld_error.h整理而成
1005:
创建表失败
1006:
创建数据库失败
1007:
数据库已存在,创建数据库失败
1008:
数据库不存在,删除数据库失败
1009:
不能删除数据库文件导致删除数据库失败
1010:
不能删除数据目录导致删除数据库失败
1011:
删除数据库文件失败
1012:
不能读取系统表中的记录
1020:
记录已被其他用户修改
1021:
硬盘剩余空间不足,请加大硬盘可用空间
1022:
关键字重复,更改记录失败
1023:
关闭时发生错误
1024:
读文件错误
1025:
更改名字时发生错误
1026:
写文件错误
1032:
记录不存在
1036:
数据表是只读的,不能对它进行修改
1037:
系统内存不足,请重启数据库或重启服务器
1038:
用于排序的内存不足,请增大排序缓冲区
1040:
已到达数据库的最大连接数,请加大数据库可用连接数
1041:
系统内存不足
1042:
无效的主机名
1043:
无效连接
1044:
当前用户没有访问数据库的权限
1045:
不能连接数据库,用户名或密码错误
1048:
字段不能为空
1049:
数据库不存在
1050:
数据表已存在
1051:
数据表不存在
1054:
字段不存在
1065:
无效的SQL语句,SQL语句为空
1081:
不能建立Socket连接
1114:
数据表已满,不能容纳任何记录
1116:
打开的数据表太多
1129:
数据库出现异常,请重启数据库
1130:
连接数据库失败,没有连接数据库的权限
1133:
数据库用户不存在
1141:
当前用户无权访问数据库
1142:
当前用户无权访问数据表
1143:
当前用户无权访问数据表中的字段
1146:
数据表不存在
1147:
未定义用户对数据表的访问权限
1149:
SQL语句语法错误
1158:
网络错误,出现读错误,请检查网络连接状况
1159:
网络错误,读超时,请检查网络连接状况
1160:
网络错误,出现写错误,请检查网络连接状况
1161:
网络错误,写超时,请检查网络连接状况
1062:
字段值重复,入库失败
1169:
字段值重复,更新记录失败
1177:
打开数据表失败
1180:
提交事务失败
1181:
回滚事务失败
1203:
当前用户和数据库建立的连接已到达数据库的最大连接数,请增大可用的数据库连接数或重启数据库
1205:
加锁超时
1211:
当前用户没有创建用户的权限
1216:
外键约束检查失败,更新子表记录失败
1217:
外键约束检查失败,删除或修改主表记录失败
1226:
当前用户使用的资源已超过所允许的资源,请重启数据库或重启服务器
1227:
权限不足,您无权进行此操作
1235:
MySQL版本过低,不具有本功能
第二部分新4.1.11,摘自DOCSmysqld_error.txt
character-set=utf-8isher补充
#defineER_HASHCHK1000
"hashchk",
#defineER_NISAMCHK1001
"isamchk",
#defineER_NO1002
"NO",
#defineER_YES1003
"YES",
#defineER_CANT_CREATE_FILE1004
"Can'tcreatefile'%-.64s'(errno:
%d)",
#defineER_CANT_CREATE_TABLE1005
"Can'tcreatetable'%-.64s'(errno:
%d)",
#defineER_CANT_CREATE_DB1006
"Can'tcreatedatabase'%-.64s'(errno:
%d)",
#defineER_DB_CREATE_EXISTS1007
"Can'tcreatedatabase'%-.64s';databaseexists",
#defineER_DB_DROP_EXISTS1008
"Can'tdropdatabase'%-.64s';databasedoesn'texist",
#defineER_DB_DROP_DELETE1009
"Errordroppingdatabase(can'tdelete'%-.64s',errno:
%d)",
#defineER_DB_DROP_RMDIR1010
"Errordroppingdatabase(can'trmdir'%-.64s',errno:
%d)",
#defineER_CANT_DELETE_FILE1011
"Errorondeleteof'%-.64s'(errno:
%d)",
#defineER_CANT_FIND_SYSTEM_REC1012
"Can'treadrecordinsystemtable",
#defineER_CANT_GET_STAT1013
"Can'tgetstatusof'%-.64s'(errno:
%d)",
#defineER_CANT_GET_WD1014
"Can'tgetworkingdirectory(errno:
%d)",
#defineER_CANT_LOCK1015
"Can'tlockfile(errno:
%d)",
#defineER_CANT_OPEN_FILE1016
"Can'topenfile:
'%-.64s'(errno:
%d)",
#defineER_FILE_NOT_FOUND1017
"Can'tfindfile:
'%-.64s'(errno:
%d)",
#defineER_CANT_READ_DIR1018
"Can'treaddirof'%-.64s'(errno:
%d)",
#defineER_CANT_SET_WD1019
"Can'tchangedirto'%-.64s'(errno:
%d)",
#defineER_CHECKREAD1020
"Recordhaschangedsincelastreadintable'%-.64s'",
#defineER_DISK_FULL1021
"Diskfull(%s).Waitingforsomeonetofreesomespace...",
#defineER_DUP_KEY1022
"Can'twrite,duplicatekeyintable'%-.64s'",
#defineER_ERROR_ON_CLOSE1023
"Erroroncloseof'%-.64s'(errno:
%d)",
#defineER_ERROR_ON_READ1024
"Errorreadingfile'%-.64s'(errno:
%d)",
#defineER_ERROR_ON_RENAME1025
"Erroronrenameof'%-.64s'to'%-.64s'(errno:
%d)",
#defineER_ERROR_ON_WRITE1026
"Errorwritingfile'%-.64s'(errno:
%d)",
#defineER_FILE_USED1027
"'%-.64s'islockedagainstchange",
#defineER_FILSORT_ABORT1028
"So瘀牡?
剕_?
?
?
?
o鸞?
_rtaborted",
#defineER_FORM_NOT_FOUND1029
"View'%-.64s'doesn'texistfor'%-.64s'",
#defineER_GET_ERRNO1030
"Goterror%dfromstorageengine",
#defineER_ILLEGAL_HA1031
"Tablestorageenginefor'%-.64s'doesn'thavethisoption",
#defineER_KEY_NOT_FOUND1032
"Can'tfindrecordin'%-.64s'",
#defineER_NOT_FORM_FILE1033
"Incorrectinformationinfile:
'%-.64s'",
#defineER_NOT_KEYFILE1034
"Incorrectkeyfilefortable:
'%-.64s';trytorepairit",
#defineER_OLD_KEYFILE1035
"Oldkeyfilefortable'%-.64s';repairit!
",
#defineER_OPEN_AS_READONLY1036
"Table'%-.64s'isreadonly",
#defineER_OUTOFMEMORY1037
"Outofmemory.Restartdaemonandtryagain(needed%dbytes)",
#defineER_OUT_OF_SORTMEMORY1038
"Outofsortmemory.Increasedaemonsortbuffersize",
#defineER_UNEXPECTED_EOF1039
"Unexpectedeoffoundwhenreadingfile'%-.64s'(errno:
%d)",
#defineER_CON_COUNT_ERROR1040
"Toomanyconnections",
#defineER_OUT_OF_RESOURCES1041
"Outofmemory;Checkifmysqldorsomeotherprocessusesallavailablememory.Ifnotyoumayhavetouse'ulimit'toallowmysqldtousemorememoryoryoucanaddmoreswapspace",
#defineER_BAD_HOST_ERROR1042
"Can'tgethostnameforyouraddress",
#defineER_HANDSHAKE_ERROR1043
"Badhandshake",
#defineER_DBACCESS_DENIED_ERROR1044
"Accessdeniedforuser:
[email=]'%-.32s'@'%-.64s'[/email]todatabase'%-.64s'",
#defineER_ACCESS_DENIED_ERROR1045
"Accessdeniedforuser:
[email=]'%-.32s'@'%-.64s'[/email](Usingpassword:
%s)",
#defineER_NO_DB_ERROR1046
"NoDatabaseSelected",
#defineER_UNKNOWN_COM_ERROR1047
"Unknowncommand",
#defineER_BAD_NULL_ERROR1048
"Column'%-.64s'cannotbenull",
#defineER_BAD_DB_ERROR1049
"Unknowndatabase'%-.64s'",
#defineER_TABLE_EXISTS_ERROR1050
"Table'%-.64s'alreadyexists",
#defineER_BAD_TABLE_ERROR1051
"Unknowntable'%-.64s'",
#defineER_NON_UNIQ_ERROR1052
"Column:
'%-.64s'in%-.64sisambiguous",
#defineER_SERVER_SHUTDOWN1053
"Servershutdowninprogress",
#defineER_BAD_FIELD_ERROR1瘀牡?
剕_?
?
?
?
o鸞?
_054
"Unknowncolumn'%-.64s'in'%-.64s'",
#defineER_WRONG_FIELD_WITH_GROUP1055
"'%-.64s'isn'tinGROUPBY",
#defineER_WRONG_GROUP_FIELD1056
"Can'tgroupon'%-.64s'",
#defineER_WRONG_SUM_SELECT1057
"Statementhassumfunctionsandcolumnsinsamestatement",
#defineER_WRONG_VALUE_COUNT1058
"Columncountdoesn'tmatchvaluecount",
#defineER_TOO_LONG_IDENT1059
"Identifiername'%-.100s'istoolong",
#defineER_DUP_FIELDNAME1060
"Duplicatecolumnname'%-.64s'",
#defineER_DUP_KEYNAME1061
"Duplicatekeyname'%-.64s'",
#defineER_DUP_ENTRY1062
"Duplicateentry'%-.64s'forkey%d",
#defineER_WRONG_FIELD_SPEC1063
"Incorrectcolumnspecifierforcolumn'%-.64s'",
#defineER_PARSE_ERROR1064
"%snear'%-.80s'atline%d",
#defineER_EMPTY_QUERY1065
"Querywasempty",
#defineER_NONUNIQ_TABLE1066
"Notuniquetable/alias:
'%-.64s'",
#defineER_INVALID_DEFAULT1067
"Invaliddefaultvaluefor'%-.64s'",
#defineER_MULTIPLE_PRI_KEY1068
"Multipleprimarykeydefined",
#defineER_TOO_MANY_KEYS1069
"Toomanykeysspecified;max%dkeysallowed",
#defineER_TOO_MANY_KEY_PARTS1070
"Toomanykeypartsspecified.Max%dpartsallowed",
#defineER_TOO_LONG_KEY1071
"Specifiedkeywastoolong;maxkeylengthis%dbytes",
#defineER_KEY_COLUMN_DOES_NOT_EXITS1072
"Keycolumn'%-.64s'doesn'texistintable",
#defineER_BLOB_USED_AS_KEY1073
"BLOBcolumn'%-.64s'can'tbeusedinkeyspecificationwiththeusedtabletype",
#defineER_TOO_BIG_FIELDLENGTH1074
"Toobigcolumnlengthforcolumn'%-.64s'(max=%d).UseBLOBinstead",
#defineER_WRONG_AUTO_KEY1075
"Incorrecttabledefinition;Therecanonlybeoneautocolumnanditmustbedefinedasakey",
#defineER_READY1076
"%s:
readyforconnections.
Version:
'%s'socket:
'%s'port:
%d
",
#defineER_NORMAL_SHUTDOWN1077
"%s:
Normalshutdown
",
#defineER_GOT_SIGNAL1078
"%s:
Gotsignal%d.Aborting!
",
#defineER_SHUTDOWN_COMPLETE1079
"%s:
ShutdownComplete
",
#defineER_FORCING_CLOSE1080
"%s:
瘀牡?
剕_?
?
?
?
o鸞?
_Forcingcloseofthread%lduser:
'%-.32s'
",
#defineER_IPSOCK_ERROR1081
"Can'tcreateIPsocket",
#defineER_NO_SUCH_INDEX1082
"Table'%-.64s'hasnoindexliketheoneusedinCREATEINDEX.Recreatethetable",
#defineER_WRONG_FIELD_TERMINATORS1083
"Fieldseparatorargumentisnotwhatisexpected.Checkthemanual",
#defineER_BLOBS_AND_NO_TERMINATED1084
"Youcan'tusefixedrowlengthwithBLOBs.Pleaseuse'fieldsterminatedby'",
#defineER_TEXTFILE_NOT_READABLE1085
"Thefile'%-.64s'mustbeinthedatabasedirectoryorbereadablebyall",
#defineER_FILE_EXISTS_ERROR1086
"File'%-.80s'alreadyexists",
#defineER_LOAD_INFO1087
"Records:
%ldDeleted:
%ldSkipped:
%ldWarnings:
%ld",
#defineER_ALTER_INFO1088
"Records:
%ldDuplicates:
%ld",
#defineER_WRONG_SUB_KEY1089
"Incorrectsubpartkey.Theusedkeypartisn'tastring,theusedlengthislongerthanthekeypartorthestorageenginedoesn'tsupportuniquesubkeys",
#defineER_CANT_REMOVE_ALL_FIELDS1090
"Youcan'tdeleteallcolumnswithALTERTABLE.UseDROPTABLEinstead",
#defineER_CANT_DROP_FIELD_OR_KEY1091
"Can'tDROP'%-.64s'.Checkthatcolumn/keyexists",
#defineER_INSERT_INFO1092
"Records:
%ldDuplicates:
%ldWarnings:
%ld",
#defineER_UPDATE_TABLE_USED1093
"Youcan'tspecifytargettable'%-.64s'forupdateinFROMclause",
#defineER_NO_SUCH_THREAD1094
"Unknownthreadid:
%lu",
#defineER_KILL_DENIED_ERROR1095
"Youarenotownerofthread%lu",
#defineER_NO_TABLES_USED1096
"Notablesused",
#defineER_TOO_BIG_SET1097
"Toomanystringsforcolumn%-.64sandSET",
#defineER_NO_UNIQUE_LOGFILE1098
"Can'tgenerateauniquelog-filename%-.64s.(1-999)
",
#defineER_TABLE_NOT_LOCKED_FOR_WRITE1099
"Table'%-.64s'waslockedwithaREADlockandcan'tbeupdated",
#defineER_TABLE_NOT_LOCKED1100
"Table'%-.64s'wasnotlockedwithLOCKTABLES",
#defineER_BLOB_CANT_HAVE_DEFAULT1101
"BLOB/TEXTcolumn'%-.64s'can'thaveadefaultvalue",
#defineER_WRONG_DB_NAME1102
"Incorre瘀牡?
剕_?
?
?
?
o鸞?
_ctdatabasename'%-.100s'",
#defineER_WRONG_TABLE_NAME1103
"Incorrect