且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何获取Laravel delete / update / insert语句的原始SQL?

更新时间:2023-02-05 15:29:47

首先得到一个

$builder = DB::table((new User)->getTable());

然后获取语法,并使用where子句从构建器编译delete语句。

Then get the grammar and compile the delete statement from the builder with a where clause.

$sql = $builder->getGrammar()->compileDelete($builder->where('id', 1));




"delete from `users` where `id` = ?"


现在,您可以***地交换数据库驱动程序,并仍然获得适当的平台语法。

Now you can freely swap out database drivers and still get the appropriate platform syntax.