CREATE DEFINER=`root`@`localhost` PROCEDURE `statisticAttendancePush`(IN data_part_count SMALLINT)
BEGIN
DECLARE done INT DEFAULT FALSE;
DECLARE statist_id INT (11);
DECLARE table_nam varchar(30);
DECLARE old_val  mediumtext;
DECLARE new_val  mediumtext;
DECLARE pag  varchar(250);
DECLARE act varchar(1);
DECLARE dat datetime;


DECLARE cur1 CURSOR FOR SELECT statistics_id, table_name, old_value, new_value, page, action, date_create from practic.log_memory LIMIT data_part_count ;

DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
OPEN cur1;
read_loop: LOOP
FETCH cur1 INTO statist_id, table_nam, old_val, new_val, pag, act, dat;
IF done THEN
LEAVE read_loop;
END IF;
INSERT INTO practic.log(statistics_id, table_name, old_value, new_value, page, action, date_create)
VALUES(statist_id, table_nam, old_val, new_val, pag, act, dat);
END LOOP;
CLOSE cur1;