Delete from two tables in one query

by

Can’t you just separate them by a semicolon?

Delete from messages where messageid = '1';
Delete from usersmessages where messageid = '1'

OR

Just use INNER JOIN as below

DELETE messages , usersmessages  FROM messages  INNER JOIN usersmessages  
WHERE messages.messageid= usersmessages.messageid and messages.messageid = '1'

More Related Contents:

  1. MySQL Insert query doesn’t work with WHERE clause
  2. Why would an IN condition be slower than “=” in sql?
  3. PostgreSQL GROUP BY different from MySQL?
  4. GROUP BY behavior when no aggregate functions are present in the SELECT clause
  5. Stored Procedure with optional “WHERE” parameters
  6. MySQL dump by query
  7. SQLite – ORDER BY RAND()
  8. Delete sql rows where IDs do not have a match from another table
  9. How to search multiple columns in MySQL?
  10. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  11. MySQL – Selecting data from multiple tables all with same structure but different data
  12. What does DELIMITER // do in a Trigger?
  13. Does Mysql have an equivalent to @@ROWCOUNT like in mssql?
  14. MySQL equivalent of DECODE function in Oracle
  15. How do you version your database schema? [closed]
  16. Can a stored procedure/function return a table?
  17. MySQL, Get users rank
  18. Mysql: how to select groups having certain values?
  19. How to fill date gaps in MySQL?
  20. Adding a new SQL column with a default value
  21. Boolean vs tinyint(1) for boolean values in MySQL
  22. Selecting all corresponding fields using MAX and GROUP BY
  23. MySQL full text search for words with three or less letters
  24. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  25. Function for week of the month in mysql
  26. MySQL’s alternative to T-SQL’s WITH TIES
  27. Find rows that have the same value on a column in MySQL
  28. what is the difference between GROUP BY and ORDER BY in sql
  29. I want to copy table contained from one database and insert onto another database table
  30. How do MySQL views work?

Leave a Comment