go_with_mysql

// baixar o golang compilado para linux e mover para o /usr/local/
// PATH="/usr/local/go/bin:$PATH"

// local onde os pacotes/libs são baixaos e instalados
// export GOPATH=/opt/go
// go get -u github.com/go-sql-driver/mysql

// running: go run skynet_movidesk.go
package main

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

func dbConn() (db *sql.DB){
  dbDriver  := "mysql"
  dbUser    := "root"
  dbPass    := "132567"
  dbName    := "database"
  dbIp      := "127.0.0.1"
  dbPort    := "3306"
  db, err := sql.Open(dbDriver, dbUser+":"+dbPass+"@tcp("+dbIp+":"+dbPort+")/"+dbName)
  if err != nil {
    panic(err.Error())
  }

  return db
}

func main() {
  db := dbConn()
  selDB, err := db.Query("SELECT codenc FROM database.tabela LIMIT 10")
  if err != nil {
    panic(err.Error())
  }

  for selDB.Next() {
    var codenc string
    err = selDB.Scan(&codenc)
    if err != nil{
      panic(err.Error())
    }
    fmt.Println(codenc)
  }
  defer db.Close();
}
~