mysql - Delete all records from each table having a specific column value -
- find every table in same database has field client_id
- delete records client_id = 123
above scenario. i'm wondering if it's possible using mysql single query.
you don't know names of tables client_id field, can found using informational schema , stored in temporary table. then, dynamic query should generated in loop delete required records. that.
Comments
Post a Comment