DELIMITER |  CREATE TRIGGER `<databaseName>`.`<triggerName>` 

 < [ BEFORE | AFTER ] > < [ INSERT | UPDATE | DELETE ] >  

 ON <tableName>  

 FOR EACH ROW  

BEGIN   --do something  

END |

posted on 2010-09-08 08:35  TsingCai  阅读(198)  评论(0编辑  收藏  举报