Read lock on mysql table
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.
yes, but only if the engine being used is INNODB:
otherwise, myISAM uses table locks...
just curious, why a lock on reads?