List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 25 2002 4:26pm
Subject:Re: Help with delete query
View as plain text  
At 10:40 -0400 6/25/02, Peter M. Perchansky wrote:
>Greetings:
>
>Thanks to Jay from this list and doing some reading, I resolved the 
>insert issue when trying to insert records using a select where the 
>tables are the same.
>
>Now I'm trying to clean up the old records, and no matter what 
>delete statement I try, it fails:
>
>
>DELETE FROM Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 
>5,4) = Customer.User_ID;
>
>DELETE Content, Customer FROM Content, Customer WHERE 
>SUBSTRING(Server_ID, 5,4) = Customer.User_ID;
>
>I've read http://www.mysql.com/doc/D/E/DELETE.html several times and 
>don't know what I'm doing wrong.
>
>Here's an example with the error message:
>
>DELETE Content, Customer FROM Content, Customer WHERE 
>SUBSTRING(Server_ID, 5,4) = Customer.User_ID;
>
>	ERROR 1064: You have an error in your SQL syntax near 
>'Content, Customer FROM Content, Customer WHERE 
>	SUBSTRING(Server_ID, 5,4) = Custo' at line 1
>
>Thoughts on how to fix?

DELETE statements that refer to multiple tables aren't supported until
MySQL 4.  I'm guessing you have an older version?


Thread
Help with delete queryPeter M. Perchansky25 Jun
  • Re: Help with delete queryPaul DuBois25 Jun