What are some examples of using the Go SQL driver?

Can you show me some examples of using the Go SQL driver?

Sure! The Go SQL driver allows you to interact with databases using Go. For example, you can connect to a MySQL database like this:

import (
    "database/sql"
    _ "github.com/go-sql-driver/mysql"
)

func main() {
    db, err := sql.Open("mysql", "user:password@/dbname")
    if err != nil {
        log.Fatal(err)
    }
    defer db.Close()
}

What about executing queries?

You can execute queries using the db.Exec method. Here's an example:

result, err := db.Exec("INSERT INTO users(name) VALUES(?)", "John Doe")
if err != nil {
    log.Fatal(err)
}

How do I retrieve data from the database?

To retrieve data, you can use db.Query or db.QueryRow. Here's an example:

var name string
err := db.QueryRow("SELECT name FROM users WHERE id = ?", 1).Scan(&name)
if err != nil {
    log.Fatal(err)
}
fmt.Println(name)

Can you explain how to handle errors?

Certainly! Always check for errors after executing queries. You can handle them using an if statement, like this:

if err != nil {
    log.Println("Error executing query:", err)
}