Laravel 5 SQLSTATE [42S22]:找不到列 [英] Laravel 5 SQLSTATE[42S22]: Column not found

问题描述

我正在做一些连接并尝试获取数据.我的查询生成器是:

I am doing some joins and trying to get the data. My query builder is:

$datasource = DB::table('vehicles')->join('brands', 'vehicles.brand_id', '=', 'brands.id')->join('sections', 'vehicles.section_id', '=', 'sections.id')->select('vehicles.*, vehicles.id AS vid');

但是我收到此错误:

SQLSTATE [42S22]:找不到列:1054未知列 字段列表"中的"vehicles.model"(SQL:选择vehicles.model,作为 来自vehicles上的vehicles内部联接brands中的AS.brand_id = brands.id内部连接sections在vehicles.section_id = sections.id限制4偏移量0)第620行

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vehicles.model,' in 'field list' (SQL: select vehicles.model, as AS from vehicles inner join brands on vehicles.brand_id = brands.id inner join sections on vehicles.section_id = sections.id limit 4 offset 0) Line 620

我做错了什么?

推荐答案

您应该使用selectRaw()而不是select():

->selectRaw('vehicles.*, vehicles.id AS vid');

详细了解原始表达式: http://laravel.com/docs/5.0/querys#raw-expressions

Read more about raw expressions: http://laravel.com/docs/5.0/queries#raw-expressions

这篇关于Laravel 5 SQLSTATE [42S22]:找不到列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！