Mysql锁表和解锁

1. //执行SQL语句 锁掉stat_num表
2.  
   $sql = "LOCK TABLES stat_num WRITE"; //表的WRITE锁定，阻塞其他所有mysql查询进程
3.  
   $DatabaseHandler->exeCute($sql);
4.  
   //执行更新或写入操作
5.  
   $sql = "UPDATE stat_num SET `correct_num`=`correct_num`+1 WHERE stat_date='{$cur_date}'";
6.  
   $DatabaseHandler->exeCute($sql);
7.  
   //当前请求的所有写操作做完后，执行解锁sql语句
8.  
   $sql = "UNLOCK TABLES";
9.  
   $DatabaseHandler->exeCute($sql);

10.