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;
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
end if