极速批量插入数据到MySQL

　　主要有以下三种方式:INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);
　　详见 https://dev.mysql.com/doc/refman/5.7/en/insert.htmlJDBC-API connection con.setAutoCommit(false);  PreparedStatement prepStmt = con.prepareStatement(＂UPDATE DEPT SET MGRNO=? WHERE DEPTNO=?＂); prepStmt.setString(1,mgrnum1);                  prepStmt.setString(2,deptnum1); prepStmt.addBatch();  prepStmt.setString(1,mgrnum2);                         prepStmt.setString(2,deptnum2); prepStmt.addBatch();  int [] numUpdates=prepStmt.executeBatch(); LOAD DATA INFILE XXX INTO TABLESQL = ＂＂＂ 	     LOAD DATA INFILE ＂%s＂ INTO TABLE src_hkex_trade_ticker fields terminated by ＂,＂ 	     optionally enclosed by ＂＂＂  	     escaped by ＂＂＂  	     lines terminated by ＂r ＂ (TIMESTAMP,STOCK_CODE,TICKER_KEY, PUBLIC_TRADE_TYPE, QUANTITY, PRICE) 	     	    ＂＂＂当你使用第3方案时候， 你得考虑:   1) 如何上传文件(i.e.   via ssh ),   2) 需要保存的文件路径和权限(find it via : secure_file_priv_sql = ＂SHOW VARIABLES LIKE ＂secure_file_priv＂＂ 	data_dir_sql = ＂show variables like ＂datadir＂＂)