Golang database/sql.Tx.Query function examples

package database/sql

Query executes a query that returns rows, typically a SELECT.

Golang database/sql.Tx.Query function usage examples

Example 1:

 rows, err := txn.Query("CREATE TEMP TABLE foo(f1 int)")

 if err != nil {
 t.Fatal(err)
 }

Example 2:

 var nick string
 row, err := tx.Query(`select score from plusplus where nick = ?`, strings.ToLower(nick))
 if err != nil {
 fmt.Printf("Database error: %v\n", err)
 return
 }

Reference :

http://golang.org/pkg/database/sql/#Tx.Query

Advertisement