SELECT concat('DROP TABLE IF EXISTS ', table_name, ';') FROM information_schema.tables WHERE table_schema = 'zyrf';
SELECT concat('DROP TABLE IF EXISTS ', table_name, ';') FROM information_schema.tables WHERE table_schema = 'zyrf';
本文标题:mysql生成批量删除数据库命令
本文链接:https://www.haomeiwen.com/subject/ahkumktx.html
网友评论