Home > Database > Mysql Tutorial > body text

How to write MySQL applications using Golang

WBOY
Release: 2023-05-28 23:37:16
forward
1331 people have browsed it

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/
Copy after login

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
Copy after login

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;
Copy after login

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
Copy after login

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>
    Copy after login
    Copy after login


    )

  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>
    Copy after login
    Copy after login


    ##}

    defer db.Close()

  3. Execute query:

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

    if err != nil {

    <code> panic(err.Error())
    </code>
    Copy after login
    Copy after login


    }

  4. ##Iterate over the results and print:
  5. for rows.Next() {

     var id int
     var name string
     err := rows.Scan(&id, &name)
     if err != nil {
         panic(err.Error())
     }
     fmt.Println(id, name)
    
    Copy after login


    }

  6. The complete code is as follows:
  7. package main

    import (

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


    )

    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)
     }
    
    Copy after login


    }

    Save the code and run the application:
  8. $ go run main.go

    ## The output should contain the id and name retrieved from the MySQL database.
  9. 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!

Related labels:
source:yisu.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template