Instead of Triggers in SQLite

Question

I want to use Triggers in views. How can I do that with Instead of Trigger

Javeed M Shaikh · Answer

try this example for INSERT: CREATE TRIGGER MyViewTrig_On_insert INSTEAD OF INSERT ON MyViewName BEGIN INSERT INTO tempdata (id  morecolumns) VALUES (new.id new.morecolumns); END;