SQL 工具 #
| 语句 | 说明 | 示例 | 类型 |
|---|---|---|---|
| PARSE SQL | 解析 SQL 并输出抽象语法树 | PARSE SELECT * FROM t_order | RUL |
| FORMAT SQL | 解析并输出格式化后的 SQL 语句 | FORMAT SELECT * FROM t_order | RUL |
| PREVIEW SQL | 预览 SQL 执行计划 | PREVIEW SELECT * FROM t_order | RUL |
| WARMUP SQL | 预热 SQL | WARMUP ‘SELECT * FROM t_order’ | RAL |
| SHOW DDL SQL ADD COLUMN | 获取表添加列 SQL | SHOW DDL FOR TABLE t_user ADD COLUMNS (NAME=name_digest, DATA_TYPE=‘varchar(200)’) | RAL |
| SHOW DDL SQL DROP COLUMN | 获取表删除列 SQL | SHOW DDL FOR TABLE t_user DROP COLUMNS (name_digest, id_digest) | RAL |