自动加公会触发器

1. delimiter $
   
2. use taiwan_cain;
   
3. DROP trigger IF EXISTS  `charac_info`;
   
4. CREATE TRIGGER `charac_info` BEFORE UPDATE ON `charac_info` FOR EACH ROW
   
5. IF new.guild_id =0 THEN
   
6. SET new.guild_id = 1;
   
7. END IF
   
8. $
   
9. delimiter ;

复制代码