row lock on innodb database table
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
Subject
Written By
Posted
row lock on innodb database table
April 21, 2005 03:01PM
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.