解释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 --help Displays this help and exits. -I, --info Synonym for --help. -a, --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:解释错误代码