php - 如何修复 "Syntax error or access violation: 1064"

Question

我是 Laravel 世界的新手。在 php artisan migrate -seed 命令之后，我收到错误玛丽亚数据库 10.4.6PHP 7.3

SQL代码的问题不应该是

DB::table('settings')->insert($typi_settings);
$max = DB::table('settings')->max('id');
DB::select(DB::raw("select setval('typicms_settings_id_seq', $max)"));

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''typicms_settings_id_seq', 15)' at line 1 (SQL: select setval('typicms_settings_id_seq', 15))

Answer 1

您已经通过调用 QueryBuilder 上的 select 方法来执行 select，请尝试以下操作:

DB::select(DB::raw("setval('typicms_settings_id_seq', $max)"));