search

Home  >  Q&A  >  body text

What exactly does MySQL's SELECT...FOR UPDATE do?

http://www.cnblogs.com/houwei... After reading this article, I still don’t understand what this statement does. It is during the execution of the specified query statement. This query statement involves Are all rows locked when you arrive? Then other operations (such as UPDATE) must wait for this query statement to end before they can continue to execute, right?

And what does the statement SELECT ... LOCK IN SHARE MODE mean? Why do some articles say that it should be avoided as much as possible under InnoDB?

某草草某草草2747 days ago590

reply all(1)I'll reply

  • 仅有的幸福

    仅有的幸福2017-05-19 10:08:51

    Article

    reply
    0
  • Cancelreply