解释MySQL异常代码
解释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 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:解释错误代码