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

  • 2
    You'll need to do it one table at a time Commented Feb 22, 2017 at 15:56

1 Answer 1


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.