Delete with Join in MySQL

by

You just need to specify that you want to delete the entries from the posts table:

DELETE posts
FROM posts
INNER JOIN projects ON projects.project_id = posts.project_id
WHERE projects.client_id = :client_id

EDIT: For more information you can see this alternative answer

More Related Contents:

  1. convert mysql query to laravel query builder
  2. how to generate report for attendance system
  3. How can I return pivot table output in MySQL?
  4. MySQL pivot table query with dynamic columns
  5. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
  6. Finding duplicate values in MySQL
  7. What is the size of column of int(11) in mysql in bytes?
  8. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  9. MySQL – Selecting a Column not in Group By
  10. Join tables from two different server
  11. MySQL : isn’t in GROUP BY
  12. Why does MySQL report a syntax error on FULL OUTER JOIN?
  13. Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
  14. SQL: Creating a Relational table with 2 different auto_increment
  15. CURRENT_DATE/CURDATE() not working as default DATE value
  16. How to extract the nth word and count word occurrences in a MySQL string?
  17. MySql Count cannot show 0 values
  18. Cannot change column used in a foreign key constraint
  19. How does one create an index on the date part of DATETIME field in MySql
  20. How to delete a MySQL record after a certain time
  21. using (-) dash in mysql table name
  22. Force InnoDB to recheck foreign keys on a table/tables?
  23. Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT
  24. Let MySQL users create databases, but allow access to only their own databases
  25. How can I enable MySQL’s slow query log without restarting MySQL?
  26. Does MySQL allows to create database with dot?
  27. Second SELECT query if first SELECT returns 0 rows
  28. MySQL throws Incorrect string value error
  29. mysql create table dynamically
  30. Errno 121, duplicate key on write or update?

Leave a Comment