List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 9 2002 3:20pm
Subject:Re: Multiple tables in delete statement on Mysql 3
View as plain text  
At 10:46 -0400 5/9/02, Augey Mikus wrote:
>is a statement like this not supported on mysql 3 but is supported in mysql 4?
>
>delete table1 from table1,table2 where table1.id = table2.id;
>
>or am i just typing it wrong...
>
>Augey

It's supported only in MySQL 4.

http://www.mysql.com/doc/N/e/News-4.0.0.html
Thread
• Multiple tables in delete statement on Mysql 3Augey Mikus9 May
  • RE: Multiple tables in delete statement on Mysql 3Jay Blanchard9 May
    • Re: Multiple tables in delete statement on Mysql 3Augey Mikus9 May
      • RE: Multiple tables in delete statement on Mysql 3Jay Blanchard9 May
    • Re: Multiple tables in delete statement on Mysql 3Gelu Gogancea9 May
    • Re: Multiple tables in delete statement on Mysql 3Augey Mikus9 May
  • Re: Multiple tables in delete statement on Mysql 3Egor Egorov9 May
  • Re: Multiple tables in delete statement on Mysql 3Paul DuBois9 May
  • Re: Multiple tables in delete statement on Mysql 3Augey Mikus9 May
    • Re: Multiple tables in delete statement on Mysql 3Paul DuBois9 May
    • MySQL GROUP BY Anomaly?Jay Blanchard9 May
• RE: MySQL GROUP BY Anomaly?Max Anderson9 May
  • RE: MySQL GROUP BY Anomaly?Jay Blanchard9 May
  • RE: MySQL GROUP BY Anomaly? SOLVEDJay Blanchard9 May
• RE: MySQL GROUP BY Anomaly?Max Anderson9 May