Golang SQL: QueryRow vs Exec

QueryRow - it is designed for, at most, one row update.

If you are performing multi-command updates/queries with multiple results, use Exec . The row results from Exec need to be closed after row iteration has completed.

So for ease of use & if you know you’re only manipulating one row, go with QueryRow .