TiDB support `help` statement

longlongago7777 commented 2 years ago

Change Request

同样的mysql命令行，mysql数据库help show 可以显示具体的help contents；而TiDB不能显示，是不是缺失了帮助信息？ mysql> help show
ERROR 8108 (HY000): Unsupported type *ast.HelpStmt

mysql 命令行版本信息如下： [root@centos76_vm ~]# mysql -uroot -pTidb123! -h 172.16.7.223 -P4000 mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 15 Server version: 5.7.25-TiDB-v5.4.0 TiDB Server (Apache License 2.0) Community Edition, MySQL 5.7 compatible

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

ran-huang commented 2 years ago

Thanks for the feedback! Since this is not a documentation issue, I'm transferring it to the tidb repo, where you might get timely help.

Defined2014 commented 2 years ago

TiDB doesn't support help stmt right now, change to feature request.

dbakit commented 2 years ago

+1, help statement is very very convenient for daily work. Otherwise I must open a browser, and search command on pingcap web document..

longlongago7777 commented 2 years ago

and sometimes, pingcap web would redirect to the Mysql office documentation.

shawn0915 commented 2 years ago

+1, this's very important feature, also recorded in asktug.com, https://asktug.com/t/topic/903592

dveeden commented 1 year ago

I started to work on this in 2021 in https://github.com/pingcap/tidb/pull/25485

The main issue is getting help data in a usable format, e.g. extracting this from the docs repo.

Another option would be to basically store and/or generate URLS based on the function and version that a user can then open in a browser.

pingcap / tidb

TiDB support `help` statement #33609

Change Request