Import list of CSV files in a directory to mysql, where each filename must be a table name

import_csv_mysql.sh

#!/usr/bin/env bash

# cd /your/directory/to/csvtables

for f in *.csv
do
    mysqlimport --ignore-lines=1 \
            --fields-terminated-by=, \
            --fields-enclosed-by="\"" \
            --fields-escaped-by=\
            --lines-terminated-by="\r\n" \
            --local -u <user> \
            -p <database> \
             $f

    echo "Done: '"$f"'"
    echo "_____________________________________________________________________"

done