【AntDB数据库 SQL语法专栏】——DML语句(4)

DELETE

说明：
删除一个表的行

语法：

[ WITH [ RECURSIVE ] with_query [, ...] ]
DELETE FROM [ ONLY ] table_name [ * ] [ [ AS ] alias ]
    [ USING from_item [, ...] ]
    [ WHERE condition | WHERE CURRENT OF cursor_name ]
    [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]

示例：

--删除所有电影，但音乐剧除外：
DELETE FROM films WHERE kind <> 'Musical';

--清空表films：
DELETE FROM films;

CALL

说明：

调用一个过程

语法：

CALL name ( [ argument ] [, ...] )

示例：

--调用过程do_db_maintenance()：
CALL do_db_maintenance();