select concat(‘drop table ‘,table_name,‘;‘) from information_schema.tables where table_schema=‘employees‘ and table_name rlike ‘^d.*$‘ into outfile ‘d:/b.sql‘;
2021-08-17 07:43:04
select concat(‘drop table ‘,table_name,‘;‘) from information_schema.tables where table_schema=‘employees‘ and table_name rlike ‘^d.*$‘ into outfile ‘d:/b.sql‘;