示例(MySQL):
CREATE TABLE table_name (id int); LOAD DATA LOCAL INFILE '~/Documents/some_file.txt' INTO TABLE table_name FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES;
使用文件的完整路径代替波浪符号。