mysql批量新增20000数据_Mysql 批量数据插入- 插入100万条数据

方式1：java生成SQL

importjava.io.BufferedReader;importjava.io.FileInputStream;importjava.io.FileNotFoundException;importjava.io.FileReader;importjava.io.FileWriter;importjava.io.IOException;importjava.util.Random;public classSQLGenApplication {public static void main(String[] args) throwsIOException {

StringBuilder insertBuf= new StringBuilder("INSERT INTO `table1` (`id`, `uid`, `a`, `b`) VALUES");

String values= "('%s', '%s', '%s.00', '%s.00'),";

BufferedReader fis= new BufferedReader(new FileReader("fileParam.txt"));

String line= null;

Random r= newRandom();int cnt = 0;int batch = 0;int perCnt = 2500;while((line = fis.readLine()) != null) {long id = Long.parseLong(line.substring(8));int i = r.nextInt(100);while(i <= 0) {