一个一个修改表名是一件麻烦事,尤其是在表很多的情况下。那么有简单方式吗?
SELECT
CONCAT(
'ALTER TABLE ',
table_name,
' RENAME TO ms_',
substring(table_name, 5),
';'
) sqls
FROM
information_schema.tables Where table_schema='a' and table_name LIKE 'ms_%';
这样就会输出:
ALTER TABLE ms__ad RENAME TO ms_ad;
ALTER TABLE ms__ad_position RENAME TO ms_ad_position;
ALTER TABLE ms__address RENAME TO ms_address;
ALTER TABLE ms__admin RENAME TO ms_admin;
ALTER TABLE ms__attribute RENAME TO ms_attribute;
ALTER TABLE ms__attribute_category RENAME TO ms_attribute_category;
把结果拷贝出来,直接执行即可。
---------------------
作者:呓语的风
来源:CSDN
原文:https://blog.csdn.net/zml_moxueli/article/details/81503782
版权声明:本文为博主原创文章,转载请附上博文链接!