What are some examples of transactions using the Go SQL driver?

Can you show me some examples of how to use transactions with the Go SQL driver?

Sure! In Go, you can use the Begin() method to start a transaction. Here's a simple example:

package main

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

func main() {
    db, err := sql.Open("mysql", "user:password@/dbname")
    if err != nil {
        panic(err)
    }
    
    tx, err := db.Begin()
    if err != nil {
        panic(err)
    }
    
    // Your SQL operations here
    
    if err := tx.Commit(); err != nil {
        tx.Rollback()
    }
}

What happens if I encounter an error during the transaction?

If an error occurs, you should call tx.Rollback() to undo any changes made during the transaction. This ensures data integrity.

Can you give me an example of handling errors in a transaction?

Absolutely! Here's an example:

if err := tx.Exec("INSERT INTO users(name) VALUES(?)", "John"); err != nil {
    tx.Rollback()
    return err
}

How do I ensure that multiple operations are treated as a single transaction?

You can group multiple SQL operations between tx.Begin() and tx.Commit(). If any operation fails, call Rollback().