yourpath
yourDB
yourtable
#!/usr/bin/env bash cd yourpath for f in *.csv do mysql -e "USE yourDB LOAD DATA LOCAL INFILE '"$f"'INTO TABLE yourtable" done
Last updated 1 Aug 2019