update select

// 同一个表中用别的字段  处理后 补充没有的字段

update subscribe_apps a, (SELECT logo, id FROM subscribe_apps WHERE app_info IS NULL) b set a.app_info = CONCAT('{"id": 2,"logo":"', b.logo,'"}') WHERE a.app_info IS NULL AND a.id = b.id;