As shown in the figure below to get related DATA import to mysql, there are 1 million or so the original DATA, and then import by the following code, but there is a problem, the drawing color DATA exist multiple columns of repetitive DATA at the same time, need to go to the heavy, that what method through the LOAD DATA INFILE to import when they go to weight, thank you

The create table new_table (` serial number ` char (30), ` commodity barcodes ` varchar (255), date of ` ` varchar (255), ` time ` varchar (255), ` commodity information ` varchar (255))
The LOAD DATA INFILE 'D: \ \ 360 \ \ s - 100 (utf8). CSV' REPLACE INTO TABLE mysql. New_table
FIELDS TERMINATED BY ', 'LINES TERMINATED BY' \ n '