DESTOON 更换域名

摘要

DESTOON 更换域名 sql操作法 注意表前缀 如果是自定义的 记得换成自己的

sql操作法:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
update destoon_ad set url =
 replace(url, "oldDomain", "newDomain");
 
update destoon_article_21 set thumb =
 replace(thumb, "oldDomain", "newDomain");
 
update destoon_article_data_21 set content =
 replace(content, "oldDomain", "newDomain");
 
update destoon_buy set thumb =
 replace(thumb, "oldDomain", "newDomain");
 
update destoon_buy set thumb1 =
 replace(thumb1, "oldDomain", "newDomain");
 
update destoon_buy set thumb2 =
 replace(thumb2, "oldDomain", "newDomain");
 
update destoon_buy_data set content =
 replace(content, "oldDomain", "newDomain");
 
 update destoon_comment set item_linkurl =
 replace(item_linkurl, "oldDomain", "newDomain");
 
 update destoon_company set thumb =
 replace(thumb, "oldDomain", "newDomain");
 
 update destoon_company set homepage =
 replace(homepage, "oldDomain", "newDomain");
 
 update destoon_company set linkurl =
 replace(linkurl, "oldDomain", "newDomain");
 
 update destoon_company_data set content =
 replace(content, "oldDomain", "newDomain");
 
 update destoon_company_setting set item_value =
 replace(item_value, "oldDomain", "newDomain");
 
 update destoon_exhibit set thumb =
 replace(thumb, "oldDomain", "newDomain");
 
 update destoon_exhibit_data set content =
 replace(content, "oldDomain", "newDomain");
 
 update destoon_honor set thumb =
 replace(thumb, "oldDomain", "newDomain");
 
 update destoon_honor set content =
 replace(content, "oldDomain", "newDomain");
 
 
 update destoon_module set linkurl =
 replace(linkurl, "oldDomain", "newDomain");
 
 update destoon_news set linkurl =
 replace(linkurl, "oldDomain", "newDomain");
 
 update destoon_news_data set content =
 replace(content, "oldDomain", "newDomain");
 
 update destoon_page set linkurl =
 replace(linkurl, "oldDomain", "newDomain");
 
 update destoon_page_data set content =
 replace(content, "oldDomain", "newDomain");
 
 update destoon_message set content =
 replace(content, "oldDomain", "newDomain");
 
 update destoon_sell_data set content =
 replace(content, "oldDomain", "newDomain");
 
 
 update destoon_sell set thumb =
 replace(thumb, "oldDomain", "newDomain");
 
 update destoon_sell set thumb1 =
 replace(thumb1, "oldDomain", "newDomain");
 
 update destoon_sell set thumb2 =
 replace(thumb2, "oldDomain", "newDomain");
 
 
 update destoon_upload_0 set fileurl =
 replace(fileurl, "oldDomain", "newDomain");
 
 
 update destoon_upload_1 set fileurl =
 replace(fileurl, "oldDomain", "newDomain");
 
 
 update destoon_upload_2 set fileurl =
 replace(fileurl, "oldDomain", "newDomain");
 
 
 update destoon_upload_3 set fileurl =
 replace(fileurl, "oldDomain", "newDomain");
 
 
 update destoon_validate set thumb =
 replace(thumb, "oldDomain", "newDomain");
 
 update destoon_validate set thumb1 =
 replace(thumb1, "oldDomain", "newDomain");
 
 update destoon_validate set thumb2 =
 replace(thumb2, "oldDomain", "newDomain");
 
 update destoon_link set linkurl =
 replace(linkurl, "oldDomain", "newDomain");
 
 update destoon_know_data set content =
 replace(content, "oldDomain", "newDomain");
 
 update destoon_webpage  set content =
 replace(content, "oldDomain", "newDomain");
 
 update destoon_favorite set url =
 replace(url, "oldDomain", "newDomain");
 
 update destoon_announce set linkurl =
 replace(linkurl, "oldDomain", "newDomain");

然后 后台更新数据 页面 模块 即可

avatar

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: