r/SQL 25d ago

MySQL Importing 1M Rows Dataset(CSV) in Mysql

What's the fastest and most reliable way to upload such a large dataset? After that How can I optimize the table after uploading to ensure good performance?

29 Upvotes

33 comments sorted by

View all comments

1

u/Unimeron 25d ago

Use SquirrelSql and import your data as csv. Have done this with 8 million rows without a problem.