Help me write a trigger that increments the value. 1) table 'notes' 2) table 'stats' with columns 'field' and 'count' 3) When i insert an entry in the notes, the value of the selected record in cell (count) should increase.
CREATE TRIGGER count_inc AFTER INSERT ON notes FOR EACH ROW UPDATE stats SET count = (count + 1) WHERE field = 'abc'; This code does not work, I can not understand why ... Can anybody write a working sample. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
