SELECT idUsername, TIMESTAMPDIFF(minute, dateReg, now()) AS minutos FROM token WHERE TIMESTAMPDIFF(minute, dateReg, now()) > 60
-- delete_token
BEGIN
DELETE FROM psw WHERE idUsername = v_id LIMIT 1;
DELETE FROM status_username WHERE idUsername = v_id LIMIT 1;
DELETE FROM token WHERE idUsername = v_id LIMIT 1;
DELETE FROM username WHERE idUsername = v_id LIMIT 1;
END
Sem comentários:
Enviar um comentário