gaussdb hccdp实验练习02 GaussDB数据库开发设计
GaussDB数据库开发设计
1. 记录该笔支付至历史表 h_id更改为hist_id
INSERT INTO bmsql_history(h_id,h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id,h_date, h_amount, h_data)VALUES(300001,4, 1, 1, 1, 1, '2023-02-11', 50, 'succeed');
INSERT INTO bmsql_history(hist_id,h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id,h_date, h_amount, h_data)VALUES(300001,4, 1, 1, 1, 1, '2023-02-11', 50, 'succeed');
2.更新订单总表中信息 bmsql_order更改为bmsql_oorder
UPDATE bmsql_order SET o_carrier_id = 1 WHERE o_w_id = 2 AND o_d_id = 2 AND o_id = 2101;
UPDATE bmsql_oorder SET o_carrier_id = 1 WHERE o_w_id = 2 AND o_d_id = 2 AND o_id = 2101;
