SELECT CONCAT( ‘ALTER TABLE ‘, table_name, ‘ RENAME TO db_‘, substring(table_name, 4), ‘;‘ ) FROM information_schema. TABLES WHERE table_name LIKE ‘ct%‘;
批量修改表前缀
原文：https://www.cnblogs.com/hl15/p/12238366.html
