云数据库 GAUSSDB-DELETE:语法格式

时间:2024-11-12 09:17:45

语法格式

单表删除:

[ WITH [ RECURSIVE ] with_query [, ...] ]
DELETE [/*+ plan_hint */] [FROM] [ ONLY ] table_name [ * ] [ [ [partition_clause]  [ [ AS ] alias ] ] | [ [ [ AS ] alias ] [partitions_clause] ] ]
    [ USING using_list ]
    [ WHERE condition | WHERE CURRENT OF cursor_name ]
    [ ORDER BY {expression [ ASC | DESC | USING operator ] }]
    [ LIMIT { count } ]
    [ RETURNING { * | { output_expr [ [ AS ] output_name ] } [, ...] } ];
support.huaweicloud.com/centralized-devg-v3-gaussdb/gaussdb-12-0561.html