MySQL 8.0

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

CREATE PROCEDURE `2e`(IN beg_date date, IN end_date date)
BEGIN
	create temporary table if not exists results (
		m_date date,
        good_name varchar(1),
        m_cnt int,
        f_cnt int
    );
    BEGIN
		declare t_date date default beg_date;
		declare i int default 0; -- счётчик

WHILE t_date < end_date DO
			IF i < 1 THEN
				insert results (m_date, good_name, m_cnt , f_cnt)
					select last_day(t_date), g.Name, sum(od.GoodCount), sum(od.GoodCount)
					from orderdetails as od
					inner join goods as g
						on od.GoodId = g.Id 
					inner join orders as o
						on od.OrderId = o.Id
					where o.CreateDate between t_date and last_day(t_date)
					group by g.Name
					order by g.Name;
			ELSE
				insert results (m_date, good_name, m_cnt, f_cnt)
					select last_day(t_date), g.Name, sum(od.GoodCount), sum(od.GoodCount) + ( select f_cnt from results limit (i-1)*10,i*10 )
					from orderdetails as od
					inner join goods as g
						on od.GoodId = g.Id 
					inner join orders as o
						on od.OrderId = o.Id
					where o.CreateDate between t_date and last_day(t_date)
					group by g.Name
					order by g.Name;
            END IF;
			set t_date = date_add(t_date, interval 1 month),
				i = i + 1;
		END WHILE;
	END;
    select date_format(m_date, '%d.%m.%Y') as `Date`,
           good_name as `Name`,
           m_cnt as `Count for month`
    from results;
    drop table results;
END

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(i-1)*10,i*10 )
					from orderdetails as od
					inner join goods as g
						on' at line 27