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

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

enter image description here

codes calling db.FirstOrCreate

enter image description here

here is the data inserted into my user table:

enter image description here

the gorm version is : 1.9.1

Change your definition to look like this

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