mysql更新时，把查询结果作为条件

 SET dm_device.device_type = 5 WHERE dm_device.id  IN ( SELECT id FROM  ( SELECT id FROM dm_device WHERE dm_device.device_type =2 AND dm_device.del_flag = 0 ) AS t)