github开源包:https://github.com/go-sql-driver/mysql
安装开源包
go get -u github.com/go-sql-driver/mysql
表数据
uid | name | age |
---|---|---|
1 | zhangsan | 21 |
2 | lisi | 22 |
3 | wangwu | 22 |
连接数据库
db, err := sql.Open("mysql", "root:password@/test?charset=utf8")
查询数据
stmt, err := db.Prepare("SELECT * from user")
if err != nil {
fmt.Printf("query prepare err:%s\n", err.Error())
return
}
defer stmt.Close()
rows, err := stmt.Query()
if err != nil {
fmt.Printf("query err:%s\n", err.Error())
}
for rows.Next() {
v