main.go

package main

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

func main() {
	var conn *sql.DB
	var err error
	conn, err = sql.Open("mysql", "設定")
	if err != nil {
		log.Fatal("sql.Open: ", err)
	}
	_, err = conn.Exec("CREATE TABLE IF NOT EXISTS diary (id INTEGER PRIMARY KEY AUTO_INCREMENT, title TEXT NOT NULL DEFAULT '', content TEXT NOT NULL DEFAULT '', created_at TIMESTAMP NOT NULL, updated_at TIMESTAMP NOT NULL)")
	if err != nil {
		log.Fatal("Failed to create table: ", err)
	}
	_, err = conn.Exec("insert into diary (title, content) values (\"たいとる\", \"中身やで\")")
	if err != nil {
		log.Fatal("Failed to execute insert: ", err)
	}

	rows, err := conn.Query("select id from diary")
	if err != nil {
		log.Fatal("Failed to execute select: ", err)
	}

	diarys := make([]Diary, 0)
	for rows.Next() {
		var diary Diary
		rows.Scan(&diary.Id, &diary.Title, &diary.Content, &diary.CreatedAt, &diary.UpdatedAt)
		diarys = append(diarys, diary)
	}
	log.Println(diarys)
	rows.Close()

}

type Diary struct {
	Id        int
	Title     string
	Content   string
	CreatedAt string
	UpdatedAt string
}

https://gist.github.com/nise-nabe/7019037#file-main-go-L25 なんかここに見えない文字があるっぽい