How to Import All CSV Files in Directory in MySQL via Bash

Create a file import.sh and make it executable
Paste following code in file

mysqluser='root'
mysqlpass='password'
mysqldb='database_name'
tablename='mysql_table_name'
DIRECTORY='input_directory'

for csv in $DIRECTORY/*.csv;
do
 echo "Loading $csv"
 mysql -u $mysqluser --password=$mysqlpass -D $mysqldb -e "LOAD DATA INFILE '$csv' IGNORE INTO TABLE $tablename FIELDS TERMINATED BY '\t' ENCLOSED BY '\"' LINES TERMINATED BY '\n' IGNORE 1 LINES;"
done