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
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
