"Experiment summary two" how to import data in batches from text

Preface: My MySQL installed when not configured to import data, so rushed import will error, I was for that mistake for a long time, now and friends to share my experiment with the pit;

1. MySQL--enable-local-infile-u root-p (this sentence must be written, if the online method you have tried to say and version is not compatible, be sure to try this sentence).
   

2. LOAD DATA local INFILE ' full path ' into table;

3. It's done, notice the text in the tab between the tabs (a good tab, ignoring the alignment problem, and the structure of the table corresponding Oh, there is a point, the table header does not add, directly in the text to add the content is good ~)

"Experiment summary two" how to import data in batches from text