MySQL导入上亿数据的方式

Posted on 2020-08-16 Valine:
Symbols count in article: 115 Reading time ≈ 1 mins.

LOAD DATA INFILE ‘F:/BaiduNetdiskDownload/qaq.txt’
INTO TABLE qaq
FIELDS TERMINATED BY ‘\t’
ENCLOSED BY ‘“‘
LINES TERMINATED BY ‘\n’