Windows Task schedule MySQL query because LOAD DATA is not allowed in stored procedure -


i want execute command reads csv file , store mysql db every day.

when run command works fine "load data local infile 'c:/users/admin/desktop/test.csv' table cdr.test fields terminated ',' enclosed '"' lines terminated '\n';"

then tried create mysql scheduler event "create event newevent on schedule every 1 day load data local infile '/users/admin/desktop/test.csv' table cdr.test fields terminated ',' enclosed '"' lines terminated '\n'; ;". says load data not allowed in stored procedure.

there way use windows task scheduler (bat file) run mysql query not successful in doing it!!!!

please help.


Comments