Deleting multiple tables in MySQL
Posted: Sat Apr 10, 2010 2:25 am
I'm trying to delete records from multiple tables in MySQL but seem to be running into problems. Below is my script.
(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.
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 = 2Could someone let me know what is incorrect with this script. Let me know if you need more information.