解释MySQL异常代码

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

欢迎大家阅读《解释MySQL异常代码》,跪求各位点评，by 搞代码

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                               FALSE verbose                           TRUE zhanhailiang@linux-06bq:/usr/local/services/mysql/bin> ./perror -s 1677 Column %d of table '%-.192s.%-.192s' cannot be converted from type '%-.32s' to type '%-.32s'

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