for query: update tables left join `schema` on tables.schemaid=`schema`.id  set metric=metric+1 where `schema`.`schema`='812' and tables.systemcode='' and tables.name='F06927'