title: Parallel Transactions in mysql
body: <p>My database contains table named <code>sample_table</code> consists of one column named as <code>user_first_name</code> and the table was empty</p>
  
  <p>Suppose I have 2 transactions like this</p>
  
  <pre><code>START TRANSACTION;
  INSERT INTO sample_table VALUES("TEJA");
  INSERT INTO sample_table VALUES("TEJA");
  INSERT INTO sample_table VALUES("TEJA");
  INSERT INTO sample_table VALUES("TEJA");
  INSERT INTO sample_table VALUES("TEJA");
  INSERT INTO sample_table VALUES("TEJA");
  INSERT INTO sample_table VALUES("TEJA");
  //......... till 10000 times
  COMMIT
  
  START TRANSACTION;
  SELECT * FROM sample_table;
  SELECT * FROM sample_table;
  SELECT * FROM sample_table;
  SELECT * FROM sample_table;
  SELECT * FROM sample_table;
  SELECT * FROM sample_table;
  //........ till 10000 times 
  COMMIT
  </code></pre>
  
  <p>I run these two transactions in parallel in such a way, first the transaction1 started and then transaction2 when transaction1 was running. I expected that the result will have some rows with name TEJA. But I am getting an empty result.
  Please help me to explain why the result is empty?</p>