could you explain a bit more or with an example?... Im not sure how to write procedures
On Monday, 18 May 2015 07:10:38 UTC+1, wener wrote: > > You better do this in procedure? I don't think a trigger should care about > the select > > 在 2015年5月17日星期日 UTC+8下午9:35:33，blu10写道： >> >> im trying to add a trigger to every database table in my h2 database but >> im not sure how to do it. >> >> I can select all the tables in the database but how do i loop through >> them to apply a trigger to each of them like below? >> >> SELECT * FROM INFORMATION_SCHEMA.TABLES >> >> and loop through each one and apply a trigger to each >> >> CREATE TRIGGER MYTRIGGER AFTER INSERT ON TableName FOR EACH ROW >> CALL\"test.h2Trigger\" >> >> -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
