It is the best way to upload large CSV files through the LOAD DATA command.

Syntax:

LOAD DATA LOCAL INFILE "your file name"

INTO TABLE table name

FIELDS TERMINATED by ’,’

LINES TERMINATED BY ’\n’

BY Admin ON 21 Dec 2018
View Suggestions OR Post Your Suggestion

Suggest An Answer

No suggestions avaliable!