复制表
select concat('RENAME table ‘, table_schema, ‘.’, table_name, ’ to new_dbname.’, table_name, “;”) from information_schema.tables where table_schema in (‘dbname’);
清库:
select concat('truncate ', table_schema, ‘.’, table_name, ‘;’) from information_schema.tables where table_schema in (‘dbname’);
清库与复制表
最新推荐文章于 2024-08-30 14:18:30 发布