mysql语句 load data infile into table

LOAD DATA INFILE语句从一个文本文件中以很高的速度读入一个表中.

语法格式:

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
    [REPLACE | IGNORE]
    INTO TABLE tbl_name
    [FIELDS
        [TERMINATED BY 'string']
        [[OPTIONALLY] ENCLOSED BY 'char']
        [ESCAPED BY 'char' ]
    ]
    [LINES
        [STARTING BY 'string']
        [TERMINATED BY 'string']
    ]
    [IGNORE number LINES]
    [(col_name_or_user_var,...)]
    [SET col_name = expr,...)]

数据分隔符:

(1)fields关键字指定了文件记段的分割格式，如果用到这个关键字，MySQL剖析器希望看到至少有下面的一个选项： 
terminated by  以什么字符作为分隔符
enclosed by    字段闭合标签
escaped by     转义字符
terminated by  描述字段的分隔符，默认情况下是tab字符（\t） 
enclosed by    描述的是字段的括起字符。
escaped by     描述的转义字符。默认的是反斜杠（backslash：\ ）  
(