hi, to explicitly lock a row (or rows), use : BEGIN TRAN select ... from ... where ... FOR UPDATE; update ...
COMMIT TRAN; Mathias Selon Mohammed Sameer <[EMAIL PROTECTED]>: > > need some urgent help > > im using InnoBD database type...i need to explicitly lock a row and keep it > locked until i explicitly unlock that row.. > > it would be great if u could provide me with sql statements as a solution for > the above... > > > > thanks > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
