mysql生成批量删除数据库命令

2020-10-22 本文已影响0人超音速6

SELECT concat('DROP TABLE IF EXISTS ', table_name, ';') FROM information_schema.tables WHERE table_schema = 'zyrf';