0

How can I import 1 million or more data (.csv format) in MySQL Workbench? Importing small amounts of data is easy but I am unable to store anything as large as 1 million data. The data is in a table with 15 columns and 0.4 million rows.

Chris Hayes
  • 11,471
  • 4
  • 32
  • 47
xtramous
  • 1
  • 1
  • 1
    Load the CSV directly into your table. Use [LOAD DATA INFILE](http://dev.mysql.com/doc/refman/5.1/en/load-data.html) statement. – Luiggi Mendoza Oct 16 '14 at 04:33
  • Try this answered question: http://stackoverflow.com/questions/16945348/excel-csv-file-with-more-than-1-048-576-rows-of-data –  Oct 16 '14 at 04:36

0 Answers0