My first SQL script

[S B]

Hello all,

I am trying to create a loop, which imports CSV files into a table.
I tried the following script:


CREATE PROCEDURE import_data()
BEGIN
DECLARE v1 INT DEFAULT 1;

WHILE v1 < 151 DO
LOAD DATA INFILE 'W:/a/' + v1 + '.csv'
INTO TABLE test_table
FIELDS TERMINATED BY ','
SET v1 = v1 + 1;
END WHILE
END;


Could you help me find the mistake?
I always get

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 3

Thanks in advance