


Learn database functions in Go language and implement add, delete, modify and query operations on MySQL data
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
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!") }
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!") }
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!") }
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!") }
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) } }
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) }
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!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

You can use reflection to access private fields and methods in Go language: To access private fields: obtain the reflection value of the value through reflect.ValueOf(), then use FieldByName() to obtain the reflection value of the field, and call the String() method to print the value of the field . Call a private method: also obtain the reflection value of the value through reflect.ValueOf(), then use MethodByName() to obtain the reflection value of the method, and finally call the Call() method to execute the method. Practical case: Modify private field values and call private methods through reflection to achieve object control and unit test coverage.

Go language provides two dynamic function creation technologies: closure and reflection. closures allow access to variables within the closure scope, and reflection can create new functions using the FuncOf function. These technologies are useful in customizing HTTP routers, implementing highly customizable systems, and building pluggable components.

Performance tests evaluate an application's performance under different loads, while unit tests verify the correctness of a single unit of code. Performance testing focuses on measuring response time and throughput, while unit testing focuses on function output and code coverage. Performance tests simulate real-world environments with high load and concurrency, while unit tests run under low load and serial conditions. The goal of performance testing is to identify performance bottlenecks and optimize the application, while the goal of unit testing is to ensure code correctness and robustness.

Pitfalls in Go Language When Designing Distributed Systems Go is a popular language used for developing distributed systems. However, there are some pitfalls to be aware of when using Go, which can undermine the robustness, performance, and correctness of your system. This article will explore some common pitfalls and provide practical examples on how to avoid them. 1. Overuse of concurrency Go is a concurrency language that encourages developers to use goroutines to increase parallelism. However, excessive use of concurrency can lead to system instability because too many goroutines compete for resources and cause context switching overhead. Practical case: Excessive use of concurrency leads to service response delays and resource competition, which manifests as high CPU utilization and high garbage collection overhead.

Libraries and tools for machine learning in the Go language include: TensorFlow: a popular machine learning library that provides tools for building, training, and deploying models. GoLearn: A series of classification, regression and clustering algorithms. Gonum: A scientific computing library that provides matrix operations and linear algebra functions.

With its high concurrency, efficiency and cross-platform nature, Go language has become an ideal choice for mobile Internet of Things (IoT) application development. Go's concurrency model achieves a high degree of concurrency through goroutines (lightweight coroutines), which is suitable for handling a large number of IoT devices connected at the same time. Go's low resource consumption helps run applications efficiently on mobile devices with limited computing and storage. Additionally, Go’s cross-platform support enables IoT applications to be easily deployed on a variety of mobile devices. The practical case demonstrates using Go to build a BLE temperature sensor application, communicating with the sensor through BLE and processing incoming data to read and display temperature readings.

The evolution of Golang function naming convention is as follows: Early stage (Go1.0): There is no formal convention and camel naming is used. Underscore convention (Go1.5): Exported functions start with a capital letter and are prefixed with an underscore. Factory function convention (Go1.13): Functions that create new objects are represented by the "New" prefix.

In Go language, variable parameters cannot be used as function return values because the return value of the function must be of a fixed type. Variadics are of unspecified type and therefore cannot be used as return values.
