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