Small. Fast. Reliable.
Choose any three.

更新stmt

WITH RECURSIVE common-table-expression , UPDATE OR ROLLBACK qualified-table-name OR REPLACE OR IGNORE OR FAIL OR ABORT SET column-name-list = expr column-name , FROM table-or-subquery , join-clause WHERE expr returning-clause

用法:   create-trigger-stmt    sql-stmt

参考:   列名列表   common-table-expression    expr   联接子句   合格表名   returning-clause   表或子查询

另请参见:   lang_createtrigger.html    lang_update.html