Search Result: trg - DuckDB 2.0 全文検索

CREATE TRIGGER Statement 9414: New The CREATE TRIGGER feature was introduced in DuckDB 2.0. The CREATE TRIGGER statement registers a trigger: a set of SQL statements that run automatically in response to INSERT , UPDATE , or DELETE events on a table. Examples Record ever ... TABLE target (id INTEGER, val INTEGER); CREATE TABLE audit (id INTEGER, old_val INTEGER, new_val INTEGER); CREATE TRIGGER trg_audit AFTER UPDATE ON target REFERENCING OLD TABLE AS o NEW TABLE AS n FOR EACH STATEMENT INSERT INTO audit SELECT n.id, o ... ffected row through the NEW and OLD qualifiers: CREATE TABLE t (id INTEGER); CREATE TABLE log (id INTEGER); CREATE TRIGGER trg_log AFTER INSERT ON t FOR EACH ROW INSERT INTO log VALUES (NEW.id); INSERT INTO t VALUES (1), (2); SELECT * FROM log; Rest ... rict a trigger to changes of specific columns with UPDATE OF : CREATE TRIGGER trg_price AFTER UPDATE OF price ON products FOR EACH STATEMENT INSERT INTO price_changes DEFAULT VALUES; Drop a trigger: DROP ...; https://man.mtool.work/duckdb/2.0/sql/statements/create_trigger.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work