Re: Linear interpolation of MySQL data

[Rick James]

I would not even try to do it in SQL. Instead, I would use my application language (PHP, Perl, whatever) to do the work after doing something like
SELECT * FROM observations ORDER BY ...;
The app need only keep the two consecutive rows to do linear interpolation. (If you need something other than linear, then you may need to keep more than 2 rows.)

Part of the issue is that one gap in the data might map to zero output rows, or might map to many rows. That is really messy in SQL.