mysql

mysql

安装

go get -u github.com/jinzhu/gorm

基本示例

package main

import (
	"fmt"
	"github.com/jinzhu/gorm"
	_ "github.com/jinzhu/gorm/dialects/mysql"
)

//数据表
type UserInfo struct {
	Id     uint
	Name   string
	Gender string
	Hobby  string
}

func main() {
	//连接数据库
	db, err := gorm.Open("mysql", "root:1234@(localhost)/db1?charset=utf8mb4&parseTime=True&loc=Local")
	if err != nil {
		panic(err)
	}
	defer db.Close()
	//创建表,自动迁移,把结构体和数据表进行对应
	db.AutoMigrate(&UserInfo{})
	//创建数据行
	//u1 := UserInfo{Id: 1,Name: "zc",Gender: "男",Hobby: "有用"}
	//db.Create(&u1)
	var u UserInfo
	db.First(&u)

	//更新
	db.Model(&u).Update("hobby", "上色球")
	fmt.Println(u)
	//删除
	db.Delete(&u)

}