1

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 – Andrew Brennan Feb 22 '17 at 15:56
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, privacy policy and cookie policy

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