PDA

View Full Version : Lock read and write to database

Slurry
10-03-2002, 07:26 AM
How do I lock read and write to a mysql database?
Spookster
10-03-2002, 07:47 AM
MySQL handles all of that for you.
Slurry
10-08-2002, 01:23 AM
how though?

Im trying to lock a database to prevent data corruption due to simultaneous transactions. How can this be taken care of?
Spookster
10-08-2002, 02:44 AM
You don't need to lock the table. MySQL provides you with atomic transactions. This is all handled for you. You can do it manually but that is pointless. I'm not sure how else I can explain that.
Slurry
10-08-2002, 03:40 AM
Does this depend on what type the table in question is?
Spookster
10-08-2002, 04:11 AM
Yes it can depend on what kind of table you have set. Try searching through the MySQL documentation for table locking:

http://www.mysql.com/doc/en/index.html