Golang database/sql.Tx.QueryRow function examples
package database/sql
QueryRow executes a query that is expected to return at most one row. QueryRow always return a non-nil value. Errors are deferred until Row's Scan method is called.
Golang database/sql.Tx.QueryRow function usage examples
Example 1:
var num int
err = txn.QueryRow("SELECT COUNT(*) FROM temp").Scan(&num)
if err != nil {
fmt.Println(err)
}
if num != 500 {
fmt.Printf("expected 500 items, not %d", num)
}
Example 2:
var name string
err = tx.QueryRow(`
UPDATE jobs
SET build_number_seq = build_number_seq + 1
WHERE name = $1
RETURNING build_number_seq
`, job).Scan(&name)
if err != nil {
return builds.Build{}, err
}
Reference :
Advertisement
Something interesting
Tutorials
+10.5k Generate Random number with math/rand in Go
+13.4k Golang : error parsing regexp: invalid or unsupported Perl syntax
+9.1k Golang : io.Reader causing panic: runtime error: invalid memory address or nil pointer dereference
+9.7k Golang : List available AWS regions
+6.2k Golang : Process non-XML/JSON formatted ASCII text file example
+11.3k Golang : Characters limiter example
+15k Golang : How do I get the local IP (non-loopback) address ?
+6.1k Golang : Measure execution time for a function
+12.6k Golang : flag provided but not defined error
+15.6k Golang : rune literal not terminated error
+18.4k Golang : Read binary file into memory