使用db.Create和db.FirstOrCreate将数据保存到数据库时，“ ID”列的值为“ 0”

Question

I am using "do.FirstOrCreate" to check my data and I want the data been created if it not exist in my table, everything works well except the "ID" not generated (the value of "ID" column is 0).

here are my codes:

domain object

codes calling db.FirstOrCreate

here is the data inserted into my user table:

the gorm version is : 1.9.1

Answer 1

Change your definition to look like this

type User struct {
  gorm.Model
  ID int `gorm:"AUTO_INCREMENT"`
  ..
  ..
}