How to lock MySQL data sheet _php tutorial

When you are checking or patching a data table, you can lock the data table to ensure that the data table is secure:
Mysql>lock TABLE tbl_name READ;
Mysql>flush TABLES;
Work to lock the data table before checking or patching. After completion, unlock:
Mysql>unlock TABLES;
Lock table Tbl_name read indicates to be locked into a read-only state in which the user can only read the data table and cannot write.
Lock TABLE Tbl_name Write is a more restrictive lock that the user cannot read or write to.

http://www.bkjia.com/PHPjc/631174.html www.bkjia.com true http://www.bkjia.com/PHPjc/631174.html techarticle when you are checking or patching a datasheet, you can lock the data table to ensure that the data table is secure: Mysqllock table Tbl_name READ, Mysqlflush TABLES, lock data table before checking ...

