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
Post a Comment