I'm a newbie to MySQL so if this is a common question, forgive me, but I can't find an answer.
How do I prevent data collision in the following scenario: User A and User B are examining the same data (say a customer's name and address). User A modifies something (say the customer's phone number) and saves the transaction. User B modifies something different at the same time. How can I prevent User B's modification from being saved? This is a database I'm converting from Foxpro, and there I would have just told User B that User A had the data open, and prevented them from editing it. I'm sure there's a better way. Thanks for your advice. David Dice