MagiClouds

Hello，I have a problem. query := sq.Update("a").Set("orders", sq.Case("id").When("20027", "3")) _, err := query.RunWith(db).Exec() the err is : sql: converting argument $1 type: unsupported type squirrel.CaseBuilder, a struct How can I...

Update(table).Set("balance", sq.Expr("? + ?", "balance", price)) is no effect

3

hi， import ( "fmt" sq "github.com/Masterminds/squirrel" "github.com/Masterminds/structable" ) func UpdateUserBalance(db sq.DBProxyBeginner, uid int, price int64) error { query := sq.Update(table).Set("balance", sq.Expr("? + ?", "balance", price)) query = query.Where(sq.Eq{"id": uid}) s,...