sql - specific mysql update based on group by data - Stack ...

2012年12月10日 - Like this: UPDATE Meters m INNER JOIN ( SELECT meter_id, MIN(reading_time) lowesttime FROM readings GROUP BY meter_id ) r ON m.id ...

stackoverflow.com