I need assistance/direction on working with stored procedures

CREATE PROCEDURE proc_1()
BEGIN
DECLARE counter INT DEFAULT 1;
DECLARE maxRowCount INT;

SELECT COUNT(Column_1) FROM tbl_1 INTO maxRowCount;

WHILE counter < maxRowCount DO
SELECT Column_2 FROM tbl_1 WHERE id_PK = counter INTO @val;
SELECT COUNT(Column_3) FROM tbl_1 WHERE Column_2 = @val INTO @val2;
SELECT COUNT(Column_4) FROM tbl_1 WHERE Column_2 = @val INTO @val3;

UPDATE tbl_2 SET Col_1 = @val, Col_2 = @val2;

SET counter = counter + 1;
END WHILE;
END;