MySQL :: MySQL 8.4 参考手册 :: 15.7.7.25 SHOW PARSE_TREE 语句

版本 8.4

9.0

MySQL 8.4 参考手册 / ... / SHOW PARSE_TREE 语句

15.7.7.25 SHOW PARSE_TREE 语句

SHOW PARSE_TREE select_statement

SHOW PARSE_TREE 以 JSON 格式显示输入 SELECT 语句的解析树表示形式。

注意

此语句仅在调试版本中可用，或者在使用 -DWITH_SHOW_PARSE_TREE 构建 MySQL 服务器时可用。它仅用于测试和开发，不用于生产环境。

示例

mysql> SHOW PARSE_TREE SELECT * FROM t3 WHERE o_id > 2\G
*************************** 1. row ***************************
Show_parse_tree: {
  "text": "SELECT * FROM t3 WHERE o_id > 2",
  "type": "PT_select_stmt",
  "components": [
    {
      "text": "SELECT * FROM t3 WHERE o_id > 2",
      "type": "PT_query_expression",
      "components": [
        {
          "text": "SELECT * FROM t3 WHERE o_id > 2",
          "type": "PT_query_specification",
          "components": [
            {
              "text": "*",
              "type": "PT_select_item_list",
              "components": [
                {
                  "text": "*",
                  "type": "Item_asterisk"
                }
              ]
            },
            {
              "text": "t3",
              "type": "PT_table_factor_table_ident",
              "table_ident": "`t3`"
            },
            {
              "text": "o_id > 2",
              "type": "PTI_where",
              "components": [
                {
                  "text": "o_id > 2",
                  "type": "PTI_comp_op",
                  "operator": ">",
                  "components": [
                    {
                      "text": "o_id",
                      "type": "PTI_simple_ident_ident"
                    },
                    {
                      "text": "2",
                      "type": "Item_int"
                    }
                  ]
                }
              ]
            }
          ]
        }
      ]
    }
  ]
}
1 row in set (0.01 sec)