MYSQL Table locking

his topic can be new to some but its very much important when working with concurrent access to a particular table row (record). for example lets say we have a inventory table which has some product details as records. now, a scenario arises like user purchases a product and we need to update its...