Delete all row from all table from MYSQL DB with some ID clause

Question

Is it possible to delete all rows from all tables in MYSQL DB with some id = '123'.

Actually i needed this because there is lots of junk data in others table but in main table rows are deleted, i have the IDs.

Now the new logic is implemented in the right way but i have to delete previous rows. Is it possible in a single MYSQL query?

Thanks in advance

You'll need to do it one table at a time
– Andrew Brennan
Feb 22, 2017 at 15:56 — Andrew Brennan, Feb 22, 2017 at 15:56

SQL.RK · Accepted Answer · 2017-02-22 15:20:51Z

1

Quick Solution is to populate the ids to temp table and use Delete records from the table with Join to temp table.

answered Feb 22, 2017 at 15:20

SQL.RK

1333 bronze badges

Add a comment |

1 Answer 1