Page 1 of 1

Deleting multiple tables in MySQL

Posted: Sat Apr 10, 2010 2:25 am
by tonykasdorf
I'm trying to delete records from multiple tables in MySQL but seem to be running into problems. Below is my script.

Code: Select all

DELETE FROM product, prod_paper_link
USING product p, prod_paper_link pp
WHERE p.product_id = pp.product_id AND pp.product_id = 2
(product = table 1, prod_paper_link = table 2).
Could someone let me know what is incorrect with this script. Let me know if you need more information.

Re: Deleting multiple tables in MySQL

Posted: Sat Apr 10, 2010 12:29 pm
by Benjamin
:arrow: Moved to Databases