Skip to content

Instantly share code, notes, and snippets.

@jessedearing
Last active August 18, 2016 17:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jessedearing/f1041952fe8bd2a5619bae66a02e0359 to your computer and use it in GitHub Desktop.
Save jessedearing/f1041952fe8bd2a5619bae66a02e0359 to your computer and use it in GitHub Desktop.
package main
import (
"fmt"
"log"
_ "github.com/go-sql-driver/mysql"
"github.com/jmoiron/sqlx"
)
func main() {
db, err := sqlx.Open("mysql", "user:pass@tcp(host:3306)/mysql")
if err != nil {
log.Fatal(err)
}
defer db.Close()
rows, err := db.Queryx("show slave status")
if err != nil {
log.Panic(err)
}
defer rows.Close()
for rows.Next() {
des := make(map[string]interface{})
err := rows.MapScan(des)
if err != nil {
log.Panic(err)
}
for k, v := range des {
fmt.Print(k)
if v == nil {
fmt.Printf(": %v\n", v)
} else {
fmt.Printf(": %v\n", string(v.([]uint8)))
}
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment