如何查询MySQL错误代码

  作者:zhanhailiang 日期:2013-03-08

MySQL专门为错误代码提供perror工具来查询错误代码的含义。

如下：

zhanhailiang@linux-06bq:/usr/local/services/mysql/bin> ./perror --help./perror Ver 2.11, for linux2.6 (i686)This software comes with ABSOLUTELY NO WARRANTY. This is free software,and you are welcome to modify and redistribute it under the GPL license Print a description for a system error code or a MySQL error code.If you want to get the error for a negative error code, you should use-- before the first error code to tell perror that there was no more options. Usage: ./perror [OPTIONS] [ERRORCODE [ERRORCODE...]]  -?, --help          Displays this help and exits.  -I, --info          Synonym for --help.  -a, --all           Print all the error messages and the number.  -s, --silent        Only print the error message.  -v, --verbose       Print error code and message (default).                      (Defaults to on; use --skip-verbose to disable.)  -V, --version       Displays version information and exits. Variables (--variable-name=value)and boolean options {FALSE|TRUE}  Value (after reading options)--------------------------------- ----------------------------------------all                               FALSEverbose                           TRUEzhanhailiang@linux-06bq:/usr/local/services/mysql/bin> ./perror -s 1677Column %d of table '%-.192s.%-.192s' cannot be converted from type '%-.32s' to type '%-.32s'

官方文档：8.13. perror：解释错误代码