Home > Blockchain >  How to upload more than 1000 entries using LOAD DATA INFILE?
How to upload more than 1000 entries using LOAD DATA INFILE?

Time:02-14

I'm trying to import an csv file to my database table, the origin of this file was a previous database with the same structure. My issue is that it imports only 1000 rows instead of the whole 62k file. The script i'm using is:

LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/covid19.csv'
INTO TABLE covid19.covid19
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"' 
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(id,date,iso2,iso3,country,continent,cases,deaths,population);

CodePudding user response:

Some clients have a option, where they reduce the number of returned Rows with a LIMIT 1000.

You should check, how many rows you actually have with

SELECT COUNT(*) FROM covid19.covid19;

You should see the actual number of inserted rows, as the command didn't show any warnungs or errors.

  • Related