I have a problem for a long time: mysql database, in a table, has been processed once, that is, under the same agent_id, in an hour, "cut" is separated by several segments, for example, cut in milliseconds. 999 of the data, now want to splice up, that is: the same agent_id, continuous time, as a period of time, long (laststatus_tilelen sum), how to implement using the stored procedure? Or how can I use SQL statements? Here is a highly handwritten blog: blog. csdn. netdanielinbitiarticledetails430... mysqlovertimelead
I have a problem for a long time: mysql database, in a table, has been processed once, that is, under the same agent_id, in an hour, "cut" is separated by several segments, for example, cut in milliseconds. 999 of the data, now want to splice up, that is: the same agent_id, continuous time, as a period of time, long (laststatus_tilelen sum), how to implement using the stored procedure? Or how can I use SQL statements? Here there is a high handwriting: replace distribute by with the id to avoid null values. maybe I am wrong and it is not implemented,