介绍MySQL中利用LOAD DATA命令快速导入数据的实用技巧。 1、 MySQL支持通过LOAD DATA INFILE语句导入数据。例如，可从当前目录读取名为dump.txt的文件，并将其包含的数据批量插入到当前数据库的mytbl表中，实现高效的数据加载。 2、 在LOAD DATA语句中可明确指定列分隔符 ...

MySQL - how do I enable "LOAD LOCAL INFILE . . ." Lord Pachelbel Nov 26, 2003 Jump to latest Follow Reply ...

I've read the docs on the MySQL website and still can't get this to work. I have a huge text file I want to load and don't want to use "insert" for each line. That would be dumb.