Home Backend Development Golang Learn database functions in Go language and implement add, delete, modify and query operations on MySQL data

Learn database functions in Go language and implement add, delete, modify and query operations on MySQL data

Jul 30, 2023 pm 03:45 PM
go language Database functions mysql data operation

Learn the database functions in Go language and implement the addition, deletion, modification and query operations of MySQL data

Go language is an efficient, concise and highly efficient programming language, and the database is used to store and manage data important tool. In Go language, there are many database drivers, one of the most commonly used is MySQL. This article will introduce how to learn database functions in Go language, and use code examples to show how to implement addition, deletion, modification and query operations of MySQL data.

Before starting to learn, we need to ensure that the Go language and MySQL have been installed, and the MySQL driver has been imported. You can use the following command to install the MySQL driver:

go get -u github.com/go-sql-driver/mysql
Copy after login

Next, we will create a database named "db_test" and create a data table named "users" in it to demonstrate the addition. Delete, modify and check operations. You can use the following code to create databases and data tables:

package main

import (
    "database/sql"
    "fmt"

    _ "github.com/go-sql-driver/mysql"
)

func main() {
    db, err := sql.Open("mysql", "root:password@tcp(127.0.0.1:3306)/")
    if err != nil {
        panic(err.Error())
    }

    defer db.Close()

    _, err = db.Exec("CREATE DATABASE IF NOT EXISTS db_test")
    if err != nil {
        panic(err.Error())
    }

    _, err = db.Exec("USE db_test")
    if err != nil {
        panic(err.Error())
    }

    _, err = db.Exec("CREATE TABLE IF NOT EXISTS users (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(20))")
    if err != nil {
        panic(err.Error())
    }

    fmt.Println("Database and table created successfully!")
}
Copy after login

Run the above code to create a database named "db_test" and a data table named "users" in MySQL.

Next, we will implement the add, delete, modify and check operations. First, we will implement the function of inserting data. This can be achieved using the following code:

func insertUser(db *sql.DB, name string) {
    stmt, err := db.Prepare("INSERT INTO users(name) VALUES(?)")
    if err != nil {
        panic(err.Error())
    }

    _, err = stmt.Exec(name)
    if err != nil {
        panic(err.Error())
    }

    fmt.Println("User inserted successfully!")
}
Copy after login

Next, we will implement the function of deleting data. This can be achieved using the following code:

func deleteUser(db *sql.DB, id int) {
    stmt, err := db.Prepare("DELETE FROM users WHERE id = ?")
    if err != nil {
        panic(err.Error())
    }

    _, err = stmt.Exec(id)
    if err != nil {
        panic(err.Error())
    }

    fmt.Println("User deleted successfully!")
}
Copy after login

Then, we will implement the function of updating data. This can be achieved using the following code:

func updateUser(db *sql.DB, id int, name string) {
    stmt, err := db.Prepare("UPDATE users SET name = ? WHERE id = ?")
    if err != nil {
        panic(err.Error())
    }

    _, err = stmt.Exec(name, id)
    if err != nil {
        panic(err.Error())
    }

    fmt.Println("User updated successfully!")
}
Copy after login

Finally, we will implement the function of querying data. This can be achieved using the following code:

func queryUsers(db *sql.DB) {
    rows, err := db.Query("SELECT * FROM users")
    if err != nil {
        panic(err.Error())
    }

    defer rows.Close()

    var id int
    var name string

    fmt.Println("Users:")
    for rows.Next() {
        err := rows.Scan(&id, &name)
        if err != nil {
            panic(err.Error())
        }

        fmt.Printf("ID: %d, Name: %s
", id, name)
    }
}
Copy after login

Now, we can integrate the above functions into a complete example and test it as follows:

package main

import (
    "database/sql"
    "fmt"

    _ "github.com/go-sql-driver/mysql"
)

func insertUser(db *sql.DB, name string) {
    stmt, err := db.Prepare("INSERT INTO users(name) VALUES(?)")
    if err != nil {
        panic(err.Error())
    }

    _, err = stmt.Exec(name)
    if err != nil {
        panic(err.Error())
    }

    fmt.Println("User inserted successfully!")
}

func deleteUser(db *sql.DB, id int) {
    stmt, err := db.Prepare("DELETE FROM users WHERE id = ?")
    if err != nil {
        panic(err.Error())
    }

    _, err = stmt.Exec(id)
    if err != nil {
        panic(err.Error())
    }

    fmt.Println("User deleted successfully!")
}

func updateUser(db *sql.DB, id int, name string) {
    stmt, err := db.Prepare("UPDATE users SET name = ? WHERE id = ?")
    if err != nil {
        panic(err.Error())
    }

    _, err = stmt.Exec(name, id)
    if err != nil {
        panic(err.Error())
    }

    fmt.Println("User updated successfully!")
}

func queryUsers(db *sql.DB) {
    rows, err := db.Query("SELECT * FROM users")
    if err != nil {
        panic(err.Error())
    }

    defer rows.Close()

    var id int
    var name string

    fmt.Println("Users:")
    for rows.Next() {
        err := rows.Scan(&id, &name)
        if err != nil {
            panic(err.Error())
        }

        fmt.Printf("ID: %d, Name: %s
", id, name)
    }
}

func main() {
    db, err := sql.Open("mysql", "root:password@tcp(127.0.0.1:3306)/db_test")
    if err != nil {
        panic(err.Error())
    }

    defer db.Close()

    insertUser(db, "Alice")
    insertUser(db, "Bob")
    insertUser(db, "Charlie")

    queryUsers(db)

    deleteUser(db, 2)

    queryUsers(db)

    updateUser(db, 1, "Alex")

    queryUsers(db)
}
Copy after login

Run the above code to achieve Add, delete, modify and query MySQL data. By learning the database functions in the Go language, we can easily operate MySQL data and realize various functional requirements. I believe that through the code examples provided in this article, readers can have a deeper understanding and mastery of the use of Go language and MySQL database.

The above is the detailed content of Learn database functions in Go language and implement add, delete, modify and query operations on MySQL data. For more information, please follow other related articles on the PHP Chinese website!

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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

What libraries are used for floating point number operations in Go? What libraries are used for floating point number operations in Go? Apr 02, 2025 pm 02:06 PM

The library used for floating-point number operation in Go language introduces how to ensure the accuracy is...

What is the problem with Queue thread in Go's crawler Colly? What is the problem with Queue thread in Go's crawler Colly? Apr 02, 2025 pm 02:09 PM

Queue threading problem in Go crawler Colly explores the problem of using the Colly crawler library in Go language, developers often encounter problems with threads and request queues. �...

How to solve the user_id type conversion problem when using Redis Stream to implement message queues in Go language? How to solve the user_id type conversion problem when using Redis Stream to implement message queues in Go language? Apr 02, 2025 pm 04:54 PM

The problem of using RedisStream to implement message queues in Go language is using Go language and Redis...

In Go, why does printing strings with Println and string() functions have different effects? In Go, why does printing strings with Println and string() functions have different effects? Apr 02, 2025 pm 02:03 PM

The difference between string printing in Go language: The difference in the effect of using Println and string() functions is in Go...

What should I do if the custom structure labels in GoLand are not displayed? What should I do if the custom structure labels in GoLand are not displayed? Apr 02, 2025 pm 05:09 PM

What should I do if the custom structure labels in GoLand are not displayed? When using GoLand for Go language development, many developers will encounter custom structure tags...

What is the difference between `var` and `type` keyword definition structure in Go language? What is the difference between `var` and `type` keyword definition structure in Go language? Apr 02, 2025 pm 12:57 PM

Two ways to define structures in Go language: the difference between var and type keywords. When defining structures, Go language often sees two different ways of writing: First...

Which libraries in Go are developed by large companies or provided by well-known open source projects? Which libraries in Go are developed by large companies or provided by well-known open source projects? Apr 02, 2025 pm 04:12 PM

Which libraries in Go are developed by large companies or well-known open source projects? When programming in Go, developers often encounter some common needs, ...

Why is it necessary to pass pointers when using Go and viper libraries? Why is it necessary to pass pointers when using Go and viper libraries? Apr 02, 2025 pm 04:00 PM

Go pointer syntax and addressing problems in the use of viper library When programming in Go language, it is crucial to understand the syntax and usage of pointers, especially in...

See all articles