音乐网站建设成本,域名升级系统自动更新,电商网站开发实例,做网站的如何说服客户文章目录安装驱动连接数据库查询表结果插入结果删除结果安装驱动
go get github.com/go-sql-driver/mysqlimport (database/sqlfmt_ github.com/go-sql-driver/mysql
)连接数据库 //用户名#xff1a;密码^tcp(地址:3306)/数据库db, err…
文章目录安装驱动连接数据库查询表结果插入结果删除结果安装驱动
go get github.com/go-sql-driver/mysqlimport (database/sqlfmt_ github.com/go-sql-driver/mysql
)
连接数据库 //用户名密码^tcp(地址:3306)/数据库db, err : sql.Open(mysql, root:123456%^tcp(39.107.87.114:3306)/book_manager?charsetutf8)if err!nil {fmt.Println(err)return} 查询表 //表结构type info struct {id int db:idname string db:nameauthor string db:author} //查询表rows,err:db.Query(SELECT * FROM book)//遍历打印for rows.Next(){var s infoerrrows.Scan(s.id,s.name,s.author,)fmt.Println(s)}//用完关闭rows.Close() 完整代码
结果
[koupython golang]$ go run go_mysql.go
{4 三国演义 罗贯中}插入 //执行MySql语句result,err:db.Exec(INSERT INTO book(id,name,author)VALUES (?,?,?),2,将进酒,李白)if err ! nil {panic(err)} fmt.Println(result)for rows.Next(){var s infoerrrows.Scan(s.id,s.name,s.author,)fmt.Println(s)} rows.Close()
} 结果
[koupython golang]$ !g
go run go_mysql.go
{4 三国演义 罗贯中}
{0xc0000a2100 0xc000016390}
[koupython golang]$ !ggo run go_mysql.go
{2 将进酒 李白}
{4 三国演义 罗贯中}panic: Error 1062: Duplicate entry 2 for key PRIMARYgoroutine 1 [running]:
main.main()/home/kou/golang/go_mysql.go:32 0x4fa
exit status 2
[koupython golang]$ !vi
vim go_mysql.go 删除 db.Exec(DELETE FROM book where id?, 2)rows,err:db.Query(SELECT * FROM book)for rows.Next(){var s infoerrrows.Scan(s.id,s.name,s.author,)fmt.Println(s)}
结果
[koupython golang]$ !g
go run go_mysql.go
{4 三国演义 罗贯中}
