System administrators sometime automate CSV file in to MYSQL DB with requested structure.
Login into mysql as root user, And execute the Follwing query with correct your path & tour fileds.
load data local infile ‘/tmp/file.csv’ into table mytable fields terminated by ‘, ‘
lines terminated by ‘\n’
The query load the data from file to mysql talble called mytable.
I assume csv file contain , seperated. For Eg
# cat /tmp/file.csv
Once everything done use cron to automate. to write simple script for automate this.