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
)
自测能用。
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
)
自测能用。