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.

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 and;

Paul DuBois, paul@stripped
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