I use the mysql command line tool to administrate my MySQL. I needed a quick way to drop all tables with the following prefix.
SELECT CONCAT('DROP TABLE `', TABLE_SCHEMA, '`.`', TABLE_NAME, '`;') FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE 'prefix%' and TABLE_SCHEMA = 'dbname';
Then all you have to do is take a text editor and replace all the “|” signs around the result.
PS: As you can see the query can be modified to get all tables with suffix, or all tables in a schema, or TRUNCATE all tables in the criteria.
One thought on “MySQL: Drop all tables with prefix”
Hey thank you for this friend.