Laravel/Lumen 中怎么执行以下 SQL 语句?
更新多行并获取被更新行的主键ID:
SET @ids = 0; SET @ids = NULL;
UPDATE `users`
SET `state` = 1
WHERE `state` = 0
AND (SELECT @ids := CONCAT_WS(',', `id`, @ids))
LIMIT 2;
SELECT @ids;
请问如何在Laravel/Lumen中使用DB类执行并获取(SELECT @ids;)的查询结果?
推荐文章: