sql更新某一列字段值

mysql：update tableName set cloumnName = 0 where id>=1 and id < 1000;
postgresql:update kai_xuan.file_info t2 set scq_biz_record_id = 0 from (select id from kai_xuan.file_info) t1 where t1.id = t2.id;