Documentation Home
MySQL 9.2 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.5Mb
PDF (A4) - 40.6Mb
Man Pages (TGZ) - 259.6Kb
Man Pages (Zip) - 366.8Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.2 Reference Manual  /  ...  /  SHOW PARSE_TREE Statement

15.7.7.26 SHOW PARSE_TREE Statement

Press CTRL+C to copy
SHOW PARSE_TREE select_statement

SHOW PARSE_TREE displays a representation of the parse tree for the input SELECT statement, in JSON format.

Note

This statement is available only in debug builds, or if the MySQL server was built using -DWITH_SHOW_PARSE_TREE. It is intended for use in testing and development only, and not in production.

Example:

Press CTRL+C to copy
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)