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