关于go使用mysql测试

package main

import (

    "github.com/jmoiron/sqlx"

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

    "fmt"

)

func main() {

    Db,err:=sqlx.Open("mysql","root:123456@tcp(127.0.0.1:3306)/ghnv2_test")

    if err != nil{

        fmt.Println("connect to mysql failed,",err)

        return

    }

    defer Db.Close()

    fmt.Println("connect to mysql success")

    //执行查询操作

    rows,err := Db.Query("SELECT tag_name FROM sysuser_tag WHERE tag_id>=7")

    if err != nil{

        fmt.Println("select db failed,err:",err)

        return

    }

    // 这里获取的rows是从数据库查的满足tag_id>=5的所有行的tag_name信息，rows.Next(),用于循环获取所有

    for rows.Next(){

        var s string

        err = rows.Scan(&s)

        if err != nil{

            fmt.Println(err)

            return

        }

        fmt.Println(s)

    }

    rows.Close()

}