MySQL 报错 SQLSTATE [HY000]: General error: 2036 怎么解决
SQLSTATE[HY000]: General error: 2036 (SQL: select * from
car_clue_discuss
wherecar_clue_discuss
.car_clue_id
in (5, 6, 7, 8) order bycreated_at
desc)
上面的语句MySQL报错.不知道怎么解决了
@Apodabird 用不着,改下配置就好了.关闭 mysql 严格模式就行了,这是因为 mysql 5.7 默认严格模式
<?php
.
.
.
'mysql' => [
'driver' => 'mysql',
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '3306'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'unix_socket' => env('DB_SOCKET', ''),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'strict' => true,
'engine' => null,
'timezone' => env('DB_TIMEZONE', '+00:00'),
],
只要把 strict
的值变为false
即可
推荐文章: