UPDATE 表名 SET interest=0.0 WHERE id IN
(
SELECT id FROM
(SELECT id FROM 表名 WHERE
firstInspectionTime IS NULL AND
secondInspectionTime IS NULL AND
thirdInspectionTime IS NULL AND
da_state <> 'D' ) 别名
)
UPDATE 表名 SET interest=0.0 WHERE id IN
(
SELECT id FROM
(SELECT id FROM 表名 WHERE
firstInspectionTime IS NULL AND
secondInspectionTime IS NULL AND
thirdInspectionTime IS NULL AND
da_state <> 'D' ) 别名
)