``` SELECT CONCAT( 'ALTER TABLE ', table_name, ' RENAME TO 替换后的表_', substring(table_name, 替换位数:数字),';') FROM information_schema.tables where table_schema='数据库名' and table_name LIKE '查找前的表_%'; ```