List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:June 9 2002 8:18pm
Subject:Re: Delete
View as plain text  
In the last episode (Jun 09), Bruno Batarelo said:
> Greetings
> 
> In the comments section (delete speed) somebody wrote that that it is
> much faster to delete results of previously executed select query.
> How can I do that when delete from..where in(select query); is not
> possible?

You manually do it in your code.  Your first query is "SELECT uniqueid
FROM table WHERE ...", then you take the ids returned by that query,
put commas between them, and run "DELETE FROM table WHERE uniqueid IN
(1,23,45,67)".


-- 
	Dan Nelson
	dnelson@stripped
Thread
DeleteBruno Batarelo9 Jun
  • Re: DeleteDan Nelson9 Jun