Gorm入手、执行原始SQL

1、安装

//安装mysql驱动
go get -u github.com/go-sql-driver/mysql
//安装gorm库
go get -u github.com/jinzhu/gorm

2、连接mysql

package main

import (
	"fmt"
	_ "github.com/go-sql-driver/mysql"
	"github.com/jinzhu/gorm"
	"log"
)

func main() {
	db, err := gorm.Open("mysql", "root:root@/test?charset=utf8mb4&parseTime=True&loc=Local")
	defer db.Close()
	if err != nil {
		log.Fatal(err)
	}

	// 执行原生sql
	rows, _ := db.Raw("select * from news limit 10").Rows()
	for rows.Next() { //循环取出
		var id int
		var title string
		var content string
		rows.Scan(&id, &title, &content) //写入到变量
		fmt.Println(id, title, content)
	}
}

上面链接了test数据看，然后对news表做了简单查询，并打印查询到的数据。