操作mysql

安装

// 安装驱动
go get github.com/go-sql-driver/mysql
// 基于驱动做一些封装
go get github.com/jmoiron/sqlx

连接mysql

// 参数二：账号:密码@tcp(ip:端口)/数据库名
database, err := sqlx.Open("mysql", "root:123@tcp(127.0.0.1:3306)/test")

insert操作

err := Db.Exec("insert into person(username, gender, email) values(?, ?, ?)", "Sirvia", "female", "1001@qq.com")

select操作

type Person struct {
	UserId int `db:"user_id"`
	UserName string `db:"username"`
	Gender string `db:"gender"`
	Email string `db:"email"`
}


var person []Person
err := Db.Select(&person, "SELECT user_id, username, gender, email FROM person WHERE user_id=?", 1)

update操作

err := Db.Exec("UPDATE person SET username=? WHERE user_id=?", "stu001", 1)

delete操作

_, err := Db.Exec("DELETE FROM person WHERE user_id=?", 1)