GoLang 和 MySQL 数据库

Question

是否有使用 github.com/go-sql-driver/mysql 包在 Go 中执行 MySQL 命令的更简单方法？

基本上这是我正在使用的当前命令:

db.Exec("INSERT INTO table1 (id, title, name, dob, address, email, notes) VALUES (?, ?, ?, ?, ?, ?, ?)", id, title, name, dob, address, email, notes)

我将如何使用此命令:

var people []people

for _, person := range people {
     db.Exec("INSERT INTO table1 (id, title, name, dob, address, email, notes) VALUES (?, ?, ?, ?, ?, ?, ?)", person.id, person.title, person.name, person.dob, person.address, person.email, person.notes)
}

Answer 1

https://godoc.org/github.com/jmoiron/sqlx#NamedExec让它稍微好一点。可能是这样的:

result, err := db.NamedExec(`INSERT INTO table1 (id, title, name, dob, address, email, notes) VALUES (:id, :title, :name, :dob, :address, :email, :notes)`,
person)

看看我的 model.go example了解更多详情。