MySQL Error Code文档手册

《MySQL Error Code文档手册》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Chapter 26. ErrorHandlinginMySQLThischapterliststheerrorsthatmayappearwhenyoucallMySQLfromanyhostlanguage.Thefirstlistdisplaysservererrormessages.Thesecondlistdisplaysclientprogrammessages.Servererrorinformationcomesfromthefollowingfiles:oTheErrorvaluesandthesymbolsinparenthesescorrespondt

2、odefinitionsintheinclude/mysqld_error.hMySQLsourcefile.oTheSQLSTATEvaluescorrespondtodefinitionsintheinclude/sql_state.hMySQLsourcefile.SQLSTATEerrorcodesaredisplayedonlyifyouuseMySQLversion4.1andup.SQLSTATEcodeswereaddedforcompatibilitywithX/Open,ANSI,andODBCbehavior.oTheMessagevaluescorr

3、espondtotheerrormessagesthatarelistedinthesql/share/english/errmsg.txtfile.%dor%srepresentnumbersorstringsthataresubstitutedintothemessages%whentheyaredisplayed.Becauseupdatesarefrequent,itispossiblethatthesefilescontainadditionalerrorinformationnotlistedhere.oError:1000SQLSTATE:HY000(ER_H

4、ASHCHK)Message:hashchkoError:1001SQLSTATE:HY000(ER_NISAMCHK)Message:isamchkoError:1002SQLSTATE:HY000(ER_NO)Message:NOoError:1003SQLSTATE:HY000(ER_YES)Message:YESoError:1004SQLSTATE:HY000(ER_CANT_CREATE_FILE)Message:Can'tcreatefile'%s'(errno:%d)oError:1005SQLSTATE:HY000(ER_CANT_CREATE_TABLE

5、)Message:Can'tcreatetable'%s'(errno:%d)oError:1006SQLSTATE:HY000(ER_CANT_CREATE_DB)Message:Can'tcreatedatabase'%s'(errno:%d)oError:1007SQLSTATE:HY000(ER_DB_CREATE_EXISTS)Message:Can'tcreatedatabase'%s';databaseexistsoError:1008SQLSTATE:HY000(ER_DB_DROP_EXISTS)Message:Can'tdropdatabase'%s';

6、databasedoesn'texistoError:1009SQLSTATE:HY000(ER_DB_DROP_DELETE)Message:Errordroppingdatabase(can'tdelete'%s',errno:%d)oError:1010SQLSTATE:HY000(ER_DB_DROP_RMDIR)Message:Errordroppingdatabase(can'trmdir'%s',errno:%d)oError:1011SQLSTATE:HY000(ER_CANT_DELETE_FILE)Message:Errorondeleteof'%s'(

7、errno:%d)oError:1012SQLSTATE:HY000(ER_CANT_FIND_SYSTEM_REC)Message:Can'treadrecordinsystemtableoError:1013SQLSTATE:HY000(ER_CANT_GET_STAT)Message:Can'tgetstatusof'%s'(errno:%d)oError:1014SQLSTATE:HY000(ER_CANT_GET_WD)Message:Can'tgetworkingdirectory(errno:%d)o