具有update laravel子查询

Question

我用mysql编写简单的查询

 update cart set cart_price=(select sum(total_price) from cart_items where cart_id=9) where cart_id=9

我想用Laravel elequent实现同样的功能。我该怎么做呢？

谢谢。

Answer 1

这是使用laravel query builder的查询。

DB::connection("YOUR_CONNECTION_NAME")
    ->table("cart")
    ->where('cart_id', 9)
    ->update([
        "cart_price" => DB::raw('(select sum(total_price) from cart_items where cart_id=9)')
    ]);