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 --