22
Nov
Learn how to delete rows with MySQL LEFT JOIN
Think you have 2 tables with foreign key. Then, you can select some records using LEFT JOIN. SELECT * FROM talbe_1 LEFT JOIN talbe_2 ON talbe_1.fk_id = talbe_2.fk_id WHERE talbe_1.status = 1; But, if you need to delete using LEFT JOIN then you get a sql error. DELETE * FROM talbe_1 LEFT JOIN talbe_2 ON […]
Continue Reading →