數(shù)據(jù)庫： 原前綴: 新前綴: 執(zhí)行

SELECT CONCAT( 'ALTER TABLE ', table_name, ' RENAME TO tool', SUBSTRING( table_name,7 ), ';' ) FROM information_schema.TABLES WHERE table_schema = 'toolnb'#數(shù)據(jù)庫 AND table_name LIKE 'toolnb%'#篩選前綴進(jìn)行替換