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. 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.

1. Import required libraries:

   import (

   <code> "database/sql"
    "fmt"
    _ "github.com/go-sql-driver/mysql"
   </code>

   
   

   )

2. 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()
   

3. Execute query:
   rows, err := db.Query("SELECT * FROM mytable")

   if err != nil {
   

   <code> panic(err.Error())
   </code>

   
   

   }

##Iterate over the results and print:

4. 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 complete code is as follows:

5. 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)
    }
   

   
   

   
   }

Save the code and run the application:

6. $ 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!