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?