tmpmysql

if !IsMySQLInstalled() {
	panic("MySQL not installed")
}

server, err := NewMySQLServer("tmpmysqld_test")
if err != nil {
	panic(err)
}
defer server.Stop()

if _, err := server.DB.Exec(`
CREATE TABLE things (
  id BIGINT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(100) NOT NULL
)
`); err != nil {
	panic(err)
}

if _, err := server.DB.Exec(`
INSERT INTO things (name) VALUES ("one"), ("two")
`); err != nil {
	panic(err)
}

rows, err := server.DB.Query(`SELECT id, name FROM things ORDER BY id`)
if err != nil {
	panic(err)
}
defer rows.Close()

for rows.Next() {
	var id int64
	var name string
	if err := rows.Scan(&id, &name); err != nil {
		panic(err)
	}
	fmt.Printf("%d=%s\n", id, name)
}

Output:

1=one
2=two