How can I retrieve instance of last added item

mysql go go-gorm last-insert-id
sathishvj picture sathishvj · Feb 27, 2015 · Viewed 10.8k times · Source

I'm using github.com/jinzhu/gorm with a mysql backend. I want to retrieve the Id (or the full entity) of the row in the previous Create call.

As in, last-insert-id: (http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id)

How can I do this?

Answer

Jinzhu picture Jinzhu · Feb 28, 2015 
type User struct {
  Id int
  Name string
}

user := User{Name: "jinzhu"}
db.Save(&user)
// user.Id is set to last insert id

Related questions

golang gorm Access the underlying mysql query

Is there a way to get the sql query log from https://github.com/jinzhu/gorm? e.g. in dev environment, it would be useful to be able to log to the console the mysql queries that have been called. …

Read More
Go-gorm mysql "unsupported type []string, a slice of string"

I use gorm, and try to create transaction to mysql. I have a struct type Game struct { Images []string } game := Game{Images: []string{"1.png", "2.png"}} db := Database() tx := db.Begin() if err := tx.Create(&game).Error; err != nil { tx.…

Read More
Fetching NULL datetime value in MySQL using GORM

I want to fetch the last visit_details row having out_time as NULL using Gorm. NIL is itself a type where VisitDetail OutTime is mysql.NullTime. Code:- var visitDetail models.VisitDetail db.Where("out_time=? ", nil).Last(&…

Read More