SELECT CONCAT( 'ALTER TABLE ', table_name, ' RENAME TO db_', substring(table_name, 4), ';' )FROM information_schema. TABLESWHERE table_name LIKE 'ct%';
批量修改表前缀
摘要: SELECT
CONCAT(
'ALTER TABLE ',
table_name,
' RENAME TO db_',
substring(table_name, 4),
';'
)
F
87 阅读
← 返回技术栈