105-1 東海資管 - 大數據分析實務 - MySQL Load data from File

Lload data local infile FILE_PATH into table TABLE_NAME fields TERMINATED by ','  lines TERMINATED by '\r';

 Example:

•  load data local infile '/home/pan/pet2_dot.txt' into table pets2 fields TERMINATED by ','  lines TERMINATED by '\r';