Golang-MySQL-Opreration

A Golang-MySQL-Opreration for Go's database/sql package

Current tagged Release: Version 1.1 (November 02, 2013)

---

Requirements

• Go 1.1 or higher (use v1.0 for Go 1.0.x)
• MySQL (Version 4.1 or higher), MariaDB or Percona Server

---

Installation

Simple install the package to your $GOPATH with the go tool from shell:

$ go get github.com/shangyou/gomysql

Make sure Git is installed on your machine and in your system's PATH.

go get installs the latest tagged release

Usage

Go MySQL Driver is an implementation of Go's database/sql/driver interface. You only need to import the driver and can use the full database/sql API then.

Use mysql as driverName and a valid DSN as dataSourceName:

package main

import (
    "github.com/shangyou/gomysql"
    "fmt"
    //"time"
)

func main() {
    mysql := gomysql.Mysql{nil}
    err := mysql.Init("root:@tcp(127.0.0.1:3306)/online?charset=utf8")
    fmt.Println(err)

    //created_at := time.Now().Unix()
    //id, err := mysql.Insert("insert into user set username = ?, password = ?, created_at = ?", "shangyou", "e10adc3949ba59abbe56e057f20f883e", created_at)
    //fmt.Println(id, err)

    //count, _ := mysql.Update("update user set enable='Y'")
    //fmt.Println(count)

    //count, err := mysql.Delete("delete from user where id = 2")
    //fmt.Println(count, err)

    //rs := mysql.Fetchrows("select * from user where id = 1")

    rs := mysql.Fetchrows("select * from user")
    fmt.Println(rs)
}

DNS Examples

user@unix(/path/to/socket)/dbname

root:pw@unix(/tmp/mysql.sock)/myDatabase?loc=Local

user:password@tcp(localhost:5555)/dbname?tls=skip-verify&autocommit=true

TCP via IPv6:

user:password@tcp([de:ad:be:ef::ca:fe]:80)/dbname?timeout=90s

TCP on a remote host, e.g. Amazon RDS:

id:password@tcp(your-amazonaws-uri.com:3306)/dbname

Google Cloud SQL on App Engine:

user@cloudsql(project-id:instance-name)/dbname

TCP using default port (3306) on localhost:

user:password@tcp/dbname&charset=utf8mb4,utf8&sys_var=esc%40ped

Use the default protocol (tcp) and host (localhost:3306):

user:password@/dbname

No Database preselected:

user:password@/

more

---

License

Go-MySQL-Driver is licensed under the Mozilla Public License Version 2.0

Mozilla summarizes the license scope as follows:

MPL: The copyleft applies to any files containing MPLed code.

That means:

• You can use the unchanged source code both in private as also commercial
• You needn't publish the source code of your library as long the files licensed under the MPL 2.0 are unchanged
• You must publish the source code of any changed files licensed under the MPL 2.0 under a) the MPL 2.0 itself or b) a compatible license (e.g. GPL 3.0 or Apache License 2.0)

Please read the MPL 2.0 FAQ if you have further questions regarding the license.

You can read the full terms here: LICENSE