thinkphp5 锁表操作

这个问题坑了很久.中间经历了很多艰难的过程,,研究了半天的源码,唉,不多说了

主要是设置options   的PDO配置,因为原来的框架本身设置,导致锁表报错.

$options = Config::get('database');$options['params'] = [    \PDO::ATTR_CASE => \PDO::CASE_NATURAL,    \PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION,    \PDO::ATTR_ORACLE_NULLS => \PDO::NULL_NATURAL,    \PDO::ATTR_STRINGIFY_FETCHES => false,    \PDO::ATTR_EMULATE_PREPARES => true,];$db_instance = Db::connect($options);$db_instance->execute('lock table interface read');$db_instance->execute('LOCK TABLES interface WRITE');sleep(10);

$db_instance->execute('UNLOCK tables');