废话懒得说了 将SELECT出的结果再通过中间表SELECT一遍,这样就规避了错误。 update truth_jt set fee='1' where id in (SELECT j.id from (SELECT j.id from truth_jt j ) j )