mysql从5升级到8之后,因为驱动变化,以前的方法部分方法再8中不能使用, LOAD DATA LOCAL INFILE做为一个好用高效的方法也有一些变化
代码:
public void test() {
StringBuilder builder = new StringBuilder();
for (int i = 0; i < 5000; i++) {
builder.append("参数11");
builder.append("\t");
builder.append("参数22");
builder.append("\t");
builder.append("参数33");
builder.append("\t");
builder.append("参数44");
builder.append("\t");
builder.append("参数55");
builder.append("\n");
}
byte[] bytes = builder.toString().getBytes();
InputStream dataStream = new ByteArrayInputStream(bytes);
String loadSql = "LOAD DATA LOCAL INFILE 'sql.csv' IGNORE INTO TABLE test (A1, A2, A3, A4, A5)" ;