ContextQMD
Back to Shardingsphere

Parse Sql.Cn

docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rul/parse-sql.cn.md

5.5.32.4 KB
Original Source

+++ title = "PARSE SQL" weight = 1 +++

描述

PARSE SQL 语法用于解析 SQL 并输出抽象语法树。

语法

{{< tabs >}} {{% tab name="语法" %}}

sql
ParseSql ::=
  'PARSE' sqlStatement

{{% /tab %}} {{% tab name="铁路图" %}}

<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe> {{% /tab %}} {{< /tabs >}}

返回值说明

列说明
parsed_statement解析SQL语句类型
parsed_statement_detail解析SQL语句细节

示例

  • 解析 SQL 并输出抽象语法树
sql
PARSE SELECT * FROM t_order;
sql
mysql> PARSE SELECT * FROM t_order;
+----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| parsed_statement     | parsed_statement_detail                                                                                                                                                                                                                                                                               |
+----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| SelectStatement      | {"projections":{"startIndex":7,"stopIndex":7,"projections":[{"startIndex":7,"stopIndex":7}],"distinctRow":false},"from":{"tableName":{"startIndex":14,"stopIndex":20,"identifier":{"value":"t_order","quoteCharacter":"NONE"}}},"parameterCount":0,"parameterMarkerSegments":[],"commentSegments":[]} |
+----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

保留字

PARSE

相关链接