速度比insert要快20倍。共享一下java程序操作。package com.mysql.csv;import java.sql.connection;import java.sql.drivermanager;import java.sql.preparedstatement;import java.sql.sqlexception;public class competition { static connection conn = null; static string driver = com.mysql.jdbc.driver; static string url = jdbc:mysql://127.0.0.1:3306/nerd_1; public static void main(string[] args) throws classnotfoundexception, sqlexception { class.forname(driver); conn = drivermanager.getconnection(url, root, 1234); string sql = load data infile 'e://baidu//cp9.csv' replace into table baidu_34000_0_competition character set utf8 fields terminated by ',' enclosed by '\' lines terminated by '\r\n' ignore 1 lines; preparedstatement pstmt = conn.preparestatement(sql); pstmt.execute(); conn.close(); } }
批量插入需要条件具体可参考文档：http://dev.mysql.com/doc/refman/5.1/zh/sql-syntax.html#load-data