When mysql is updated, the query result is used as a condition

 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)