List:General Discussion« Previous MessageNext Message »
From:Jay Blanchard Date:May 9 2002 2:57pm
Subject:RE: Multiple tables in delete statement on Mysql 3
View as plain text  
[snip]
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;
[/snip]

DELETE FROM tablename WHERE table1.id = table2.id

You can only delete from one table at a time.
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