Jeaf Gilbert
Reputation: 12021
MySQL: Delete row if id doesn't exist in other table
I think this is newbie ask. How to delete row if id doesn't exist in other table? My thought is fetch the ids first and delete. I'm looking for better querying.
Upvotes: 5
Views: 5755
Answers (1)
Related Questions
- Delete from a table where value doesn't exist in another table
- SQL - delete row if another table exists
- delete one row by Specific ID which the same is not present another table Column ID
- Two tables - how to delete rows if ID not referenced in both tables
- Deleting rows from one table if row exists in another table in MySQL
- MySQL: delete row if exist in other table with condition
- DELETE values from one table with id that doesn't exist in another in mysql
- MySQL delete row if id is found in another row
- Delete from table when field does not match another table in MySQL
- MySQL - Delete rows in one table if a value in a different table isn't present in any rows