List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 27 2001 5:04pm
Subject:Re: Delete query question
View as plain text  
At 11:05 AM -0500 9/27/01, Chris Johnson wrote:
>MySQL does not yet have the ability to do join operations during delete or
>update processing.  So, although you can do what you ask in Oracle, Sybase,
>and others, you cannot do it in MySQL.  Sorry.  It's one of the biggest
>weaknesses in my view.
>
>..chris

This will work in MySQL 4.

>
>----- Original Message -----
>From: "Jay Paulson" <jpaulson@stripped>
>To: <mysql@stripped>
>Sent: Thursday, September 27, 2001 10:54 AM
>Subject: Delete query question
>
>
>Can you do something like this?
>
>delete from table1, table2 where table1.id=1 and table2.id=4;
>
>Thanks,
>jay


-- 
Paul DuBois, paul@stripped
Thread
Circular Replication?Alok K. Dhir27 Sep
RE: Circular Replication?Simon Green27 Sep
  • Delete query questionJay Paulson27 Sep
    • Re: Delete query questionCK Raju27 Sep
    • Re: Delete query questionCK Raju27 Sep
  • Re: Delete query questionChris Johnson27 Sep
    • Re: Delete query questionPaul DuBois27 Sep