ThinkPHP3.2使用DRDS，无法使用SHOW COLUMNS

2019独角兽企业重金招聘Python工程师标准>>>

编辑/ThinkPHP/Library/Think/Db/Driver.class.php

找到connect方法

/**
 * 连接数据库方法
 * @access public
 */
public function connect($config='',$linkNum=0,$autoConnection=false) {
    if ( !isset($this->linkID[$linkNum]) ) {
        if(empty($config))  $config =   $this->config;
        try{
            if(empty($config['dsn'])) {
                $config['dsn']  =   $this->parseDsn($config);
            }
            if(version_compare(PHP_VERSION,'5.3.6','<=')){ 
                // 禁用模拟预处理语句
                $this->options[PDO::ATTR_EMULATE_PREPARES]  =   false;
            }
            $this->linkID[$linkNum] = new PDO( $config['dsn'], $config['username'], $config['password'] , $this->options);
        }catch (\PDOException $e) {
            if($autoConnection){
                trace($e->getMessage(),'','ERR');
                return $this->connect($autoConnection,$linkNum);
            }elseif($config['debug']){
                E($e->getMessage());
            }
        }
    }
    return $this->linkID[$linkNum];
}

注释下面这行代码即可

//$this->options[PDO::ATTR_EMULATE_PREPARES]  =   false;

 

转载于:https://my.oschina.net/colinadmin/blog/889517