Question

sql语句,向临时表插入两张表中的数据

临时表中有三列,id,va1,va2,现在想把split分割的两个字符串对应插入临时表中的va1和va2,应该怎么写呢?
例如, split('a,b,c') split('d,e,f')插入到临时表后为 id va1 va2
1 a d
2 b e
3 c f

Answer 1

String a = "a,b,c";
String b ="d,e,f";
String[] c = a.split(",");
String[] d = b.split(",");
for(int i=0;i<c.length;i++){
String sql ="insert into table (id,va1,va2) values("+i+","+c[i]+","+d[i]+")";
}

追问

需要在存储过程里面写