search

hxhac / mali

Life Manage
MIT License
0 stars 0 forks source link

需要把数据库里所有图片的domain替换成CDN #178

Closed hxhac closed 9 months ago

hxhac commented 9 months ago

https://jeffcott.oss-cn-beijing.aliyuncs.com

https://cdn.wrss.top

hxhac commented 9 months ago

还需要修改上传图片的url

hxhac commented 9 months ago 

mysql> update goods_evaluation set more = replace(more, 'jeffcott.oss-cn-beijing.aliyuncs.com', 'cdn.wrss.top') where id =  172;
Query OK, 1 row affected (0.04 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> 
mysql> 
mysql> update goods_evaluation set more = replace(more, 'jeffcott.oss-cn-beijing.aliyuncs.com', 'cdn.wrss.top') where 1=1;
Query OK, 323 rows affected (0.11 sec)
Rows matched: 422  Changed: 323  Warnings: 0
hxhac commented 9 months ago

在后台直接修改CDN的url即可

hxhac commented 9 months ago 

# https://cdn.wrss.top/mali/uploads/2023-08-11/beauty_1691655369446.JPG

update goods_evaluation set more = replace(more, 'https://cdn.wrss.top/mali/uploads', 'https://cdn.wrss.top/mali') where id =  172;

update goods_evaluation set more = replace(more, 'https://cdn.wrss.top/mali/uploads', 'https://cdn.wrss.top/mali') where 1=1;


mysql> update goods_evaluation set more = replace(more, 'https://cdn.wrss.top/mali/uploads', 'https://cdn.wrss.top/mali') where id =  172;
Query OK, 1 row affected (0.03 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update goods_evaluation set more = replace(more, 'https://cdn.wrss.top/mali/uploads', 'https://cdn.wrss.top/mali') where 1=1;
Query OK, 323 rows affected (0.12 sec)
Rows matched: 422  Changed: 323  Warnings: 0

mysql>