List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 28 1999 8:08pm
Subject:Re: Use of JOIN.
View as plain text  
On Tue, 1999-09-28 17:57:47 +0100, Thomas Barrett wrote:
[...]
> > Now just store the list of ids, which you get from this query ...
[...]
> > ... and use them to build a new query:
> > 
> >   DELETE FROM USERSINGROUPS WHERE userID IN ('id1','id2',...);
> 
> Is there a way to do this with one command using MySQL
> (it doesn't look like it is),

You're guessing right: to my knowledge it's not yet possible with a
single query.

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
Use of JOIN.Thomas Barrett28 Sep
  • Re: Use of JOIN.Martin Ramsch28 Sep
    • RE: Use of JOIN.Thomas Barrett28 Sep
      • Re: Use of JOIN.Martin Ramsch28 Sep