mysql 锁表lock tables/unlock tables

简单的数据库锁表操作

public function locktable(){    $sql="LOCK TABLES think_members WRITE";    $re=M()->execute($sql);    $sql1="select * from think_members where uid=1";    $res=M()->query($sql1);    $sql2="update think_members set password=56565 where uid=1";    $upd=M()->execute($sql2);    sleep(5);    $sql3 = "UNLOCK TABLES";     M()->execute($sql3); }public function locktables(){   $re=M('think_members')->select();   dump($re); }