go mysql打印sql语句

1.gorm 打印mysql sql语句

在gorm DB初始化添加,开启logger
db.LogMode(true)

2.或者配置中

mysql:
  path: '127.0.0.1:3306'
  config: 'charset=utf8mb4&parseTime=True&loc=Local'
  db-name: 'qmPlus'
  username: 'root'
  password: ''
  max-idle-conns: 10
  max-open-conns: 100
  log-mode: true
  log-zap: ""


gorm.Open(mysql.New(mysqlConfig), gormConfig(m.LogMode))
func gormConfig(mod bool) *gorm.Config {
	var config = &gorm.Config{DisableForeignKeyConstraintWhenMigrating: true}
		if mod {
			config.Logger = internal.Default.LogMode(logger.Info)
			break
		}
	return config
}