Stmt in Go

Posted by GoDoc

Public (Editable by Users)

Stmt is a prepared statement. A Stmt is safe for concurrent use by multiple goroutines.

Language Go

Dependencies

import "database/sql"

Edit

main.go

package main

import (
	"database/sql"
	"log"
)

func main() {
	// In normal use, create one Stmt when your process starts.
	stmt, err := db.PrepareContext(ctx, "SELECT username FROM users WHERE id = ?")
	if err != nil {
		log.Fatal(err)
	}
	defer stmt.Close()

	// Then reuse it each time you need to issue the query.
	id := 43
	var username string
	err = stmt.QueryRowContext(ctx, id).Scan(&username)
	switch {
	case err == sql.ErrNoRows:
		log.Fatalf("no user with id %d", id)
	case err != nil:
		log.Fatal(err)
	default:
		log.Printf("username is %s\n", username)
	}
}

Stdout
Stderr