title: MySQL trigger to fire on alter or drop
body: <p>I've encountered an interesting problem. I would like to create two triggers, trigger1 would fire on <code>DROP TABLE</code> and trigger2 on <code>ALTER TABLE</code>. I would like trigger1 and trigger2 to fire if any table is dropped or altered, but, unfortunately I don't know the syntax to do that and I couldn't find a syntax for such triggers either. In MySQL I can only write triggers which fire before/after <code>INSERT</code>, <code>UPDATE</code>, or <code>DELETE</code>, but now I would like to write triggers which would be applicable on database level and would fire on table events. Can somebody help me?</p>