Lock a row

[Russel James]

It is possible to lock a row so that only one user can access it at a time ?

I have a sproc that increments a value and returns the new value as follows:


CREATE DEFINER=`root`@`localhost` PROCEDURE `usp_SystemControlGetNextPLInvNumber`()
BEGIN


/* LOCK */
UPDATE systemControl SET PLInvNumber = PLInvNUmber + 1;

Select PLInvNUmber FROM systemControl;
/* UNLOCK */

END

But I want to make sure the the same number is never returned twice.

Can this be done ?

J