mysql批量修改查询结果集

sql不支持直接修改查询结果，所以要修改的字段属于哪个表，就update那个表，where主键相等就可以了
mysql update的where条件不支持直接in子查询的结果集，所以子查询外要嵌套一层查询并指定别名

UPDATE
  sm_free_member sfm
SET
  sfm.order_id =
  (SELECT
    MAX(order_id)
  FROM
    sm_order so
  WHERE so.member_id = sfm.member_id
    AND package_id = 10
    AND STATUS = 2)
WHERE sfm.free_member_id IN
  (SELECT
    temp.free_member_id
  FROM
    (SELECT
      sfm.free_member_id
    FROM
      sm_free_member sfm,
      sm_member sm
    WHERE sfm.free_recom_id = 40
      AND sfm.member_id = sm.member_id
      AND (sm.type = 4
        OR sm.type = 5)) AS temp)