UPDATE yhpczg SET yqsj=(CAST(wcsj AS SIGNED)-CAST(jcsj AS SIGNED)) WHERE id='206'
说明:就是需要将2个无符号的字段转成有符号的