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.
Powered by vBulletin® Version 4.2.2 Copyright © 2016 vBulletin Solutions, Inc. All rights reserved.