MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE `example_table` (
  `id` int(11) NOT NULL,
  `imei` bigint(20) NOT NULL,
  `run_date_time` datetime NOT NULL,
  `in_here` tinyint(1) NOT NULL DEFAULT '-1',
  `add_meter` int(11) NOT NULL DEFAULT '0'
);
insert into example_table values 
 (1,12,'2019-01-20 04:04:12',0,150)
,(2,12,'2019-01-20 04:04:12',1,250)
,(3,12,'2019-01-20 04:04:12',1,260)
,(4,12,'2019-01-20 04:04:12',0,270)
,(5,12,'2019-01-20 04:04:12',0,280)
,(6,12,'2019-01-20 04:04:12',1,290)
,(7,12,'2019-01-20 04:04:12',1,295)
,(8,12,'2019-01-20 04:04:12',1,300)
,(9,12,'2019-01-20 04:04:12',1,302)
,(10,12,'2019-01-20 04:04:12',1,303)
,(11,12,'2019-01-20 04:04:12',1,304)
,(12,12,'2019-01-20 04:04:12',0,305)
,(13,12,'2019-01-20 04:04:12',0,320)
,(14,12,'2019-01-20 04:04:12',1,324)
,(15,12,'2019-01-20 04:04:12',1,325)
,(16,12,'2019-01-20 04:04:12',1,330)
,(17,12,'2019-01-20 04:04:12',1,331)
,(18,12,'2019-01-20 04:04:12',1,332)
,(19,12,'2019-01-20 04:04:12',0,333)
,(20,12,'2019-01-20 04:04:12',0,336)
CREATE TABLE gps_table(ID int PRIMARY KEY AUTO_INCREMENT,
timei int, trun_date_time datetime, tadd_meter int, tin_here int null);
insert into gps_table(timei,trun_date_time,tadd_meter,tin_here) 
select imei, run_date_time, add_meter, in_here 
from example_table;
select * from  gps_table;


ID
timei
trun_date_time
tadd_meter
tin_here


1
12
2019-01-20 04:04:12
150
0

2
12
2019-01-20 04:04:12
250
1

3
12
2019-01-20 04:04:12
260
1

4
12
2019-01-20 04:04:12
270
0

5
12
2019-01-20 04:04:12
280
0

6
12
2019-01-20 04:04:12
290
1

7
12
2019-01-20 04:04:12
295
1

8
12
2019-01-20 04:04:12
300
1

9
12
2019-01-20 04:04:12
302
1

10
12
2019-01-20 04:04:12
303
1

11
12
2019-01-20 04:04:12
304
1

12
12
2019-01-20 04:04:12
305
0

13
12
2019-01-20 04:04:12
320
0

14
12
2019-01-20 04:04:12
324
1

15
12
2019-01-20 04:04:12
325
1

16
12
2019-01-20 04:04:12
330
1

17
12
2019-01-20 04:04:12
331
1

18
12
2019-01-20 04:04:12
332
1

19
12
2019-01-20 04:04:12
333
0

20
12
2019-01-20 04:04:12
336
0


CREATE TEMPORARY TABLE exam_datas(ID int PRIMARY KEY AUTO_INCREMENT,vimei 
int, vbas_run_date_time datetime, vbit_run_date_time datetime, vdifff int);
CREATE PROCEDURE ssa()
BEGIN
select tin_here from gps_table limit 1 into @onceki_durum;
select count(id) from gps_table into @kayit_sayisi;
set @i = 1;
set @min_mes = 0;
set @max_mes = 0;
set @frst_id = 0;
set @imei = 0;
set @run_date_time = '0000-00-00 00:00:00';
set @run_date_time2 = '0000-00-00 00:00:00';

   myloop: WHILE (@i <= @kayit_sayisi) DO 
  select tin_here from gps_table where id = @i into @in_here_true;
  if (@in_here_true = 1) then
    select id,trun_date_time, tadd_meter from gps_table where id = @i into @frst_id,@run_date_time2, @min_mes;    
    select id from gps_table where id > @frst_id and tin_here =0 order by id asc limit 1 INTO @id; 
    SET @id = @id-1;                                                                                 
    select id, timei, trun_date_time, tadd_meter from gps_table                                          
    where id = @id and tin_here =1 limit 1 into @i, @imei, @run_date_time, @max_mes;                    

      if(@i-@frst_id>3) then
        set @i:=@i+1;
        insert into exam_datas(vimei,vbas_run_date_time,vbit_run_date_time,vdifff) Values (@imei, @run_date_time2, @run_date_time, @max_mes-@min_mes);
        SET @asd =1;
      elseif 1=1 then
        set @i:=@i+1;
        End if;
  ELSEIF 1=1
    THEN SET @i:=@i+1;
  End if;
  IF (@i = @kayit_sayisi) 
    THEN set @tamam =1; LEAVE myloop;
  END IF;
END WHILE myloop;  
END;
call ssa();
select DISTINCT * from exam_datas;


ID
vimei
vbas_run_date_time
vbit_run_date_time
vdifff


1
12
2019-01-20 04:04:12
2019-01-20 04:04:12
14

2
12
2019-01-20 04:04:12
2019-01-20 04:04:12
8

ID	timei	trun_date_time	tadd_meter	tin_here
1	12	2019-01-20 04:04:12	150	0
2	12	2019-01-20 04:04:12	250	1
3	12	2019-01-20 04:04:12	260	1
4	12	2019-01-20 04:04:12	270	0
5	12	2019-01-20 04:04:12	280	0
6	12	2019-01-20 04:04:12	290	1
7	12	2019-01-20 04:04:12	295	1
8	12	2019-01-20 04:04:12	300	1
9	12	2019-01-20 04:04:12	302	1
10	12	2019-01-20 04:04:12	303	1
11	12	2019-01-20 04:04:12	304	1
12	12	2019-01-20 04:04:12	305	0
13	12	2019-01-20 04:04:12	320	0
14	12	2019-01-20 04:04:12	324	1
15	12	2019-01-20 04:04:12	325	1
16	12	2019-01-20 04:04:12	330	1
17	12	2019-01-20 04:04:12	331	1
18	12	2019-01-20 04:04:12	332	1
19	12	2019-01-20 04:04:12	333	0
20	12	2019-01-20 04:04:12	336	0