doucong1992 2017-10-30 06:15
浏览 1021
已采纳

如何在golang中获取mySQL错误类型?

I'm really confused how to get the error type from a failed query line with the mySQL import. There is no real documentation on it, so it has me real confused.

Currently i have:

result, err := db.Exec("INSERT INTO users (username,password,email) VALUES (?,?,?)", username, hashedPassword, email)
if err != nil {
    // handle different types of errors here
    return
}

I could print err but its just a string, not liking the idea of peeking at strings to know what went wrong, is there no feedback to get an error code to perform a switch on or something along those lines? How do you do it?

  • 写回答

2条回答 默认 最新

  • douzhuijing4911 2017-10-30 06:46
    关注

    Indeed, checking the content of the error string is a bad practice, the string value might vary depending on the driver verison. It’s much better and robust to compare error numbers to identify what a specific error is.

    There are the error codes for the mysql driver, the package is maintained separatly from the main driver package. The mechanism to do this varies between drivers, however, because this isn’t part of database/sql itself. With that package you can check the type of error MySQLError:

    if driverErr, ok := err.(*mysql.MySQLError); ok {
        if driverErr.Number == mysqlerr.ER_ACCESS_DENIED_ERROR {
            // Handle the permission-denied error
        }
    }
    

    There are also error variables.

    Ref

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 关于九十度混合耦合器信号分析问题
  • ¥15 Cesm如何关闭不用的模块呢
  • ¥15 vue2两层数据导出为excle
  • ¥15 有人能帮我做一下这个项目吗
  • ¥15 网络上传速率比下载速率高
  • ¥15 (标签-游戏|关键词-网页游戏)
  • ¥15 这个咋搞🥹可能需要手把手教
  • ¥15 接口和关键字的问题,多选
  • ¥15 yolov5s模型下载就卡住,没有运行结果
  • ¥20 androidstudio工具问题