怎么将数据批量导入mysql中
在我们的日常工作中，经常需要将大量数据批量导入MySQL数据库中。这篇文章将会介绍如何使用MySQL自带的工具和外部工具来进行数据批量导入。
使用MySQL自带的工具可以使用以下命令：
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'filename' [REPLACE | IGNORE] INTO TABLE tablename [FIELDS [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number LINES] [(col1, col2, ...)]
