Delete mysql table entry what has no relation to another table07.12.13

DELETE line_items FROM line_items LEFT JOIN products ON line_items.product_id = products.id WHERE products.id IS NULL; 07.12.13

http://www.freeopenbook.com/mysqlcookbook/mysqlckbk-CHP-12-SECT-22.html#mysqlckbk-CHP-12-SECT-22

DELETE b FROM sl_customer.dbo.abk AS b LEFT JOIN #_a AS a ON b.style = a.style WHERE a.style IS NULL; 07.12.13

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024