Skip to content

Instantly share code, notes, and snippets.

@fracasula

fracasula/mysql_delete_join.sql

Created February 25, 2014 12:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fracasula/9207700 to your computer and use it in GitHub Desktop.
Save fracasula/9207700 to your computer and use it in GitHub Desktop.
Download ZIP
Delete with Join in MySQL
Raw
mysql_delete_join.sql
DELETE `t` FROM `category_translation` AS `t`
LEFT JOIN `category` AS `c`
ON `c`.`id` = `t`.`id`
WHERE `c`.`id` IS NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment