Maison > Questions et réponses > le corps du texte
CREATE DEFINER=root
@localhost
TRIGGER abc
AFTER UPDATE ON zqbp_custom
FOR EACH ROW begin
if new.status=0 then
update zqbp_user set user_pass=NEW.user_pass where user_name=NEW.user_name;
if new.status=1 then
update zqbp_user set user_pass=null where user_name=NEW.user_name;
end;