$grammar = $conn->getQueryGrammar(); $processor = $conn->getPostProcessor(); $sql = "select column_name from information_schema.columns where table_schema = 'gold_db' and table_name =\r\n't_crm_soa_order'"; $sql = 'desc t_crm_soa_order'; //dd($conn->getColumnListing($table)); //$conn->statement(); $ret = $conn->select($sql); $queryBuilder = new Illuminate\Database\Query\Builder($conn, $grammar, $processor); //dd($queryBuilder->getColumnListing($table)); dd($ret); exit; $conn->affectingStatement(); $conn->commit(); //dd($conn->getColumnListing($table)); //dd($conn->statement('desc t_crm_soa_order')); dd($queryBuilder->select('desc t_crm_soa_order')); dd($conn->statement('desc t_crm_soa_order')); //$ret =Capsule::connection('seed')->table('t_crm_soa_order')->count(); //use App\Lib\BaseModel; //$model = new BaseModel(); //$model->setConnection('seed'); //$model->setTable('t_crm_soa_order'); //dd($model->newQueryWithoutScopes()->select('desc ' . $model->getTable())); //dd($model->count()); exit; filter(); Capsule::schema()->create('users', function ($table) { $table->increments('id'); $table->string('username', 40); $table->string('email')->unique(); $table->timestamps();