SQL for MySQL Developers: A Comprehensive Tutorial and Reference

Chapter 37. Transactions and Multiuser Usage

37.1 Introduction

So far in this book, we have assumed that you are the only user of the database. If you do the examples and exercises at home, that assumption is probably correct. But if you work with MySQL in your company, for example, the odds are good that you share the database with many other users. We call this multiuser usage as opposed to single-user usage. In a multiuser environment, you should not be aware that other users are accessing the database concurrently because MySQL hides this from you as much as possible.

The following question might arise: What happens if I access a row that is already in use by someone else? This chapter answers that question. We start with a concept that ...