向数据表批量导入数据

使用load data local infile可以在本地或远程向数据表导入数据。

前提：开启 --local-infile

mysql -u root -p -h -127.0.0.1 --local-infile

sudo /etc/init.d/mysql restart

----------------------------------------------------------------

load data local infile "/var/tmp/newsletters_subscribers_import/newsletter_list.txt" INTO TABLE magento.newsletter_subscriber(subscriber_email) set store_id='1',subscriber_status='1';

-------------------------------------------------------------------

参考资料：

http://dev.mysql.com/doc/refman/5.5/en/load-data.html

http://database.51cto.com/art/201011/234850.htm