I'm using "LOAD DATA LOCAL INFILE" to import txt
files, only it only imports the first 1000 lines, what do I do?
"LOAD DATA LOCAL INFILE 'temp_arq.txt'
INTO TABLE 'temp'
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\r\n' STARTING BY ''";
I'm using "LOAD DATA LOCAL INFILE" to import txt
files, only it only imports the first 1000 lines, what do I do?
"LOAD DATA LOCAL INFILE 'temp_arq.txt'
INTO TABLE 'temp'
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\r\n' STARTING BY ''";