Home > Article > Backend Development > How to write MySQL applications using Golang
Golang is an efficient, fast and flexible programming language. Its built-in concurrency support and garbage collector make it very suitable for handling high-load environments. At the same time, MySQL is an open source relational database that is widely used in web applications. In this article, we will learn how to write MySQL applications using Golang.
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. Now, you can create a new database and a new user for use in the application:
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 the MySQL database.
Step 2: Install the Golang MySQL library
In Go, there are many MySQL libraries available, but the most popular is the 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 write an application that uses Golang to connect and query the MySQL database Simple application. Please follow the steps below.
Import required libraries:
import (
"database/sql" "fmt" _ "github.com/go-sql-driver/mysql"
)
Connect to the database:
db, err := sql.Open("mysql", "myuser:mypassword@tcp(127.0.0.1:3306)/mydatabase")
if err != nil {
panic(err.Error())
}
defer db.Close()
Execute query:
rows, err := db.Query("SELECT * FROM mytable")
if err != nil {
panic(err.Error())
}
Iterate over the results and print:
for rows.Next() {
var id int var name string err := rows.Scan(&id, &name) if err != nil { panic(err.Error()) } fmt.Println(id, name)
}
"database/sql" "fmt" _ "github.com/go-sql-driver/mysql")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) }}
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!