Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

It's possible to avoid dirty read on a MySql database by using a PHP script? i have three two fields (user, incoming_request , outcoming_request) on my table that keep information (as string) about some in and out request between users. when a user (A) send a request to another one (B), i need to update outcoming_request field of A, and incoming_request field of B. i would that while this table update it's running, no others read query could be performed on incoming_request and outcoming_request A and B field. How can i do?

share|improve this question
Should we assume your table uses InnoDB or MyISAM? –  Michael - sqlbot Dec 18 '13 at 12:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.