Oracl has the use of drop table like, but MySQL does not, you can write scripts (do not repeat), you can also assemble SQL.
Note that my database name is test, there is a table called data, and then I prepare four tables with the same prefix, bulk Delete, prepare the data can be used this SQL
CREATE TABLE test_1201 SELECT * from ' data ';
CREATE TABLE test_1202 SELECT * from ' data ';
CREATE TABLE test_1203 SELECT * from ' data ';
CREATE TABLE test_1205 SELECT * from ' data ';
SELECT CONCAT (' DROP TABLE ', GROUP_CONCAT (table_name), '; ') As statement from information_schema.tables WHERE table_schema = ' test ' and table_name like ' test_12% ';
On top of this SQL is to display a SQL result, the above execution of the results of the execution side.
(Just change Table_schema (this is the name of the database), with table_name (this is the name of the data table)
DROP TABLE test_1201,test_1202,test_1203;
Mysql Bulk Delete prefix or suffix table