Go: using MySQL

  • Go
  • Gabriele Romanato

When it comes to software and web application development, interacting with a database is often an essential part of the process. MySQL is one of the most popular relational databases in the world and Go is an efficient and flexible programming language. In this article, well explore how to use MySQL in Go to manage data and database interactions effectively.

Installing dependencies

Before you begin, you need to make sure you have Go and MySQL installed on your system. To install the necessary dependencies, you can use the following command: 

go get -u github.com/go-sql-driver/mysql

MySQL database connection

To start working with MySQL in Go, you need to establish a database connection. Here is an example of how to do it: 


package main

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

func main() {
    // Stringa di connessione al database
    connectionString := "username:password@tcp(hostname:port)/database_name"

    // Aprire la connessione al database
    db, err := sql.Open("mysql", connectionString)
    if err != nil {
        panic(err)
    }
    defer db.Close()

    // Verificare la connessione al database
    err = db.Ping()
    if err != nil {
        panic(err)
    }

    fmt.Println("Connessione al database riuscita!")
}

Be sure to replace username , password , hostname , port and database_name with the correct information for your MySQL configuration.

Query execution

Once the database connection is established, you can execute SQL queries to interact with the data. Here is an example of how to run a select query: 


func main() {
    // ... Connessione al database ...

    // Query di selezione
    rows, err := db.Query("SELECT id, name FROM users")
    if err != nil {
        panic(err)
    }
    defer rows.Close()

    // Iterare attraverso i risultati
    for rows.Next() {
        var id int
        var name string
        err := rows.Scan(&id, &name)
        if err != nil {
            panic(err)
        }
        fmt.Printf("ID: %d, Name: %s\n", id, name)
    }
}

Execution of parametric queries

Parametric queries are essential for preventing SQL injection attacks and improving application security. Heres an example of how to run a parametric query: 


func main() {
    // ... Connessione al database ...

    // Query parametrica
    query := "SELECT id, name FROM users WHERE age > ?"
    rows, err := db.Query(query, 18)
    if err != nil {
        panic(err)
    }
    defer rows.Close()

    // ... Iterazione dei risultati ...
}

Running insert and update queries

To execute insert and update queries, you can use the Exec method of the *sql.DB object: 


func main() {
    // ... Connessione al database ...

    // Query di inserimento
    insertQuery := "INSERT INTO users (name, age) VALUES (?, ?)"
    _, err := db.Exec(insertQuery, "Alice", 25)
    if err != nil {
        panic(err)
    }

    // Query di aggiornamento
    updateQuery := "UPDATE users SET age = ? WHERE name = ?"
    _, err = db.Exec(updateQuery, 26, "Alice")
    if err != nil {
        panic(err)
    }
}

Conclusions

In this article, weve explored how to use MySQL in Go to interact with your database. From installing dependencies to connecting to the database and running queries, youve learned the fundamentals of integrating MySQL into your Go applications. Always remember to handle errors appropriately and use parametric queries to ensure data safety.

Using MySQL in combination with Go can lead to the development of powerful and performant applications. Continue to explore the capabilities of both technologies to enhance your development skills and build robust and scalable applications.

Back to top