How to Execute Queries with database/sql in Go

Execute queries by opening a connection, calling db.Query() or db.QueryRow(), and scanning the results into variables.

rows, err := db.Query("SELECT name, age FROM users WHERE id = ?", 1)
if err != nil {
    return err
}
defer rows.Close()

for rows.Next() {
    var name string
    var age int
    if err := rows.Scan(&name, &age); err != nil {
        return err
    }
    fmt.Println(name, age)
}
return rows.Err()

Executing queries with database/sql in Go lets you ask your database for information. You send a question (SQL query) to the database, wait for the answer, and then read the data into your program's variables. It's like ordering a meal: you tell the waiter what you want, they bring it to your table, and you eat it.