SQL语句:
SELECT
CONCAT(
'ALTER TABLE ',
table_name,
' RENAME TO db_',
substring(table_name, 4), ';' ) FROM information_schema. TABLES WHERE table_name LIKE 'ct%';
原创文章,作者:ItWorker,如若转载,请注明出处:https://blog.ytso.com/tech/database/5737.html