douyi2107
2016-12-21 12:36 阅读 101
已采纳

如何在GoLang中获取MySQL表的描述

com/jinzhu/gorm" and "github.com/go-sql-driver/mysql" package to interact with my database and trying to get the description of table but didn't found the function. Please help

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

1条回答 默认 最新

  • 已采纳
    doufu9947 doufu9947 2016-12-21 13:14

    With gorm you can perform a custom query and get her return in a struct, the following is an example of how to show the description of table:

    type Result struct {
        Field    string
        Type     string
        Null     string
        Key      string
        Default  string
        Extra    string
    }
    
    db.Raw("DESCRIBE TABLE_NAME").Scan(&result)
    

    View more by gorm: http://jinzhu.me/gorm/advanced.html#sql-builder

    点赞 评论 复制链接分享