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
}

発生するエラー

2013/10/17 12:57:47 Failed to execute select: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MyS
QL server version for the right syntax to use near 'select id from diary' at line 1

MySQL で直接実行した場合の結果

mysql> select id from diary;
+----+
| id |
+----+
|  1 |
|  2 |
|  3 |
|  4 |
|  5 |
|  6 |
|  7 |
|  8 |
|  9 |
| 10 |
| 11 |
| 12 |
| 13 |
+----+
13 rows in set (0.03 sec)

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