Mysql non-row-level table processing row-level locking _ MySQL-mysql tutorial

Mysql non-row-level table processing row-level lock bitsCN.com
We can usually use code to deal with row-level locking requirements. In some cases, InnoDB tables support row-level locking. Pass

In the MyISAM table, you can use a flag column in the table and perform operations similar to the following: UPDATE tbl_name SET row_flag = 1 WHERE id = ID; if a row is found, and the row_flag in the original row is not 1, mySQL returns 1 for the number of affected rows. You can think that MySQL will change the preceding query to: UPDATE tbl_name SET row_flag = 1 WHERE id = id and row_flag <> 1;
Author: fzxu_05bitsCN.com