Closed xbpk3t closed 11 months ago
还需要修改上传图片的url
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
在后台直接修改CDN的url即可
# 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>
https://jeffcott.oss-cn-beijing.aliyuncs.com
https://cdn.wrss.top