Mysql – delete from multiple tables with one query [duplicate]

by

Apparently, it is possible. From the manual:

You can specify multiple tables in a DELETE statement to delete rows from one or more tables depending on the particular condition in the WHERE clause. However, you cannot use ORDER BY or LIMIT in a multiple-table DELETE. The table_references clause lists the tables involved in the join. Its syntax is described in Section 12.2.8.1, “JOIN Syntax”.

The example in the manual is:

DELETE t1, t2 FROM t1 INNER JOIN t2 INNER JOIN t3
WHERE t1.id=t2.id AND t2.id=t3.id;

should be applicable 1:1.

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  3. How to reset AUTO_INCREMENT in MySQL
  4. MySQL: Insert record if not exists in table [duplicate]
  5. MySQL Query GROUP BY day / month / year
  6. How do I escape special characters in MySQL?
  7. Enable remote MySQL connection: ERROR 1045 (28000): Access denied for user
  8. SQL counting all rows instead of counting individual rows
  9. How do I change the data type for a column in MySQL?
  10. mysql fulltext search failure
  11. Adding a leading zero to some values in column in MySQL
  12. Update one MySQL table with values from another
  13. How to connect mysql workbench to running mysql inside docker?
  14. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
  15. MySQL Order before Group by
  16. MySQL Group By and Sum total value of other column
  17. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  18. Export a MySQL Database to SQLite Database
  19. How to display open transactions in MySQL
  20. SQL search multiple values in same field
  21. Removing duplicates with unique index
  22. MySQL – Select the last inserted row easiest way
  23. Getting number of rows inserted for ON DUPLICATE KEY UPDATE multiple insert?
  24. MySQL query, MAX() + GROUP BY
  25. ALTER table – adding AUTOINCREMENT in MySQL
  26. Does MySQL foreign_key_checks affect the entire database?
  27. In MySQL what does “Overhead” mean, what is bad about it, and how to fix it?
  28. How to initialize mysql container when created on Kubernetes?
  29. Find duplicates in the same table in MySQL
  30. Auto-increment is not resetting in MySQL

Leave a Comment