DB::update(DB::raw('
UPDATE provider_stations AS ps,
(
SELECT COUNT( id ) as hot , provider_arr, provider_id
FROM trips
WHERE date_dep = \'2014-11-05\'
GROUP BY provider_arr
) as d
set ps.hot=d.hot
where ps.provider_id=d.provider_id
and ps.code=d.provider_arr
'));
Жаль только в забугровой доке нашёл.
update provider_stations as ps,
trips as tr
set tr.station_dep=ps.station_id
where ps.code=tr.provider_dep
and ps.provider_id=tr.provider_id
]]>