I need to drop all tables with name test_*
First execute this sql code and get new statement
SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' )
AS statement FROM information_schema.tables
WHERE table_name LIKE 'test_%';
Then copy new statement and execute it too