Документация на русском:
http://www.mysql.ru/docs/man/LOAD_DATA.html
Синтаксис:
Код:
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]
]
[LINES TERMINATED BY '\n']
[IGNORE number LINES]
[(col_name,...)]
Т.е. можно указать разделитель:
LOAD DATA INFILE 'file_name.txt' INTO TABLE tbl_name
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';