title: Does SQL INSERT involve any read/write lock?
body: <p>This is an extremely simple question, but i really can't find any useful answer on Google.</p>
  
  <p>I've been reading that there's a READ LOCK on SELECT, and WRITE LOCK on UPDATE statements. However, i'm trying to find out if there's any kind of LOCK when we INSERT into a table?</p>
  
  <p>The assumption is that the table is using InnoDB as the engine.</p>