fracasula
2/25/2014 - 12:09 PM

Delete with Join in MySQL

Delete with Join in MySQL

DELETE `t` FROM `category_translation` AS `t`
LEFT JOIN `category` AS `c`
ON `c`.`id` = `t`.`id`
WHERE `c`.`id` IS NULL;