Import data in MySQL from a CSV file using LOAD DATA INFILE

by

You can use the LOAD DATA INFILE command to import a CSV file into a table.

Check the link MySQL – LOAD DATA INFILE.

LOAD DATA LOCAL INFILE 'abc.csv' INTO TABLE abc
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
(col1, col2, col3, col4, col5...);

For MySQL 8.0 users:

Using the LOCAL keyword holds security risks and as of MySQL 8.0 the LOCAL capability is set to False by default. You might see the error:

ERROR 1148: The used command is not allowed with this MySQL version

You can overwrite it by following the instructions in the documentation. Beware that such an overwrite does not solve the security issue, but rather is just an acknowledgment that you are aware and willing to take the risk.

More Related Contents:

  1. How to import a CSV file into a MySQL table
  2. How do I import CSV file into a MySQL table?
  3. MySQL load NULL values from CSV data
  4. Importing a csv into mysql via command line
  5. How to skip columns in CSV file when importing into MySQL table using LOAD DATA INFILE?
  6. Import CSV to MySQL
  7. LOAD DATA LOCAL INFILE gives the error The used command is not allowed with this MySQL version
  8. How can I correct MySQL Load Error
  9. Import CSV to Update only one column in table
  10. How I can Import data from CSV to MySQL?
  11. Import CSV to Update rows in table
  12. How to import a csv file into MySQL workbench?
  13. SQL split values to multiple rows
  14. How do I import an SQL file using the command line in MySQL?
  15. What is the opposite of GROUP_CONCAT in MySQL?
  16. Importing CSV data using PHP/MySQL
  17. MySQL LOAD DATA INFILE with ON DUPLICATE KEY UPDATE
  18. MySQL: Split comma separated list into multiple rows
  19. Import CSV file directly into MySQL
  20. How to import XML file into MySQL database table using XML_LOAD(); function
  21. Mysql string split [duplicate]
  22. Dump all tables in CSV format using ‘mysqldump’
  23. Importing a CSV to MySQL with different date format
  24. mysql pivot query results with GROUP BY
  25. Import SQL file into mysql
  26. How to export data from SQL Server 2005 to MySQL [closed]
  27. Dump a mysql database to a plaintext (CSV) backup from the command line
  28. Mysql permission errors with ‘load data’
  29. How to insert selected columns from a CSV file to a MySQL database using LOAD DATA INFILE
  30. MySQL load data infile – acceleration?

Leave a Comment