TiDB Incompatibility with MySQL SQL Syntax: The HELP Command

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TIDB 不兼容 MySQL sql 语法的help 命令

| username: DBAER

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration]
[TiDB Operator Version]:
[K8s Version]:
[Attachments: Screenshots/Logs/Monitoring]
If you find that TiDB is not compatible with MySQL SQL syntax’s help command to view command help, it feels like this implementation is not complicated at all.
MySQL help feels very convenient
image

| username: tidb菜鸟一只 | Original post link

The functionality is good, but I rarely use MySQL’s help…

| username: cassblanca | Original post link

It indeed doesn’t support it. However, using the MySQL client to connect to TiDB and checking the syntax with the help command in the console is not as convenient as directly asking GPT.

| username: virvle | Original post link

Can it?

| username: hughzm | Original post link

The help command relies on the content of the built-in MySQL library. Refer to:
https://mysql.net.cn/doc/refman/8.0/en/server-side-help-support.html
Consider whether it is due to insufficient user permissions.

| username: wangkk2024 | Original post link

Most of them support it.

| username: YuchongXU | Original post link

It doesn’t have that MySQL feature.

| username: xiaoqiao | Original post link

Not exactly the same, but most of it works.

| username: DBAER | Original post link

You are right, it seems that the integration complexity is not high.

| username: DBAER | Original post link

Sometimes when I forget a command, I just use help. Scenario: Especially when I’m around others, using Baidu or GPT can be a bit awkward.

| username: TiDBer_JUi6UvZm | Original post link

I haven’t used MySQL’s help much, but TiDB has done a lot of research on usability.

| username: 友利奈绪 | Original post link

It can indeed be awkward for some people around, and in most cases, it’s really unnecessary, haha.

| username: 小于同学 | Original post link

The functionality is good, but I rarely use MySQL’s help…

| username: dba远航 | Original post link

There are issues with using the HELP command in domestic MySQL databases.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.