gorm使用scan或find时别名无效

type RelationIdCount struct {
   RelationId int32
   Total      int64
}

func (d *Dao) GetShareByItemIds(ids []uint) (count []RelationIdCount) {
   d.Db.Raw("select user_group_relation_id as relation_id,count(*) as total from item_share WHERE item_id in (?) ", ids).Group("user_group_relation_id").Scan(&count)
   return count
}

sql语句里不能用relationId做别名，只能用relation_id

 

版权声明：本文为mercurialyk原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。