mysql 同表子查询sql 。仅记录

UPDATE goodabase_mcht.tbl_wm_device_bind SET term_no = 1 WHERE sn IN (
SELECT sn FROM (     //mysql 必要的语句
 SELECT sn FROM goodabase_mcht.tbl_wm_device_bind WHERE device_id = 1
) a
)

 

自测能用。