schema.sql

CREATE TABLE `TEST` (
  `id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO TEST (id) VALUES (1) (2) (3);

t.go

package main

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

func main() {
	db, err := sql.Open("mysql", "root@tcp(localhost:3306)/test")
	if err != nil {
		panic(err)
	}
	rows, err := db.Query("SELECT `id` FROM `TEST`")
	if err != nil {
		panic(err)
	}
	for rows.Next() {
		var s string
		err := rows.Scan(&s)
		if err != nil {
			panic(err)
		}
		fmt.Printf("%q\n", s)
	}
}