Running prepared statements within a transaction

A statement can be prepared by calling the *sql.Tx.Prepare or *sql.Tx.PrepareContext method of the transaction struct. The prepared statement returned by these two will be associated with that transaction only. That is, you cannot prepare a statement using one transaction and use that statement for another transaction.

How to do it...

There are two ways you can use prepared statements in a transaction.

The first is using a statement prepared by *DB:

1. Prepare the statement using DB.Prepare or DB.PrepareContext.
2. Get a transaction-specific copy of the transaction:

   txStmt := tx.Stmt(stmt)

3. Run the operations using the new statement.
4. The second is using a statement prepared by *Tx:
5. Prepare the statement using Tx.Prepare or Tx.PrepareContext.
6. Run the operations using this statement.