You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by ji...@apache.org on 2022/05/10 01:02:10 UTC
[incubator-doris] branch master updated: [docs][typo] Fix some typoes in "update.md" content. (#9455)
This is an automated email from the ASF dual-hosted git repository.
jiafengzheng pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-doris.git
The following commit(s) were added to refs/heads/master by this push:
new 76154f11b7 [docs][typo] Fix some typoes in "update.md" content. (#9455)
76154f11b7 is described below
commit 76154f11b7dd8d310579e5f3d8a42085394d71c4
Author: liuzhuang2017 <95...@users.noreply.github.com>
AuthorDate: Tue May 10 09:02:04 2022 +0800
[docs][typo] Fix some typoes in "update.md" content. (#9455)
Fix some typoes in "update.md" content
---
docs/en/data-operate/update-delete/update.md | 17 ++++++++++++++---
docs/zh-CN/data-operate/update-delete/update.md | 15 ++++++++++++---
2 files changed, 26 insertions(+), 6 deletions(-)
diff --git a/docs/en/data-operate/update-delete/update.md b/docs/en/data-operate/update-delete/update.md
index 1b244b7653..0b09d66bc6 100644
--- a/docs/en/data-operate/update-delete/update.md
+++ b/docs/en/data-operate/update-delete/update.md
@@ -108,9 +108,20 @@ The result after the update is as follows
After the user executes the UPDATE command, the system performs the following three steps.
-- Step 1: Read the rows that satisfy WHERE order id=1 (1, 100, 'pending payment')
-- Step 2: Change the order status of the row from 'Pending Payment' to 'Pending Shipping' (1, 100, 'Pending shipment')
-- Step 3: Insert the updated row back into the table to achieve the updated effect. | order id | order amount | order status | | ---| ---| ---| | 1 | 100| Pending Payment | | 1 | 100 | Pending shipments | Since the table order is a UNIQUE model, the rows with the same Key, after which the latter will take effect, so the final effect is as follows. | order id | order amount | order status | |--|--|--| | 1 | 100 | Pending shipments |
+ Step 1: Read the rows that satisfy WHERE order id=1 (1, 100, 'pending payment')
+ Step 2: Change the order status of the row from 'Pending Payment' to 'Pending Shipping' (1, 100, 'Pending shipment')
+ Step 3: Insert the updated row back into the table to achieve the updated effect.
+
+ | order id | order amount | order status |
+ | ---| ---| ---|
+ | 1 | 100| Pending Payment |
+ | 1 | 100 | Pending shipments |
+
+Since the table order is a UNIQUE model, the rows with the same Key, after which the latter will take effect, so the final effect is as follows.
+
+ | order id | order amount | order status |
+ |---|---|---|
+ | 1 | 100 | Pending shipments |
## More Help
diff --git a/docs/zh-CN/data-operate/update-delete/update.md b/docs/zh-CN/data-operate/update-delete/update.md
index 38fb2eab4d..1faeafe7c1 100644
--- a/docs/zh-CN/data-operate/update-delete/update.md
+++ b/docs/zh-CN/data-operate/update-delete/update.md
@@ -107,9 +107,18 @@ Query OK, 1 row affected (0.11 sec)
- 第二步:变更该行的订单状态,从'待付款'改为'待发货' (1,100,'待发货')
-- 第三步:将更新后的行再插入回表中,从而达到更新的效果。
-
- |订单id | 订单金额| 订单状态| |---|---|---| | 1 | 100| 待付款 | | 1 | 100 | 待发货 | 由于表 test_order 是 UNIQUE 模型,所以相同 Key 的行,之后后者才会生效,所以最终效果如下: |订单id | 订单金额| 订单状态| |---|---|---| | 1 | 100 | 待发货 |
+- 第三步:将更新后的行再插入回表中,从而达到更新的效果。
+
+ |订单id | 订单金额| 订单状态|
+ |---|---|---|
+ | 1 | 100| 待付款 |
+ | 1 | 100 | 待发货 |
+
+由于表 test_order 是 UNIQUE 模型,所以相同 Key 的行,之后后者才会生效,所以最终效果如下:
+
+ |订单id | 订单金额| 订单状态|
+ |---|---|---|
+ | 1 | 100 | 待发货 |
## 更多帮助
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org