数据仓库服务 GAUSSDB(DWS)-PREPARE:示例

时间:2023-11-10 17:34:10

示例

为一个INSERT语句创建一个预备语句,然后执行它:
1
2
PREPARE insert_reason(integer,character(16),character(100)) AS INSERT INTO tpcds.reason_t1 VALUES($1,$2,$3); 
EXECUTE insert_reason(52, 'AAAAAAAADDAAAAAA', 'reason 52'); 
support.huaweicloud.com/sqlreference-dws/dws_06_0251.html