Pasted

CREATE TRIGGER updateTrigger AFTER UPDATE ON usersFOR EACH ROWBEGINUPDATE users SET is_active=0 WHERE NEW.is_code=1 AND NEW.times_logged_in>=3AND NEW.user_id=user_id;END;
 CREATE TRIGGER updateTrigger AFTER UPDATE ON usersFOR EACH ROWBEGIN  UPDATE users SET is_active=0 WHERE NEW.is_code=1   AND NEW.times_logged_in>=3END;
 CREATE TRIGGER updateTrigger BEFORE UPDATE ON users FOR EACH ROW BEGINIF NEW.is_code=1 AND NEW.times_logged_in>=3 THEN   SET NEW.is_active=0;END IF;END;