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

package main

import (
    "database/sql"
    "fmt"
    "log"

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

func main() {
    // Connect to the database
    db, err := sql.Open("mysql", "username:password@tcp(127.0.0.1:3306)/dbname?charset=utf8mb4&parseTime=True&loc=Local")
    if err != nil {
        log.Fatal(err)
    }
    defer db.Close()

    // Test connection
    err = db.Ping()
    if err != nil {
        log.Fatal(err)
    }
    fmt.Println("Connected to MySQL database!")
}

db.SetMaxOpenConns(25)    // Maximum Open Connections
db.SetMaxIdleConns(5)     // Maximum Idle Connections
db.SetConnMaxLifetime(5 * time.Minute) // Maximum connection lifetime


  query := `
      CREATE TABLE IF NOT EXISTS users (
          id INT AUTO_INCREMENT PRIMARY KEY,
          username VARCHAR(50) NOT NULL,
          email VARCHAR(100) NOT NULL,
          created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
      )`
  _, err := db.Exec(query)
  if err != nil {
      log.Fatal(err)
  }


  query := "INSERT INTO users (username, email) VALUES (?, ?)"


  result, err := db.Exec(query, "john_doe", "john@example.com")
  if err != nil {
      log.Fatal(err)
  }


  id, err := result.LastInsertId()
  if err != nil {
      log.Fatal(err)
  }

  query := "UPDATE users SET email = ? WHERE username = ?"


  result, err := db.Exec(query, "new_email@example.com", "john_doe")
  if err != nil {
      log.Fatal(err)
  }


  rowsAffected, err := result.RowsAffected()
  if err != nil {
      log.Fatal(err)
  }

  query := "DELETE FROM users WHERE username = ?"


  result, err := db.Exec(query, "john_doe")
  if err != nil {
      log.Fatal(err)
  }


  rowsAffected, err := result.RowsAffected()
  if err != nil {
      log.Fatal(err)
  }

go get -u gorm.io/gorm
go get -u gorm.io/driver/mysql

dsn := "user:password@tcp(host:port)/dbname?charset=utf8mb4&parseTime=True&loc=Local"

package main

import (
    "gorm.io/driver/mysql"
    "gorm.io/gorm"
)

func main() {
    dsn := "root:yourpassword@tcp(127.0.0.1:3306)/yourdb?charset=utf8mb4&parseTime=True&loc=Local"
    db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
    if err != nil {
        panic("failed to connect database")
    }

    // Use the db object to perform database operations...
}

type User struct {
    gorm.Model
    Name  string
    Email string `gorm:"unique"`
    Age   int
}

// Auto Migration Mode
err = db.AutoMigrate(&User{})
if err != nil {
    panic("failed to migrate database")
}

// Create a single user
user := User{Name: "Zhang San", Email: "zhangsan@example.com", Age: 25}
result := db.Create(&user)
if result.Error != nil {
    panic(result.Error)
}

// Batch create
users := []User{
    {Name: "Li Si", Email: "lisi@example.com", Age: 30},
    {Name: "Wang Wu", Email: "wangwu@example.com", Age: 28},
}
db.Create(&users)

// Query a single user
var user User
db.First(&user, 1) // Query by primary key
db.First(&user, "name = ?", "Zhang San") // Query by condition

// Query multiple users
var users []User
db.Find(&users) // Query all users
db.Where("age > ?", 25).Find(&users) // Conditional query

// Update a single field
db.Model(&user).Update("name", "Zhang San's new name")

// Update multiple fields
db.Model(&user).Updates(User{Name: "Zhang San's new name", Age: 26})

// Conditional update
db.Model(&User{}).Where("age < ?", 30).Update("age", gorm.Expr("age + ?", 1))

// Delete a single record
db.Delete(&user)

// Delete conditionally
db.Where("name = ?", "Li Si").Delete(&User{})

// Soft delete (if the model includes gorm.Model)
db.Delete(&user) // only sets the deleted_at field