github.com/gogf/gf@v1.16.9/.example/database/gdb/mysql/gdb_batch_insert.go (about)

     1  package main
     2  
     3  import (
     4  	"fmt"
     5  	"github.com/gogf/gf/frame/g"
     6  )
     7  
     8  func main() {
     9  	db := g.DB()
    10  	db.SetDebug(true)
    11  	list := make(g.List, 0)
    12  	for i := 0; i < 100; i++ {
    13  		list = append(list, g.Map{
    14  			"name": fmt.Sprintf(`name_%d`, i),
    15  		})
    16  	}
    17  	r, e := db.Table("user").Data(list).Batch(2).Insert()
    18  	if e != nil {
    19  		panic(e)
    20  	}
    21  	if r != nil {
    22  		fmt.Println(r.LastInsertId())
    23  	}
    24  }