Golang之Mysql操作

標籤：操作   帳號   where   eve   增加   36-6   int   ret   failed   

話說當年武大郎對著電腦一頓劈裡啪啦，，，對mysql增刪改查增加insert

package mainimport (    "fmt"    "github.com/jmoiron/sqlx"    _ "github.com/go-sql-driver/mysql" //初始化一個mysql驅動，必須)type Person struct {    UserId   int    `db:"user_id"`    Username string `db:"username"`    Sex      string `db:"sex"`    Email    string `db:"email"`}type Place struct {    Country string `db:"country"`    City    string `db:"city"`    TelCode int    `db:"telcode"`}var Db *sqlx.DBfunc init() {    //"mysql"指定資料庫類型，  /test指定資料庫  root:123 冒號隔開密碼 root帳號 123密碼    database, err := sqlx.Open("mysql", "[email protected](127.0.0.1:3306)/test")    if err != nil {        fmt.Println("open mysql failed,", err)        return    }    Db = database}func main() {    //插入資料入表    r, err := Db.Exec("insert into person(username,sex,email)values(?,?,?)", "chaoge", "man", "[email protected]")    if err != nil {        fmt.Println("exec failed,", err)        return    }    id, err := r.LastInsertId()    if err != nil {        fmt.Println("exec failed,", err)        return    }    fmt.Println("insert succ:", id)}

insert查詢select

package mainimport (    "fmt"    _ "github.com/go-sql-driver/mysql"    "github.com/jmoiron/sqlx")type Person struct {    UserId   int    `db:"user_id"‘`    Username string `db:"username"`    Sex      string `db:"sex"`    Email    string `db:"email"`}type Place struct {    Country string `db:"country"`    City    string `db:"city"`    TelCode int    `db:"telcode"`}var Db *sqlx.DBfunc init() {    //初始化連結資料庫    database, err := sqlx.Open("mysql", "root:@tcp(127.0.0.1:3306)/test")    if err != nil {        fmt.Println("open mysql failed", err)        return    }    Db = database}func main() {    var person []Person    err := Db.Select(&person, "select user_id,username,sex,email from person where user_id=?", 1)    if err != nil {        fmt.Println("exec failed,", err)        return    }    fmt.Println("select succ:", person)}

select改update

package mainimport (    "fmt"    _ "github.com/go-sql-driver/mysql"    "github.com/jmoiron/sqlx")type Person struct {    UserId   int    `db:"user_id"`    Username string `db:"username"`    Sex      string `db:"sex"`    Email    string `db:"email"`}type Place struct {    Country string `db:"country"`    City    string `db:"city"`    TelCode int    `db:"telcode"`}var Db *sqlx.DBfunc init() {    database, err := sqlx.Open("mysql", "[email protected](127.0.0.1:3306)/test")    if err != nil {        fmt.Println("open mysql failed,", err)        return    }    Db = database}func main() {    _, err := Db.Exec("update person set username=? where user_id=?", "chaoge666", 1)    if err != nil {        fmt.Println("exec failed,", err)    }}

update刪delete

package mainimport (    "fmt"    _ "github.com/go-sql-driver/mysql"    "github.com/jmoiron/sqlx")type Person struct {    UserId   int    `db:"user_id"`    Username string `db:"username"`    Sex      string `db:"sex"`    Email    string `db:"email"`}type Place struct {    Country string `db:"country"`    City    string `db:"city"`    TelCode int    `db:"telcode"`}var Db *sqlx.DBfunc init() {    //初始化連結資料庫    database, err := sqlx.Open("mysql", "[email protected](127.0.0.1:3306)/test")    if err != nil {        fmt.Println("open mysql failed,", err)        return    }    Db = database}func main() {    _, err := Db.Exec("delete FROM person where user_id=?", 1)    if err != nil {        fmt.Println("exec failed,", err)        return    }    fmt.Println("delete succ")}

delete

 

Golang之Mysql操作