摘要： A locking read, anUPDATE, or aDELETEgenerally set record locks on every index record that is scanned in the processing of the SQL statement. It does not matter whether there areWHEREconditions in the statement that would exclude the row.InnoDBdoes not remember the exactWHEREcondition, but only knows 阅读全文