delete rows from multiple tables

by

Well, if you had used InnoDB tables, you could set up a cascading delete with foreign keys that would do it all automatically. But if you have some reason for using MyISAM, You just use a multiple-table DELETE:

DELETE FROM boards, topics, messages
USING boards INNER JOIN topics INNER JOIN messages
WHERE boards.boardid = $boardid
    AND topics.boardid = boards.boardid
    AND messages.boardid = boards.boardid;

More Related Contents:

  1. Deleting rows with MySQL LEFT JOIN
  2. SQL DELETE with JOIN another table for WHERE condition
  3. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  4. Remove duplicate rows in MySQL
  5. How to delete from multiple tables in MySQL?
  6. MySQL DELETE FROM with subquery as condition
  7. MySQL InnoDB not releasing disk space after deleting data rows from table
  8. SQL query: Delete all records from the table except latest N?
  9. Remove duplicate rows leaving oldest row Only?
  10. Mysql delete statement with limit
  11. How do I delete all the duplicate records in a MySQL table without temp tables
  12. Delete from one table with join
  13. MySQL LIMIT on DELETE statement
  14. Delete all rows with timestamp older than x days
  15. Deleting a row based on the max value
  16. Deleting millions of rows in MySQL
  17. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  18. Combining UNION and LIMIT operations in MySQL query
  19. How to get only Digits from String in mysql?
  20. how to add super privileges to mysql database?
  21. Working around MySQL error “Deadlock found when trying to get lock; try restarting transaction”
  22. Restoring deleted ‘root’ user and password for MySQL
  23. How to truncate a foreign key constrained table?
  24. How do I get the ID of multiple inserted rows in MySQL?
  25. sql join tables where 1 column has comma
  26. MySQL get missing IDs from table
  27. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  28. MySQL query to select results with auto increment as a new column added in the result
  29. WHERE datetime older than some time (eg. 15 minutes)
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment