Is there a way to define the order of execution of my triggers in sqlite? -
if have many on insert
triggers table. can specify trigger executed first when insert values table using sqlite?
i thought of combining triggers problem have different when
statements each trigger , if understand doc correctly when
statement commes before update
/insert
etc. statement.
create trigger trigger_name after insert on table_name when expr begin update-stmt; end;
combine of triggers one:
create trigger some_trigger after insert on some_table each row begin -- statement 1; -- statement 2; -- statement 3; ... -- statement n; end;
Comments
Post a Comment