Dear Mr. Venu & Tech Group,
We are facing few problem in mysql database.
Take an eg.
we have table called bb_usersession0
user A is trying to delete a record which is having the billingstatus B .
delete from bb_usersession0 where ui_sessionid='cs_venkatesh0006A46C' AND
update bb_usersession0 set us_billingstatus='Y' where us_billingstatus='N';
In the above case mYSQL IS LOCKING THE whole table so the USER B is not
able to update the status.In user session B we are getting the followin message
ERROR 1205: Lock wait timeout exceeded; Try restarting transaction
Kindly give me solution for the above problem.
Awaiting your reply