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.
