mysql--help不可用

1、问题描述:

执行help语句时没有得到相应的返回只是提示检查相关表是不是已经加载:

mysql> help contents;

Nothing found

Please check if 'help tables' are loaded.

mysql> 

2、查看mysql官方后发现这些表相关的sql语句在fill_help_tables.sql 这个文件中;只是加载这个文件中的内容到mysql 库就行了

mysql -h127.0.0.1 -uxxxx -pxxxx mysql </usr/local/mysql-5.6.31-linux-glibc2.5-x86_64/share/fill_help_tables.sql

3、加载完成之后help就可用了

mysql> help contents;
You asked for help about help category: "Contents"
For more information, type 'help <item>', where <item> is one of the following
categories:
   Account Management
   Administration
   Compound Statements
   Data Definition
   Data Manipulation
   Data Types
   Functions
   Functions and Modifiers for Use with GROUP BY
   Geographic Features
   Help Metadata
   Language Structure
   Plugins
   Procedures
   Storage Engines
   Table Maintenance
   Transactions
   User-Defined Functions
   Utility

 

posted on 2016-08-18 16:11  蒋乐兴的技术随笔  阅读(1599)  评论(0编辑  收藏  举报

导航