Re: Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'for f in 'C:\\Users\\Documents\\TEMP\*.csv' DO LOAD DATA INFILE '"$f"' INTO TABL' at line 1

[Info question]

Hi Peter ,

Does it mean

I can call below only from out side of workbech like placing script on the server and execute some cron job ?

"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 '\r\n' IGNORE 1 LINES"

MySQL Query