Concurrent Access to Tables with Shared Locks

After the LOCK TABLE statement that specifies the IN SHARE MODE keywords executes successfully, other users can read the table but cannot modify its data until the lock is released. In databases that support transaction logging, the SELECT statement can implicitly place a shared lock on each tables that is listed in the FROM clause, in order to prevent other users from modifying those tables until the query is committed or rolled back.