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='F7601B'