MySQL LOCK TABLE
Mysql Locks
Row Level Locking