Deleting rows with MySQL LEFT JOIN

by

You simply need to specify on which tables to apply the DELETE.

Delete only the deadline rows:

DELETE `deadline` FROM `deadline` LEFT JOIN `job` ....

Delete the deadline and job rows:

DELETE `deadline`, `job` FROM `deadline` LEFT JOIN `job` ....

Delete only the job rows:

DELETE `job` FROM `deadline` LEFT JOIN `job` ....

More Related Contents:

  1. SQL DELETE with JOIN another table for WHERE condition
  2. Delete from one table with join
  3. delete rows from multiple tables
  4. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  5. Remove duplicate rows in MySQL
  6. Left Outer Join doesn’t return all rows from my left table?
  7. How to delete from multiple tables in MySQL?
  8. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  9. Left Join not returning all rows
  10. MySQL DELETE FROM with subquery as condition
  11. How to use mysql JOIN without ON condition?
  12. MySQL InnoDB not releasing disk space after deleting data rows from table
  13. SQL query: Delete all records from the table except latest N?
  14. sql join two table
  15. Difference in MySQL JOIN vs LEFT JOIN
  16. LEFT JOIN only first row
  17. MySQL: How do I join same table multiple times?
  18. Remove duplicate rows leaving oldest row Only?
  19. MYSQL Left Join COUNTS from multiple tables
  20. Mysql delete statement with limit
  21. How do I delete all the duplicate records in a MySQL table without temp tables
  22. Postgres LEFT JOIN with WHERE condition
  23. MySQL LIMIT on DELETE statement
  24. Delete all rows with timestamp older than x days
  25. Deleting a row based on the max value
  26. Deleting millions of rows in MySQL
  27. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  28. Fetching UTF-8 text from MySQL in R returns “????”
  29. MySQL – Persistent connection vs connection pooling
  30. ERROR: Loading local data is disabled – this must be enabled on both the client and server sides

Leave a Comment