title: Does MySql automatically lock rows or do I need to add "lock in share mode"?
body: <p>We're beginners and our java  software gets queries from the database using select * etc.</p>
  
  <p>My question is do we need to add lock in share mode and "FOR UPDATE" to enforce the locks, or are table and row locks automatic?</p>
  
  <p>We have one table where we want to enforce concurrency, could I just add LOCK TABLE to the table i need to lock, update then values, then unlock it?</p>