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

时间:2024-01-26 16:15:20

示例

为一个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-820-dws/dws_06_0248.html