lock creation issue.

[emmitt]

Hi all,
i tried to obtain the write lock on account numbers 1001 and 1005, using the mysql sql browser-1 i tried:
set autocommit=0
select * from account_master where accno = '1001' and accno = '1005' lock in shared mode;
commit;

and from Second browser

set autocommit=0
select * from account_master where accno = '1001' and accno = '1005' lock in shared mode;
commit;

I didn't get any errors in acquiring the locks from First browser Plz suggest some fix for it.
thanx -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[domin]

hi, I would like to tell you that lock in share mode is a Read lock not Write lock
and use Select .... For Update to write lock. Hope that will fix ur problem.
all the best. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --