Question on query. #15

rinuthomashm · 2022-05-13T09:30:57Z

rinuthomashm
May 13, 2022

Hallo team, Good day to you.
Could anyone please help generating a query like this?

update table1 set row1 = row1 + 15 where id = 25.

Hi, it looks something like this:

q := sq.
    Update(tbl).
    Set(
        tbl.ROW1.Set(sq.Fieldf("? + ?", tbl.ROW1, 15)),
    ).
    Where(tbl.ID.EqInt(25))

Hope that helps.

bokwoon95 · 2022-05-13T17:45:06Z

Hi, it looks something like this:

q := sq.
    Update(tbl).
    Set(
        tbl.ROW1.Set(sq.Fieldf("? + ?", tbl.ROW1, 15)),
    ).
    Where(tbl.ID.EqInt(25))

Hope that helps.

1 reply

Thank you very much it worked.