AnDeR
28/09/2015, 01:53 AM
Query para deletar as contas criadas no site que nunca logaram no servidor, recomendo utilizar a cada 3 meses.
[Only registered and activated users can see links]
[Only registered and activated users can see links]
DECLARE LISTA CURSOR LOCAL FOR
SELECT memb___id FROM MEMB_INFO
OPEN LISTA
[Only registered and activated users can see links]
[Only registered and activated users can see links]
begin
[Only registered and activated users can see links]
begin
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
end
[Only registered and activated users can see links]
end
CLOSE LISTA
DEALLOCATE LISTA
[Only registered and activated users can see links]
Lembrando claro de fazer backup antes de executar a query, para caso ocorra um problema vc não perder os dados.
Créditos: Alex Lima
[Only registered and activated users can see links]
[Only registered and activated users can see links]
DECLARE LISTA CURSOR LOCAL FOR
SELECT memb___id FROM MEMB_INFO
OPEN LISTA
[Only registered and activated users can see links]
[Only registered and activated users can see links]
begin
[Only registered and activated users can see links]
begin
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
end
[Only registered and activated users can see links]
end
CLOSE LISTA
DEALLOCATE LISTA
[Only registered and activated users can see links]
Lembrando claro de fazer backup antes de executar a query, para caso ocorra um problema vc não perder os dados.
Créditos: Alex Lima