广州凡科互联网科技有限公司

营业时间
MON-SAT 9:00-18:00

全国服务热线
18720358503

公司门店地址
广州市海珠区工业大道北67号凤凰创意园

dedecms如何大批量改动表作为前缀(运用sql句子)

日期:2021-03-19 浏览:

文中将为您详细介绍的是dedecms如何大批量改动表作为前缀(运用sql句子),实际实际操作方式可以看下面:

安裝DedeCMS的情况下,数据信息表作为前缀默认设置为dede_,当系统软件应用了一一段时间后,想变更数据信息表作为前缀,結果发觉并不是那麼非常容易。有木有大批量改动表作为前缀的方式?
在phpmyadmin实行以下SQL指令,将表作为前缀变换

改动好表作为前缀后,重新启动一下mysql,还必须改动/DATA/COMMON.INC.PHP文档中的$cfg_dbprefix = 'dede_'。及其对后台管理中的“频道栏目实体模型”-->“內容实体模型管理方法”中的相对的额外表(shop_addonarticle)也做一下改动。
ALTER TABLE dede_addonimages RENAME TO shop_addonimages; ALTER s RENAME s; ALTER TABLE dede_admin RENAME TO shop_admin; ALTER TABLE dede_admintype RENAME TO shop_admintype; ALTER TABLE dede_advancedsearch RENAME TO shop_advancedsearch; ALTER TABLE dede_arcatt RENAME TO shop_arcatt; ALTER ache RENAME ache; ALTER TABLE dede_archives RENAME TO shop_archives; ALTER TABLE dede_arcmulti RENAME TO shop_arcmulti; ALTER TABLE dede_arcrank RENAME TO shop_arcrank; ALTER TABLE dede_arctiny RENAME TO shop_arctiny; ALTER TABLE dede_arctype RENAME TO shop_arctype; ALTER TABLE dede_area RENAME TO shop_area; ALTER TABLE dede_channeltype RENAME TO shop_channeltype; ALTER TABLE dede_co_htmls RENAME TO shop_co_htmls; ALTER TABLE dede_co_mediaurls RENAME TO shop_co_mediaurls; ALTER TABLE dede_co_note RENAME TO shop_co_note; ALTER TABLE dede_co_onepage RENAME TO shop_co_onepage; ALTER TABLE dede_co_urls RENAME TO shop_co_urls; ALTER TABLE dede_diyforms RENAME TO shop_diyforms; ALTER TABLE dede_downloads RENAME TO shop_downloads; ALTER TABLE dede_erradd RENAME TO shop_erradd; ALTER TABLE dede_feedback RENAME TO shop_feedback; ALTER TABLE dede_flink RENAME TO shop_flink; ALTER TABLE dede_flinktype RENAME TO shop_flinktype; ALTER TABLE dede_freelist RENAME TO shop_freelist; ALTER TABLE dede_homepageset RENAME TO shop_homepageset; ALTER TABLE dede_keywords RENAME TO shop_keywords; ALTER TABLE dede_log RENAME TO shop_log; ALTER TABLE dede_member RENAME TO shop_member; ALTER pany RENAME pany; ALTER TABLE dede_member_feed RENAME TO shop_member_feed; ALTER TABLE dede_member_flink RENAME TO shop_member_flink; ALTER TABLE dede_member_friends RENAME TO shop_member_friends; ALTER TABLE dede_member_group RENAME TO shop_member_group; ALTER TABLE dede_member_guestbook RENAME TO shop_member_guestbook; ALTER TABLE dede_member_model RENAME TO shop_member_model; ALTER TABLE dede_member_msg RENAME TO shop_member_msg; ALTER TABLE dede_member_operation RENAME TO shop_member_operation; ALTER TABLE dede_member_person RENAME TO shop_member_person; ALTER TABLE dede_member_pms RENAME TO shop_member_pms; ALTER TABLE dede_member_snsmsg RENAME TO shop_member_snsmsg; ALTER TABLE dede_member_space RENAME TO shop_member_space; ALTER TABLE dede_member_stow RENAME TO shop_member_stow; ALTER TABLE dede_member_stowtype RENAME TO shop_member_stowtype; ALTER TABLE dede_member_tj RENAME TO shop_member_tj; ALTER TABLE dede_member_type RENAME TO shop_member_type; ALTER TABLE dede_member_vhistory RENAME TO shop_member_vhistory; ALTER TABLE dede_moneycard_record RENAME TO shop_moneycard_record; ALTER TABLE dede_moneycard_type RENAME TO shop_moneycard_type; ALTER TABLE dede_mtypes RENAME TO shop_mtypes; ALTER TABLE dede_multiserv_config RENAME TO shop_multiserv_config; ALTER TABLE dede_myad RENAME TO shop_myad; ALTER TABLE dede_mytag RENAME TO shop_mytag; ALTER TABLE dede_plus RENAME TO shop_plus; ALTER TABLE dede_pwd_tmp RENAME TO shop_pwd_tmp; ALTER TABLE dede_ratings RENAME TO shop_ratings; ALTER TABLE dede_scores RENAME TO shop_scores; ALTER TABLE dede_search_cache RENAME TO shop_search_cache; ALTER TABLE dede_search_keywords RENAME TO shop_search_keywords; ALTER TABLE dede_sgpage RENAME TO shop_sgpage; ALTER TABLE dede_shops_delivery RENAME TO shop_shops_delivery; ALTER TABLE dede_shops_orders RENAME TO shop_shops_orders; ALTER TABLE dede_shops_products RENAME TO shop_shops_products; ALTER RENAME ; ALTER TABLE dede_softconfig RENAME TO shop_softconfig; ALTER TABLE dede_stepselect RENAME TO shop_stepselect; ALTER TABLE dede_sys_enum RENAME TO shop_sys_enum; ALTER TABLE dede_sys_module RENAME TO shop_sys_module; ALTER TABLE dede_sys_set RENAME TO shop_sys_set; ALTER TABLE dede_sys_task RENAME TO shop_sys_task; ALTER TABLE dede_sysconfig RENAME TO shop_sysconfig; ALTER TABLE dede_tagindex RENAME TO shop_tagindex; ALTER TABLE dede_taglist RENAME TO shop_taglist; ALTER TABLE dede_uploads RENAME TO shop_uploads; ALTER TABLE dede_verifies RENAME TO shop_verifies; ALTER TABLE dede_vote RENAME TO shop_vote; ALTER TABLE dede_addonarticle RENAME TO shop_addonarticle;

根据文中的学习培训您是不是早已把握了dedecms如何大批量改动表作为前缀(运用sql句子)呢?

这种內容将会对你也是有协助
LEGEND工作中室 有着很多年的企业网站建设,dede仿站,dede建网站,seo优化工作经验,专业致力于于中小型型企业网站建设出示整套技术性适用,重视客户感受于一体的技术专业互连网服务,技术专业为顾客量身定做打造出顾客喜爱的网站服务平台 ...

网站流量统计:现有內容 篇 丨 今天升级了 篇內容 丨 仿站专用工具 个 丨 总访问量: 人数 丨 现有

————————最终升级 ————————



新闻资讯

联系方式丨CONTACT

  • 全国热线:18720358503
  • 传真热线:18720358503
  • Q Q咨询:2639601583
  • 企业邮箱:2639601583@qq.com

首页
电话
短信
联系