鼠来宝小糖豆的专栏

把txt文件导入到mysql数据库中，选用的是mysql中的LOAD DATA 语法。LOAD DATA LOCAL INFILE 'D:\\test.txt' INTO TABLE testFIELDS TERMINATED BY ','ENCLOSED BY '\"'LINES TERMINATED BY '\n'IGNORE 1 ROWS其中TERMINATED BY 以什么字符作为分隔符ENCLOSED BY 字段闭合标签LINES关键字指定了每条记录的分隔符IGNORE 1..