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

 UPDATE dm_device 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)