Read lock on mysql table

[okmich]

Hello all,

I have a project at hand. It need the application to acquire lock on a row while it is being read so that no two persons can read one row simultaneously.

Can mysql offer this locking mode? Or should I move this feature to the application level instead of the db level.

ANticipating a response.

Thanks

Michael

[ldivinag]

yes, but only if the engine being used is INNODB:
http://dev.mysql.com/doc/refman/5.0/...l-locking.html

otherwise, myISAM uses table locks...

just curious, why a lock on reads?