Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

sql

package

Go to main page

Versions in this module

v1

v1.0.3

Feb 4, 2020

v1.0.2

Dec 16, 2019

v1.0.1

Jul 14, 2019

v1.0.0

Jul 13, 2019

Changes in this version

+ const DefaultDriver

+ var ErrConnDone = errors.New("database/sql: connection is already closed")

+ var ErrNoRows = errors.New("sql: no rows in result set")

+ var ErrRemoveArgument = errors.New("driver: remove argument from query")

+ var ErrTxDone = errors.New("sql: Transaction has already been committed or rolled back")

+ func Drivers() []string

+ func Register(name string, driver driver.Driver)

+ type ColumnType struct

+ func (ci *ColumnType) DatabaseTypeName() string

+ func (ci *ColumnType) DecimalSize() (precision, scale int64, ok bool)

+ func (ci *ColumnType) Length() (length int64, ok bool)

+ func (ci *ColumnType) Name() string

+ func (ci *ColumnType) Nullable() (nullable, ok bool)

+ func (ci *ColumnType) ScanType() reflect.Type

+ type Conn struct

+ func (c *Conn) BeginTx(ctx context.Context, opts *TxOptions) (*Tx, error)

+ func (c *Conn) Close() error

+ func (c *Conn) ExecContext(ctx context.Context, query string, args ...interface{}) (Result, error)

+ func (c *Conn) PingContext(ctx context.Context) error

+ func (c *Conn) PrepareContext(ctx context.Context, query string) (*Stmt, error)

+ func (c *Conn) QueryContext(ctx context.Context, query string, args ...interface{}) (*Rows, error)

+ func (c *Conn) QueryRowContext(ctx context.Context, query string, args ...interface{}) *Row

+ type DB struct

+ func Open(driverName, dataSourceName string) (*DB, error)

+ func (db *DB) Begin() (*Tx, error)

+ func (db *DB) BeginTx(ctx context.Context, opts *TxOptions) (*Tx, error)

+ func (db *DB) Close() error

+ func (db *DB) Conn(ctx context.Context) (*Conn, error)

+ func (db *DB) Driver() driver.Driver

+ func (db *DB) Exec(query string, args ...interface{}) (Result, error)

+ func (db *DB) ExecContext(ctx context.Context, query string, args ...interface{}) (Result, error)

+ func (db *DB) Ping() error

+ func (db *DB) PingContext(ctx context.Context) error

+ func (db *DB) Prepare(query string) (*Stmt, error)

+ func (db *DB) PrepareContext(ctx context.Context, query string) (*Stmt, error)

+ func (db *DB) Query(query string, args ...interface{}) (*Rows, error)

+ func (db *DB) QueryContext(ctx context.Context, query string, args ...interface{}) (*Rows, error)

+ func (db *DB) QueryRow(query string, args ...interface{}) *Row

+ func (db *DB) QueryRowContext(ctx context.Context, query string, args ...interface{}) *Row

+ func (db *DB) SetConnIdleTimeout(d time.Duration)

+ func (db *DB) SetConnMaxLifetime(d time.Duration)

+ func (db *DB) SetConnWaitTimeout(d time.Duration)

+ func (db *DB) SetMaxIdleConnCount(n int)

+ func (db *DB) SetMaxOpenConnCount(n int)

+ func (db *DB) Stats() DBStats

+ type DBStats struct

+ OpenConnections int

+ type IsolationLevel int

+ const LevelDefault

+ const LevelLinearizable

+ const LevelReadCommitted

+ const LevelReadUncommitted

+ const LevelRepeatableRead

+ const LevelSerializable

+ const LevelSnapshot

+ const LevelWriteCommitted

+ type NamedArg struct

+ Name string

+ Value interface{}

+ func Named(name string, value interface{}) NamedArg

+ type NamedValueChecker interface

+ CheckNamedValue func(*driver.NamedValue) error

+ type NullBool struct

+ Bool bool

+ Valid bool

+ func (n *NullBool) Scan(value interface{}) error

+ func (n NullBool) Value() (driver.Value, error)

+ type NullFloat64 struct

+ Float64 float64

+ Valid bool

+ func (n *NullFloat64) Scan(value interface{}) error

+ func (n NullFloat64) Value() (driver.Value, error)

+ type NullInt64 struct

+ Int64 int64

+ Valid bool

+ func (n *NullInt64) Scan(value interface{}) error

+ func (n NullInt64) Value() (driver.Value, error)

+ type NullString struct

+ String string

+ Valid bool

+ func (ns *NullString) Scan(value interface{}) error

+ func (ns NullString) Value() (driver.Value, error)

+ type Out struct

+ Dest interface{}

+ In bool

+ type RawBytes []byte

+ type Result interface

+ LastInsertId func() (int64, error)

+ RowsAffected func() (int64, error)

+ type Row struct

+ func (r *Row) Scan(dest ...interface{}) error

+ type Rows struct

+ func (rs *Rows) Close() error

+ func (rs *Rows) ColumnTypes() ([]*ColumnType, error)

+ func (rs *Rows) Columns() ([]string, error)

+ func (rs *Rows) Err() error

+ func (rs *Rows) Next() bool

+ func (rs *Rows) NextResultSet() bool

+ func (rs *Rows) Scan(dest ...interface{}) error

+ type Scanner interface

+ Scan func(src interface{}) error

+ type Stmt struct

+ func (s *Stmt) Close() error

+ func (s *Stmt) Exec(args ...interface{}) (Result, error)

+ func (s *Stmt) ExecContext(ctx context.Context, args ...interface{}) (Result, error)

+ func (s *Stmt) Query(args ...interface{}) (*Rows, error)

+ func (s *Stmt) QueryContext(ctx context.Context, args ...interface{}) (*Rows, error)

+ func (s *Stmt) QueryRow(args ...interface{}) *Row

+ func (s *Stmt) QueryRowContext(ctx context.Context, args ...interface{}) *Row

+ type Tx struct

+ func (tx *Tx) Commit() error

+ func (tx *Tx) Exec(query string, args ...interface{}) (Result, error)

+ func (tx *Tx) ExecContext(ctx context.Context, query string, args ...interface{}) (Result, error)

+ func (tx *Tx) Prepare(query string) (*Stmt, error)

+ func (tx *Tx) PrepareContext(ctx context.Context, query string) (*Stmt, error)

+ func (tx *Tx) Query(query string, args ...interface{}) (*Rows, error)

+ func (tx *Tx) QueryContext(ctx context.Context, query string, args ...interface{}) (*Rows, error)

+ func (tx *Tx) QueryRow(query string, args ...interface{}) *Row

+ func (tx *Tx) QueryRowContext(ctx context.Context, query string, args ...interface{}) *Row

+ func (tx *Tx) Rollback() error

+ func (tx *Tx) Stmt(stmt *Stmt) *Stmt

+ func (tx *Tx) StmtContext(ctx context.Context, stmt *Stmt) *Stmt

+ type TxOptions struct

+ Isolation IsolationLevel

+ ReadOnly bool