How to Import Multiple csv files into a MySQL Database

by

Use a shell script like this:

#!/usr/bin/env bash
cd yourdirectory
for f in *.csv
do
        mysql -e "USE yourDatabase LOAD DATA LOCAL INFILE '"$f"'INTO TABLE yourtable"
done

More Related Contents:

  1. Import CSV to Update rows in table
  2. If two columns are 1 then make new column
  3. Import data in MySQL from a CSV file using LOAD DATA INFILE
  4. MySQL: How to reset or change the MySQL root password?
  5. MySQL Server has gone away when importing large sql file
  6. MySQL : isn’t in GROUP BY
  7. MySQL: Can’t create table (errno: 150)
  8. How to import data from text file to mysql database
  9. Why is the estimated rows count very different in phpmyadmin results?
  10. How to import XML file into MySQL database table using XML_LOAD(); function
  11. Migrate from Oracle to MySQL
  12. How to access remote server with local phpMyAdmin client?
  13. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  14. Bug? #1146 – Table ‘xxx.xxxxx’ doesn’t exist
  15. Creating functions in phpMyAdmin – Error: access denied you need the super privilege for this operation
  16. #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
  17. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  18. phpMyAdmin is throwing a #2002 cannot log in to the mysql server phpmyadmin
  19. How can I import a database with MySQL from terminal?
  20. ERROR 1148: The used command is not allowed with this MySQL version
  21. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  22. Can’t import database through phpmyadmin file size too large
  23. SQL: deleting tables with prefix
  24. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  25. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  26. How do I write an SP in phpMyAdmin (MySQL)?
  27. How to import large sql file in phpmyadmin
  28. How to get back Lost phpMyAdmin Password, XAMPP
  29. UTF8 problem with MySQL 5
  30. mySQL query to search all tables within a database for a string?

Leave a Comment