func ForInsert() {
   start := time.Now()
   db, err := sql.Open("mysql", "root:123456@/coupon_scheme?charset=utf8&loc=Local")
   if err != nil {
      fmt.Println("open database error,err=", err)
         //return errors.New(fmt.Sprintf("open database error,err=", err))
   }

   stmt, err := db.Prepare(`INSERT User (userId,userName) values (?,?)`)
   //checkErr(err)
   for i := 0; i < 10000; i++ {
      name := "xiaoming" + strconv.Itoa(i)
      _, err := stmt.Exec(i, name)
      if err!=nil{
         fmt.Println(err)
      }
      //checkErr(err)
   }
   delta := time.Now().Sub(start).String()
   fmt.Println("For Insert Total Time: ", delta)
}

参考文章：

MySQL批量更新与插入 - 墨天轮