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 . User A delete from bb_usersession0 where ui_sessionid='cs_venkatesh0006A46C' AND us_billingstaus='B' User B 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 Regards velu --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php