MySQL 9.0 發行說明
SHOW PARSE_TREE select_statement
SHOW PARSE_TREE 以 JSON 格式顯示輸入的 SELECT 陳述式的剖析樹狀結構表示。
注意
此陳述式僅在偵錯版本中可用，或者如果 MySQL 伺服器是使用 -DWITH_SHOW_PARSE_TREE 建置時才可用。它僅用於測試和開發，不適用於生產環境。
範例
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)