在mysql中应该如何修改表前缀?

操作windows10、mysql8.0.22版本、Dell G3电脑时mysql如何修改表前缀

使用sql语句修改mysql数据库表前缀名

首先我们想到的就是用sql查询语句来修改,这个方法也很方便，在运行 SQL 查询框中输入如下语名就可以了。

ALTER TABLE 原表名 RENAME TO 新表名;

如：

ALTER TABLE old_post RENAME TO new_post;

Sql查询语句有一个缺点，那就是一句SQL语句只能修改一张数据库的表名,如果你要精确修改某一张表，很好用。如果数据库表很多的话，比较麻烦。

但是我们可以通过一条语句一次性生成所有的sql语句：

select concat('alter table ',table_name,' rename to ',table_name) from information_schema.tables where table_name like'dmsck_%';

生成语句如下：

alter table dmsck_acategory rename to dmsck_acategory;

alter table dmsck_address rename to dmsck_address;

alter table dmsck_article rename to dmsck_article;

alter table dmsck_attrcategory rename to dmsck_attrcategory;

alter table dmsck_attribute rename to dmsck_attribute;

alter table dmsck_brand rename to dmsck_brand;

alter table dmsck_cart rename to dmsck_cart;

alter table dmsck_category_attr rename to dmsck_category_attr;

alter table dmsck_category_goods rename to dmsck_category_goods;

alter table dmsck_category_store rename to dmsck_category_store;

alter table dmsck_collect rename to dmsck_collect;

alter table dmsck_comment rename to dmsck_comment;

alter table dmsck_coupon rename to dmsck_coupon;

alter table dmsck_coupon_sn rename to dmsck_coupon_sn;

alter table dmsck_enterprise rename to dmsck_enterprise;

alter table dmsck_filmstrip rename to dmsck_filmstrip;

alter table dmsck_friend rename to dmsck_friend;

alter table dmsck_function rename to dmsck_function;

alter table dmsck_gattribute_rule rename to dmsck_gattribute_rule;

alter table dmsck_gcategory rename to dmsck_gcategory;

alter table dmsck_goods rename to dmsck_goods;

alter table dmsck_goods_attr rename to dmsck_goods_attr;

alter table dmsck_goods_bak rename to dmsck_goods_bak;

alter table dmsck_goods_down_log rename to dmsck_goods_down_log;

alter table dmsck_goods_image rename to dmsck_goods_image;

alter table dmsck_goods_old rename to dmsck_goods_old;

alter table dmsck_goods_qa rename to dmsck_goods_qa;

alter table dmsck_goods_spec rename to dmsck_goods_spec;

alter table dmsck_goods_statistics rename to dmsck_goods_statistics;

alter table dmsck_groupbuy rename to dmsck_groupbuy;

alter table dmsck_groupbuy_log rename to dmsck_groupbuy_log;

alter table dmsck_keyword rename to dmsck_keyword;

alter table dmsck_mail_queue rename to dmsck_mail_queue;

alter table dmsck_member rename to dmsck_member;

alter table dmsck_message rename to dmsck_message;

alter table dmsck_module rename to dmsck_module;

然后将其复制到一个文本文件中，将要修改的前缀统一修改(稍稍麻烦)，然后再复制到mysql中执行sql语句就ok了。

以上就是在mysql中该如何修改表前缀的全部内容，想了解更多的话请关注翼速网络应用平台获取更多内容！