Step 1: Install and set up the MySQL database
First, you need to install and set up the MySQL database. MySQL can be downloaded and installed from the following link:
https://www.mysql.com/downloads/
Once the installation is complete, you will also need to create a database and a user. Open the MySQL console and run the following command:
$ mysql -u root -p
This will prompt you for your password in the console. Enter your password and press Enter. You can now use the new database and new user in your application, you just need to create them
mysql> CREATE DATABASE mydatabase; mysql> CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword'; mysql> GRANT ALL ON mydatabase.* TO 'myuser'@'localhost'; mysql> FLUSH PRIVILEGES;
Next, install the Golang MySQL library for connecting to MySQL databases.
Step 2: Install the Golang MySQL library
In Go, there are many MySQL libraries available, but the most popular is go-sql-driver/mysql library.
Install the library using the following command:
$ go get -u github.com/go-sql-driver/mysql
Step 3: Write a Golang application
In this example we will create a simple application , using Golang to connect and query the MySQL database. Please follow the steps below.
Import required libraries:
import (
<code> "database/sql" "fmt" _ "github.com/go-sql-driver/mysql" </code>
)
Connect to the database:
db, err := sql.Open("mysql", "myuser:mypassword@tcp(127.0.0.1:3306)/mydatabase")
if err != nil {
<code> panic(err.Error()) </code>
defer db.Close()
if err != nil {
<code> panic(err.Error()) </code>
for rows.Next() {
var id int var name string err := rows.Scan(&id, &name) if err != nil { panic(err.Error()) } fmt.Println(id, name)
}
package main
import (
<code> "database/sql" "fmt" _ "github.com/go-sql-driver/mysql" </code>
)
func main() {
db, err := sql.Open("mysql", "myuser:mypassword@tcp(127.0.0.1:3306)/mydatabase") if err != nil { panic(err.Error()) } defer db.Close() rows, err := db.Query("SELECT * FROM mytable") if err != nil { panic(err.Error()) } for rows.Next() { var id int var name string err := rows.Scan(&id, &name) if err != nil { panic(err.Error()) } fmt.Println(id, name) }
}
$ go run main.go
## The output should contain the id and name retrieved from the MySQL database.The above is the detailed content of How to write MySQL applications using Golang. For more information, please follow other related articles on the PHP Chinese website!