golang mysql 查询_GoLang使用Mysql

1、安装mysql开源库

go get github.com/go-sql-driver/mysql

2、go实现mysql的查询、插入、更新、删除

package main

import (

"database/sql"

"fmt"

"time"

_ "github.com/go-sql-driver/mysql"

)

type User struct {

id int64 `db:"id"`

groupname sql.NullString `db:"groupname"`

groupfatherid int `db:"groupfatherid"`

remark sql.NullString `db:"remark"`

}

const (

USERNAME = "root"

PASSWORD = "fgsgsgwr2356346"

NETWORK = "tcp"

SERVER = "127.0.0.1"

PORT = 3306

DATABASE = "gotest"

)

func main() {

dsn := fmt.Sprintf("%s:%s@%s(%s:%d)/%s", USERNAME, PASSWORD, NETWORK, SERVER, PORT, DATAB