DELIMITER //
CREATE PROCEDURE MultiplicationTable(IN num INT)
BEGIN
    DECLARE i INT DEFAULT 1;
    
    CREATE TEMPORARY TABLE temp_table (n INT, result INT);

WHILE i <= 10 DO
        INSERT INTO temp_table VALUES (i, i * num);
        SET i = i + 1;
    END WHILE;
    SELECT * FROM temp_table;
    DROP TEMPORARY TABLE temp_table;
END //
DELIMITER ;

CALL MultiplicationTable(5);

+----+--------+
| n  | result |
+----+--------+
| 1  | 5      |
| 2  | 10     |
| 3  | 15     |
| 4  | 20     |
| 5  | 25     |
| 6  | 30     |
| 7  | 35     |
| 8  | 40     |
| 9  | 45     |
| 10 | 50     |
+----+--------+