View Full Version : Concurrency in mysql database

03-11-2009, 07:13 PM
i want to maintain concurrency in mysql. like when user is updating a particular table then no can access this row. how could i can do this. or give me some tips to maintain concurrency in mysql or any other database indetail

How would i get time in am or pm format by using curtime() function???????

03-11-2009, 09:19 PM
I'm not totally sure you can do this just in MySQL. You might have to implement an external locking solution to handle this in your application.

03-11-2009, 09:37 PM
If you use the engine InnoDB and transactions, you can do shared and exclusive locks on data.


Look up date_format() in the manual for answers to your second question.