当执行一下代码会报错,因为当amount为0时会给amount传递NULL保存 var amount *float64 if err := db.Model(&OverweightMoney{}).Select("SUM(amount)").Scan(&amount).Error; err != nil { panic("无法执行求和操作") }执行一下代码即可 var amount float64 global.GVA_DB.Model(&OverweightMoney).Debug().Where("`type` = 0" ).Pluck("COALESCE(SUM(amount), 0) as amount", &amount).Error

当执行一下代码会报错,因为当amount为0时会给amount传递NULL保存 var amount *float64 if err := db.Model(&OverweightMoney{}).Select("SUM(amount)").Scan(&amount).Error; err != nil { panic("无法执行求和操作") }执行一下代码即可 var amount float64 global.GVA_DB.Model(&OverweightMoney).Debug().Where("`type` = 0" ).Pluck("COALESCE(SUM(amount), 0) as amount", &amount).Error

当执行一下代码会报错,因为当amount为0时会给amount传递NULL保存 var amount *float64 if err := db.Model(&OverweightMoney{}).Select("SUM(amount)").Scan(&amount).Error; err != nil { panic("无法执行求和操作") }执行一下代码即可 var amount float64 global.GVA_DB.Model(&OverweightMoney).Debug().Where("`type` = 0" ).Pluck("COALESCE(SUM(amount), 0) as amount", &amount).Error

当执行一下代码会报错,因为当amount为0时会给amount传递NULL保存 var amount *float64 if err := db.Model(&OverweightMoney{}).Select("SUM(amount)").Scan(&amount).Error; err != nil { panic("无法执行求和操作") }执行一下代码即可 var amount float64 global.GVA_DB.Model(&OverweightMoney).Debug().Where("`type` = 0" ).Pluck("COALESCE(SUM(amount), 0) as amount", &amount).Error

当执行一下代码会报错,因为当amount为0时会给amount传递NULL保存 var amount *float64 if err := db.Model(&OverweightMoney{}).Select("SUM(amount)").Scan(&amount).Error; err != nil { panic("无法执行求和操作") }执行一下代码即可 var amount float64 global.GVA_DB.Model(&OverweightMoney).Debug().Where("`type` = 0" ).Pluck("COALESCE(SUM(amount), 0) as amount", &amount).Error