MySQL plus lock test

Today research Cobar, do the execution time test, need to lock the table record. The following two methods are used to lock the table records.

The first way:

Begin Start a transaction

SELECT * FROM table name (where ...)   ) for update; So the result set is locked

Commit Commit TRANSACTION, Release lock

The second way:

In Insert/update and other modification table operations, nested with SELECT ... The Select table is locked when the statement is

Update USERTB SET field 1 = ' Zhang San ' where userId = (SELECT * From ...)

MySQL plus lock test