MYSQL 触发器的高级使用

当user表的user_name 发生修改后，同时更新两个表user_about,user_detail的user_bean字段和real_name字段

BEGINIF ( NEW.user_name !=OLD.user_name) THENUPDATE user_details SET real_name = NEW.user_nameWHERE user_id = OLD.id; UPDATE user_about  SET user_bean= user_bean+1 WHERE user_id = OLD.id;END IF ;END