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

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

瀏覽:871
日期:2024-07-21
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 ......看更多