使用数据库(DB) / 连接到数据库

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

import ( 
    "database/sql"
    "fmt"
    _ "github.com/go-sql-driver/mysql"
)

// Connect to the database
conn, err := sql.Open("mysql",
                      "UserName:Password@tcp(HostName:PortNum)/DatabaseName")
defer conn.Close()
if err != nil {
    fmt.Println(err)
    return
}

// SQL query execution
statement, _ := conn.Prepare(`
    SELECT Name
    FROM country`)

// Get the data
result := statement.QueryRow()
var name string
result.Scan(&name)
fmt.Println(name)