时间:2021-07-01 10:21:17 帮助过:18人阅读
图片有三种:
大:http://media.digikey.com/Photos/Skyworks%20Solutions%20Photos/SE2564L-R_tmb.jpg
中:http://media.digikey.com/Photos/Skyworks%20Solutions%20Photos/SE2564L-R_sml.jpg
小:http://media.digikey.com/Photos/Skyworks%20Solutions%20Photos/SE2564L-R_tmb.jpg
由于有规律,替换起来很容易。
UPDATE t_product_copy tpc
SET tpc.img= REPLACE(img,'_tmb', '_sml')
执行结果:(该字段有很多数据为空,不修改)
[SQL] UPDATEt_product_copy tpc
SET tpc.img= REPLACE(img,'_tmb', '_sml')