yourpath, yourDB and yourtable in ...
#!/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
Substitute your path, database and table for yourpath, yourDB and yourtable in ...
#!/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 |
|