批量更新某字段内容

https://wx.qlogo.cn/mmopen/vi_32/DYAIOgq83eozicrdmeZWHYB4s7Y3qwOOVolnPX3gWiauXlspcH17zL4rOAITPVF6PjoEGHfDSLUicHhZ1LpRcTY9w/0

update user set avatarUrl=concat(left(avatarUrl,char_length(avatarUrl)-1),'64') 换头像

将数据库中存的微信头像，默认0 原图，改为64大小的图