Graphing Time series in MySQL

We'll generate a series of sensor recordings from raw sensor readings that can come in at arbitrary times: Begin by creating a table of recordings: CREATE TABLE sensor_readings ( id int not null auto_increment, name varchar(255) not null, ...