MYSQL 触发器的高级使用

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

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