哈哈
2123
-- 把下面的 your_db 换成目标数据库名
SELECT CONCAT(
'RENAME TABLE ', table_schema, '.', table_name, ' TO ',
table_schema, '.', SUBSTRING(table_name, LENGTH('jycms_') + 1), ';'
) AS rename_sql
FROM information_schema.tables
WHERE table_schema = '_103_8_70_31' -- 目标库
AND table_name LIKE 'jycms_%';
评论