@echo off
set MYSQLUSER=root
set MYSQLPASS=whateverpassword
set CSVFOLDER="C:UsersDocuments"
cd %CSVFOLDER%
for %f in (.*.CSV) DO mysql -u%MYSQLUSER% -p%MYSQLPASS% -AN -e"LOAD DATA INFILE '"%CSVFOLDER%\%f"' INTO TABLE TEMP FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'rn' IGNORE 1 LINES"