DEV Community

Discussion on: Solve Phantom Read in MySQL

Collapse
 
lazypro profile image
ChunTing Wu • Edited

In the original approach, there is no parent table. The only one table, booking, without the corresponding data for the reservation. Thus, we cannot lock for nothing.

For this practical example, the room list might be stored at the MongoDB or any other data storage. After all, the room list is not the core of this system >.^