UPDATE tbl_dh_meter l INNER JOIN (
SELECT
tbl_Index ,Metersn
FROM
tbl_dh_meter x
) A ON l.tbl_Index= A.tbl_Index
SET UniqueEncoding=A.Metersn,SerialNumber=''
与sqlserver有所不同,做个记录。