Retro Eye care Haitian Deep Dark Default

SHOW SQL_PARSER RULE

Description

The SHOW SQL_PARSER RULE syntax is used to query sql parser rule configuration.

Syntax

ShowSqlParserRule ::=
  'SHOW' 'SQL_PARSER' 'RULE'

Return Value Description

Colume Description
sql_comment_parse_enable sql comment parse enable status
parse_tree_cache parse tree cache configuration
sql_statement_cache sql statement cache configuration

Example

  • Query sql parser rule configuration
SHOW SQL_PARSER RULE;

mysql> SHOW SQL_PARSER RULE;
+--------------------------+-----------------------------------------+-------------------------------------------+
| sql_comment_parse_enable | parse_tree_cache                        | sql_statement_cache                       |
+--------------------------+-----------------------------------------+-------------------------------------------+
| false                    | initialCapacity: 128, maximumSize: 1024 | initialCapacity: 2000, maximumSize: 65535 |
+--------------------------+-----------------------------------------+-------------------------------------------+
1 row in set (0.05 sec)

Reserved word

SHOW, SQL_PARSER, RULE