How to set up mysql in golang

Golang is a modern programming language that is particularly suitable for building high-performance, high-concurrency, and distributed applications. MySQL is a widely used open source relational database that is often used in conjunction with Golang to build reliable and efficient web applications. In this article, we will introduce in detail how to use Golang to set up and connect to MySQL.

1. Install MySQL database

Before you start using the MySQL database, you need to complete the installation first. Usually, you need to obtain the available MySQL binary package and install the corresponding version according to the operating system and hardware architecture. There is nothing complicated about this process, just follow the instructions of the installation wizard.

After the installation is complete, start the MySQL service and check whether the service is running normally. On Linux or MacOS systems, you can check whether the MySQL service is available by running the following command:

$ service mysql status

If you are using a Windows operating system, you can find the installed MySQL service in the control panel and check whether normal operation.

2. Create MySQL database and table

Before using Golang to connect to the MySQL database, you need to create a database and a table. You can do this by following the steps below:

• Connect to the MySQL command line:

On Linux or MacOS systems, you can connect to the MySQL command line through a terminal window , as follows:

$ mysql -u root -p

You need to enter the user name and password of the MySQL administrator to enter the MySQL command line.

• Create a MySQL database:

In the MySQL command line, execute the following command to create a new database:

$ CREATE DATABASE mydb;

This command will create A MySQL database named "mydb".

• Use the created database:

In the MySQL command line, you can use the following command to use the database you just created:

$ USE mydb;

This The command will switch the current operation object to the database named "mydb".

• Create a MySQL table:

In the MySQL command line, you can use the following command to create a new table:

$ CREATE TABLE mytable (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(30) NOT NULL,
    last_name VARCHAR(30) NOT NULL,
    email VARCHAR(50)
);

This command will A MySQL table named "mytable" will be created and four fields will be set for it.

3. Golang connects to MySQL

After completing the creation of the MySQL database and table, we can use Golang to connect and perform related operations. The following is the operation process for connecting to MySQL in Golang:

• Import the Golang mysql package:

In your Golang project, you need to import the mysql package first.

import (
    "database/sql"
    "fmt"
    _ "github.com/go-sql-driver/mysql"
)

• Create a MySQL connection:

When connecting to a MySQL database in Golang, you need to create a db object to represent the status of the MySQL connection. Here is how to create a MySQL connection:

func main() {
    //连接MySQL数据库
    db, err := sql.Open("mysql", "user:password@tcp(127.0.0.1:3306)/mydb")
    if err != nil {
        fmt.Println(err.Error())
        return
    }
    defer db.Close()
}

In the example, we use user and password to represent the username and password of the MySQL administrator respectively, 127.0.0.1 and 3306 represent the address and port number of the MySQL service, mydb is the name of the MySQL database we just created.

• Execute MySQL query:

After successfully connecting to the MySQL database, we can execute SQL statements to perform various operations. The following is an example of using Golang to insert data into MySQL:

func main() {
    //连接MySQL数据库
    db, err := sql.Open("mysql", "user:password@tcp(127.0.0.1:3306)/mydb")
    if err != nil {
        fmt.Println(err.Error())
        return
    }
    defer db.Close()

    //插入数据
    stmt, err := db.Prepare("INSERT INTO mytable (first_name, last_name, email) VALUES (?, ?, ?)")
    if err != nil {
        fmt.Println(err.Error())
        return
    }
    defer stmt.Close()

    res, err := stmt.Exec("John", "Doe", "john@doe.com")
    if err != nil {
        fmt.Println(err.Error())
        return
    }

    id, err := res.LastInsertId()
    if err != nil {
        fmt.Println(err.Error())
        return
    }

    fmt.Printf("Inserted a new row with ID: %d
", id)
}

The above code uses Golang's database/sql package and the MySQL driver, opens a connection, and then executes an INSERT statement to insert data into our in the table. In this process, we use the Prepare function to prepare the SQL statement and return an stmt object. We then use the Exec function to insert the data into the MySQL database. If the execution is successful, we will be able to get the ID of the row we inserted.

4. Summary

This article details how to use Golang to connect to a MySQL database, create databases and tables in MySQL, and use Golang to perform MySQL operations. When you understand this connection method, you can easily develop high-level web applications using Golang with correct MySQL operations and unbeatable performance.

The above is the detailed content of How to set up mysql in golang. For more information, please follow other related articles on the PHP Chinese website!