GORM 如何获得创建的自增主键值？

[有哥]

type MerchantApply struct {
	Id int `gorm:"-;primary_key;AUTO_INCREMENT"`
	Name,Address string
	Referee_id int
	CreatedAt time.Time
	State,Provider_id int
	Contact,Tel,Remark string
}

/**
创建商户申请信息
 */
func (merchants *merchants) CreateMerchantApply(mer MerchantApply)(error)  {
	err := Db.Create(&mer).Error
	return err
}

我需要将新增记录的 id 返回给前端，如何获得呢？

[zzxap]

执行sql后运行 SELECT LAST_INSERT_ID(); 就可以查出来

[岩~]

type Menu struct { Id int `gorm:"primary_key"` Title string `gorm:"type:varchar(100);not null;"` Pid int `gorm:"type:int;not null"` Important int `gorm:"type:int;not null"` PowerType int `gorm:"type:int;not null"` Type int `gorm:"type:tinyint;not null"` } func (Menu) TableName() string { return "table" } var db *gorm.DB func insert(menu *Menu) (int, error) { if menu.Title == "" { return -1, nil } var err error dd := db.Create(menu) id := menu.Id //插入数据 if err := dd.Error; err != nil { fmt.Println(err) return -1, err } return id, err }

[岩~]

menu = &Menu{ Id: 0, Title: col4, Pid: col3_id, Important: 0, PowerType: kk, Type: 0, } col4_id, err = insert(menu)