为什么不这样呢?(在此处编写但未进行测试,因此可能存在语法错误):
sqlStr := "INSERT INTO test(n1, n2, n3) VALUES "vals := []interface{}{}for _, row := range data { sqlStr += "(?, ?, ?)," vals = append(vals, row["v1"], row["v2"], row["v3"])}//trim the last ,sqlStr = sqlStr[0:len(sqlStr)-1]//prepare the statementstmt, _ := db.Prepare(sqlStr)//format all vals at onceres, _ := stmt.Exec(vals...)


