Mar
20
2016
mysql批量替换数据库表前缀
Select CONCAT( 'ALTER TABLE ', table_name, ' RENAME TO mtsfk_', substring(table_name,8),';' )FROM information_schema.tables Where table_name LIKE 'fsnkyy_%';
微信扫一扫，打赏作者吧～
Select CONCAT( 'ALTER TABLE ', table_name, ' RENAME TO mtsfk_', substring(table_name,8),';' )FROM information_schema.tables Where table_name LIKE 'fsnkyy_%';
最活跃的读者