Reference Citations - HerongYang.com - v2.91, by Dr. Herong Yang
Locking Rows In MySQL
'Locks Used in MySQL' tutorial was cited in an xpertdeveloper.com article in 2020.
The Locks Used in MySQL tutorial was cited in an xpertdeveloper.com article in 2020.
Subject: Locking Rows In MYSQL Date: Apr 18, 2020 Author: Avinash Source: http://www.xpertdeveloper.com/2011/11/row-locking-with-mysql/ Let’s talk first about the type and levels of locking : Types of locking: 1- Read Lock or a shared lock: 2- Write Lock or an exclusive lock: Levels of locking: 1- Table lock: All the rows will be locked when the table is locked. 2- Row lock : Some rows will be locked in the table, but other rows will not be locked. 3- Column lock: Some columns of a row will be locked, but other columns are not locked. ... References: http://www.herongyang.com/MySQL/Lock-Used-in-MySQL.html http://www.xpertdeveloper.com/2011/11/row-locking-with-mysql/
Table of Contents