update episode set screen_shot = REPLACE(screen_shot, screen_shot, concat(screen_shot,'.jpg')) where INSTR(screen_shot,'jpg')<=0;
将episode表中所有没有包含'.jpg'后缀的screen_shot字段添加jpg后缀, 这样可以省去写脚本来批量实现
update episode set screen_shot = REPLACE(screen_shot, screen_shot, concat(screen_shot,'.jpg')) where INSTR(screen_shot,'jpg')<=0;
将episode表中所有没有包含'.jpg'后缀的screen_shot字段添加jpg后缀, 这样可以省去写脚本来批量实现