批量修改表前缀
SELECT
CONCAT(
'ALTER TABLE ',
table_name,
' RENAME TO bk',
substring(table_name, 5),
';'
)
FROM
information_schema. TABLES
WHERE
table_name LIKE 'base_%';
关于 LearnKu
粤公网安备 44030502004330号