I have a trigger which is updating a column in a different table after the row is inserted:
mysql>delimiter $$ mysql> create trigger status after insert on table2 FOR EACH ROW BEGIN update table1 inner join table2 ON table1.id=table2.id set table1.state=0 ;
Now I want to reset the
table1.state=1 whenever the same value gets deleted. Is this possible?