Mysql Drop multi tables

- Drop multi table:

SET @tables = (SELECT CONCAT('DROP TABLE ', GROUP_CONCAT(table_name) , ';')
  FROM INFORMATION_SCHEMA.TABLES
  WHERE table_name LIKE 'tbl_data_9%');

PREPARE dynStmt FROM @tables;
EXECUTE dynStmt;
DEALLOCATE PREPARE dynStmt;

- Show table like:

SHOW TABLES LIKE 'tbl_data%';

- Create table like;

 create table tbl_data_1 like tbl_exam_data_1;