So you're saying there's no actual DELETE statement for this? There is no
way in hell I can write any SQL to do that?? Thats sucks....... :(
Thanks for the example, but how do I run it? I've only used PHP for taking
information out of a database and other simple MySQL queries so while your
Perl example kinda makes sense, I don't understand how to work it. Do I
just put that in a file and run open the file in a browser?
Thanks!
sunny
At 08:12 29/03/02 -0700, Rodney Broom wrote:
>Good morning Sunny,
>
>
>From: sunny <[EMAIL PROTECTED]>
>
> > ...substituting SELECT with DELETE doesn't work :(
>
>That's right, that's how MySQL works. And it doesn't support sub-queries
>for this case, either. So you can't say:
>
> delete from table where field in (select field from other_table)
>
>I'd suggest doing this from another language, like Perl. For instance:
>
> $list_list = $dbh->selectall_arrayref(qq{
> SELECT messages.topicid
> FROM messages
> LEFT OUTER JOIN main
> ON messages.topicid=main.topicid
> WHERE main.topicid is null
> });
>
> for my $row ( @{$list_list} ) {
> $dbh->do(qq{DELETE FROM messages WHERE topicid = $row->[0]});
> }
>
>
>Note, my example is rough, and not tuned for performance. But you get the
>idea. Hollar if you still need a hand with this.
>
>
>
>---
>Rodney Broom
>Programmer: Desert.Net
>
>
>
>
>---------------------------------------------------------------------
>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
---------------------------------------------------------------------
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
