Hi, I have started using innodb for an application I want to build.
The application inserts customers, along with other data in the database.
My question:
Is there a way to lock a particicular record so that only one person can access it.
I mean, when an employee of my company opens a record either to see it or update it, how can I be sure that at the same time another employee does not edit or even delete the same record.
I tried select .. lock in share mode and select .. for update but they did not do what I expected, I could still access the same entry from multiple clients.
Any ideas?
Thanks.
