Select * From servinfo Into OutFile 'G:/test.txt' FIELDS TERMINATED BY '|' LINES TERMINATED BY '\r\n';
-- FIELDS 指定字段的参数
-- FIELDS TERMINATED BY 字段之间的分割符,默认是/t,这里改成逗号
-- ESCAPED BY 对特殊字符的转义,默认是使用右斜杠/, 这里改成双引号,这样的话一个双引号就会被转义成2个双引号了
-- LINES 指定行的参数
-- STARTING BY 行最开始附加的内容,我们不需要加,所以设置为空即可
-- TERMINATED BY 指定行结束附加的内容,我们加上换行符,这也是默认的配置
load data infile 'G:/test.sql' into table test FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '"' LINES STARTING BY '' TERMINATED BY '/n';