...

View Full Version : Concurrency in mysql database



deshi2003
03-11-2009, 06: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???????

oracleguy
03-11-2009, 08: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.

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

http://dev.mysql.com/doc/refman/5.0/en/innodb-lock-modes.html

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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum