Uploading big data on SQL

Language Help SQL
1

Hello,

I am working on a personal project and when I populate my table on SQL with big data using the “INSERT INTO VALUES” method MySQL loses connection. Thus, failing to upload the data. I was wondering what would be the best way to upload big data on SQL?

I read that the “Load Data Infile” method is the best way to upload big data onto a SQL table, but it has to be from a text/csv file. Is there a course in Codecademy that shows you how to do this?

2

Hello @nathanielbaluyot4244 ,

I don’t know of a specific course available that teaches this but it is relatively straightforward. Just test it first with a small data set.

Here is some info MySQL :: MySQL 8.0 Reference Manual :: 13.2.7 LOAD DATA Statement