mysql的load语法

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] /
    [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,...)]

实例：load data infile "c:/users/xm/1.txt" into table user fields terminated by ":" ignore 1 lines (name,pwd)