mysql

package

v0.0.0-...-6af97ad Latest Latest Go to latest Published: Dec 21, 2018 License: Apache-2.0 Imports: 4 Imported by: 2

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

This section is empty.

This section is empty.

This section is empty.

type Mysql struct {
	Config MysqlConfig
	Client *sql.DB
}

a client

func New(config MysqlConfig) *Mysql

func (db *Mysql) Create(prestring string, parm ...interface{}) (int64, error)

建表 Create table

func (db *Mysql) Drop(prestring string, parm ...interface{}) (int64, error)

删表

func (db *Mysql) Insert(prestring string, parm ...interface{}) (int64, error)

插入数据 Insert Data

func (db *Mysql) Open(maxopen int, maxidle int)

打开数据库连接 open a connecttion

func (db *Mysql) Select(prestring string, parm ...interface{}) (returnrows []map[string]interface{}, err error)

查询数据库 Query

type MysqlConfig struct {
	Username string
	Password string
	Ip       string
	Port     string
	Dbname   string
}

Mysql config

func (dbconfig MysqlConfig) CreateDb() error

create database

func (dbconfig MysqlConfig) DeleteDb() error