LARAVEL - 未找到基表或视图：1146 表不存在（SQL： select * from ）

LARAVEL - Base table or view not found: 1146 Table doesn't exist (SQL: select * from )

提问by alexandre1985

I have a Mysql database minho.winand a table called utilizadores.

我有一个 Mysql 数据库minho.win和一个名为utilizadores.

I created a model class php artisan make:model Utilizador

我创建了一个模型类 php artisan make:model Utilizador

When I do php artisan tinkerand then do App\Utilizador::all()I get this error:

当我这样做php artisan tinker然后App\Utilizador::all()我得到这个错误：

Illuminate\Database\QueryException with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'minho.win.utilizadors' doesn't exist (SQL: select * from utilizadors)'

Illuminate\Database\QueryException 消息为“SQLSTATE[42S02]：未找到基表或视图：1146 表 'minho.win.utilizadors' 不存在（SQL：select * from utilizadors）”

Why is it looking for a table named utilizadors? How can I make it look for the right table - utilizadores?

为什么要寻找名为 的表utilizadors？我怎样才能让它寻找合适的表 - utilizadores？

回答by Mathew Tinsley

You can specify the table in your model:

您可以在模型中指定表：

class Utilizador extends Model {
    protected $table = 'utilizadores';
}

https://laravel.com/docs/5.5/eloquent#eloquent-model-conventions

https://laravel.com/docs/5.5/eloquent#eloquent-model-conventions

回答by Telemarque Ernest

so you have to protect your table in you Model something like that:in Your Model

所以你必须在你的模型中保护你的桌子：在你的模型中

protected $table = "utilizadores";

put your field's name in this array, it will seem like that:

将您的字段名称放在此数组中，它看起来像这样：

protected $filliable  = [
"id", 
""
];