MySQL触发器：更新a表s字段为2时更新b表v字段

DELIMITER $$ CREATE TRIGGER update_b_table AFTER UPDATE ON a FOR EACH ROW BEGIN IF NEW.s = 2 THEN UPDATE b SET v = 1 WHERE username = NEW.username; END IF; END$$ DELIMITER ;