automate csv import in mysql db in linux environment -

is there way have .csv imported sql table automatically in mysql db? know how manually, there situation .csv exported nightly peoplesoft , want imported automatically sql table in linux environment. plese give me sample script that.. if there's way, can point me in direction (i'm not sql expert)!!

you can try creating stored procedure, write load csv query sp. create event call sp. hope helps.

 create event if not exists `load_csv_event`     on schedule every 23 day_hour     call my_sp_load_csv(); 

alos, can directly create event , write load query it.