The example in this article describes the way to use MySQL in the Go language. Share to everyone for your reference. Specifically as follows:
This code needs to first install MySQL's go language driver.
First install MySQL's Go language driver:
Copy Code code as follows:
Go to Github.com/ziutek/mymysql/godrv
The sample code is as follows:
Copy Code code as follows:
Package Users
Import (
"Database/sql"
"FMT"
_ "Github.com/ziutek/mymysql/godrv"
)
Const (
db_name = "Mysql_database_name"
Db_user = "Mysql_user"
Db_pass = "Mysql_password"
)
Type User struct {
ID int ' JSON: ' ID '
Name string ' JSON: ' name '
Alias string ' JSON: ' Alias '
}
Func opendb () *sql. DB {
DB, err: = SQL. Open ("Mymysql", FMT. Sprintf ("%s/%s/%s", Db_name, Db_user, Db_pass))
If Err!= nil {
Panic (ERR)
}
Return db
}
Func Userbyid (id int) User {
DB: = Opendb ()
Defer db. Close ()
Row: = db. Queryrow ("SELECT" id, ' name ', ' Alias ' from ' Users ' WHERE id=? ", id)
User: = new (user)
Row. Scan (&user. Id, &user. Name, &user. Alias)
return user
}
I hope this article will help you with your go language program.
