update TousseOperation set operationType = '自动流转' where remark in('入库自动回退','系统联动自动签收。','系统自动流转签收。','签收修改了仓库') and operationType is null; update TousseOperation set operationType = '手工流转' where (remark not in('入库自动回退','系统联动自动签收。','系统自动流转签收。','签收修改了仓库') or remark is null) and operationType is null;