MySQL 8.0

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

CREATE TABLE test (id SERIAL PRIMARY KEY, val INT);
INSERT INTO test (val) 
WITH RECURSIVE cte AS ( SELECT 1 n UNION ALL SELECT n+1 FROM cte WHERE n<10)
SELECT n*n+1 FROM cte;
SELECT * FROM test;


id
val


1
2

2
5

3
10

4
17

5
26

6
37

7
50

8
65

9
82

10
101


CREATE PROCEDURE delete_by_chunks (tablename VARCHAR(64), chunk_size INT)
BEGIN
    SET @sql := CONCAT( 'DELETE FROM ',
                        tablename,
                        ' ORDER BY id LIMIT ',
                        chunk_size );
    PREPARE stmt FROM @sql;
    REPEAT
        EXECUTE stmt;
    UNTIL ROW_COUNT() < chunk_size END REPEAT;
    DROP PREPARE stmt;
END
CALL delete_by_chunks ('test', 3);
SELECT * FROM test;