sql语句实现设置表某个字段为当前日期

update components set deleted_at = now() where name = ‘XXX’ and deleted_at is NULL;

deleted_at = now();