MySQL Forums
Forum List  »  Newbie

row lock on innodb database table
Posted by: Michael Kalinowski
Date: April 21, 2005 03:01PM

hi,

i installed mysql v4.1.11 on a windows 2003 server and it's working fine.
but if i want to realize a row lock on an innodb table like that

select * from mytable where myage = '30' for update

the selected rows should be locked against updating and deleting.
but this is not working.
if i try to delete the rows within the mysql query browser the rows will be deleted.

what can i do against that behaviour?

thanks in advance

michael

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.