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