How Can I Access the Underlying MySQL Query Generated by GORM?

Accessing the Underlying MySQL Query with GORM

In order to access the underlying MySQL query generated by GORM, the following steps can be taken:

1. Import the "gorm.io/gorm" package.
2. Establish a database connection using Open(dbType, connectionDSN), where dbType represents the database type (e.g., mysql) and connectionDSN is the database connection string.
3. Enable logging by setting db.LogMode(true).

For example:

import (
    "gorm.io/gorm"
)

func main() {
    db, err := gorm.Open("mysql", "user:password@tcp(127.0.0.1:3306)/database_name")
    if err != nil {
        // Handle error
    }

    db.LogMode(true)

    // Execute queries and access the generated MySQL queries
    // ...
}

By enabling logging, all generated MySQL queries will be printed to the console, allowing for easy debugging and optimization in development environments. This can be particularly useful for analyzing complex queries or identifying any potential issues.

The above is the detailed content of How Can I Access the Underlying MySQL Query Generated by GORM?. For more information, please follow other related articles on the PHP Chinese website!