Laravel:从查询生成器获取最后一个插入ID [英] Laravel: get last Insert id from query builder

问题描述

我是laravel的新手，正在尝试从此查询中获取最后插入的ID:

I am new in laravel and trying to get last inserted id from this query:

DB::select("INSERT INTO current_survey (`name`, `created_by`, `description`)  SELECT `name`, `created_by`, `description` FROM survey WHERE id=survey_id");

此查询工作正常，有人可以建议我在laravel中如何做到这一点吗?

this query working well, can any one suggest me how this is possible in laravel?

谢谢

推荐答案

尝试一次 :-

$id = DB::getPdo()->lastInsertId();

这篇关于Laravel:从查询生成器获取最后一个插入ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！