| commit 9117430a24aed5a722e7c16a76581f35f2d324d2 |
| Author: Anson <georgeanson@foxmail.com> |
| Date: Sat Apr 17 09:10:59 2021 +0800 |
| |
| Update parse.cn.md (#10113) |
| |
| change 【提供 SQL 模板话功能(开发中)】 to 【提供 SQL 模板化功能(开发中)】 |
| |
| diff --git a/docs/document/content/features/sharding/principle/parse.cn.md b/docs/document/content/features/sharding/principle/parse.cn.md |
| index ae68d641a9..5cbabe073f 100644 |
| --- a/docs/document/content/features/sharding/principle/parse.cn.md |
| +++ b/docs/document/content/features/sharding/principle/parse.cn.md |
| @@ -58,7 +58,7 @@ ShardingSphere 的 SQL 解析器经历了 3 代产品的更新迭代。 |
| |Oracle |支持 | |
| |SQL92 |支持 | |
| * 提供 SQL 格式化功能(开发中) |
| -* 提供 SQL 模板话功能(开发中) |
| +* 提供 SQL 模板化功能(开发中) |
| |
| ### API使用 |
| |
| @@ -130,4 +130,4 @@ String formatedSql = sqlVisitorEngine.visit(tree); |
| |CREATE TABLE IF NOT EXISTS <br>`runoob_tbl`(`runoob_id` INT UNSIGNED AUTO_INCREMENT,`runoob_title` VARCHAR(100) NOT NULL,<br>`runoob_author` VARCHAR(40) NOT NULL,`runoob_test` NATIONAL CHAR(40),<br>`submission_date` DATE,PRIMARY KEY (`runoob_id`))ENGINE=InnoDB DEFAULT CHARSET=utf8;|CREATE TABLE IF NOT EXISTS `runoob_tbl` (<br>    `runoob_id` INT UNSIGNED AUTO_INCREMENT,<br>    `runoob_title` VARCHAR(100) NOT NULL,<br>    `runoob_author` VARCHAR(40) NOT NULL,<br>    `runoob_test` NATIONAL CHAR(40),<br>    `submission_date` DATE,<br>    PRIMARY KEY (`runoob_id`)<br>) ENGINE = InnoDB DEFAULT CHARSET = utf8;| |
| |INSERT INTO t_order_item(order_id, user_id, status, creation_date) <br>values (1, 1, 'insert', '2017-08-08'), (2, 2, 'insert', '2017-08-08') ON DUPLICATE KEY UPDATE status = 'init';|INSERT INTO t_order_item (order_id , user_id , status , creation_date)<br>VALUES<br>    (1, 1, 'insert', '2017-08-08'),<br>    (2, 2, 'insert', '2017-08-08')<br>ON DUPLICATE KEY UPDATE status = 'init';| |
| |INSERT INTO t_order SET order_id = 1, user_id = 1, status = convert(to_base64(aes_encrypt(1, 'key')) USING utf8)<br> ON DUPLICATE KEY UPDATE status = VALUES(status);|INSERT INTO t_order SET order_id = 1,<br>    user_id = 1,<br>    status = CONVERT(to_base64(aes_encrypt(1 , 'key')) USING utf8)<br>ON DUPLICATE KEY UPDATE status = VALUES(status);| |
| -|INSERT INTO t_order (order_id, user_id, status) SELECT order_id, user_id, status FROM t_order WHERE order_id = 1;|INSERT INTO t_order (order_id , user_id , status) <br>SELECT order_id , user_id , status <br>FROM t_order<br>WHERE <br>    order_id = 1;| |
| \ No newline at end of file |
| +|INSERT INTO t_order (order_id, user_id, status) SELECT order_id, user_id, status FROM t_order WHERE order_id = 1;|INSERT INTO t_order (order_id , user_id , status) <br>SELECT order_id , user_id , status <br>FROM t_order<br>WHERE <br>    order_id = 1;| |