I’m trying to populate my table with a csv file.
at first I tried the template command with a csv file of 10 rows:
| IFS=","; while read a b c; do echo “INSERT INTO csv VALUES ($a, $b, $c);”; done < test.csv;
and it worked, but when I tried to use the original file, I got the following error:
driver: bad connection
connection lost; opening new connection and resetting session parameters…
Which I think is because of 16 MB limit,
is there any other way I can import the csv file?
I reduced number of rows so that the size of the file is 12MB, but the error is still the same.
I reduced number of rows so that the size of the file is less than 10MB, and worked,
but still looking for a solution to load all rows not a limited size.