Classic exanpl mysql Golang (SELECT)

GO_MYSQL_EXAMPLE.go

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

type User struct {
	id int
	login string
	password string
	authId string
}

func main(){
	db, err := sql.Open("mysql", "root:password@/tablename")
	err = db.Ping()
	if err != nil {
		fmt.Println(err.Error())
	}
	results,_ := db.Query("SELECT * FROM `users`")

	defer results.Close()
	for results.Next() {
		var user User
		err = results.Scan(&user.id, &user.login, &user.password, &user.authId)
		if err != nil {
			fmt.Print(err.Error())
		}
		log.Println(user.login)
	}

	os.Exit(2)
}