duandao8607 2013-11-28 16:43
浏览 581
已采纳

如何使用Golang在SQL中执行IN查找?

What does Go want for the second param in this SQL query. I am trying to use the IN lookup in postgres.

stmt, err := db.Prepare("SELECT * FROM awesome_table WHERE id= $1 AND other_field IN $2")
rows, err := stmt.Query(10, ???)

What I really want:

SELECT * FROM awesome_table WHERE id=10 AND other_field IN (this, that);
  • 写回答

6条回答 默认 最新

  • dream543211 2013-11-28 22:36
    关注

    Query just takes varargs to replace the params in your sql so, in your example, you would just do

    rows, err := stmt.Query(10)
    

    say, this and that of your second example were dynamic, then you'd do

    stmt, err := db.Prepare("SELECT * FROM awesome_table WHERE id=$1 AND other_field IN ($2, $3)")
    rows, err := stmt.Query(10,"this","that")
    

    If you have variable args for the "IN" part, you can do (play)

    package main
    
    import "fmt"
    import "strings"
    
    func main() {
        stuff := []interface{}{"this", "that", "otherthing"}
        sql := "select * from foo where id=? and name in (?" + strings.Repeat(",?", len(stuff)-1) + ")"
        fmt.Println("SQL:", sql)
        args := []interface{}{10}
        args = append(args, stuff...)
        fakeExec(args...)
        // This also works, but I think it's harder for folks to read
        //fakeExec(append([]interface{}{10},stuff...)...)
    }
    
    func fakeExec(args ...interface{}) {
        fmt.Println("Got:", args)
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(5条)

报告相同问题?

悬赏问题

  • ¥50 hyper默认的default switch
  • ¥15 网站打不开,提示502 Bad Gateway
  • ¥20 基于MATLAB的绝热压缩空气储能系统代码咨询
  • ¥15 R语言建立随机森林模型出现的问题
  • ¥20 unity内置语言切换的按钮设置
  • ¥15 中级微观经济学,生产可能性边界问题
  • ¥15 TCP传输时不同网卡传输用时差异过大
  • ¥15 请各位看看我写的属于什么算法,或者有更正确的写法?
  • ¥15 html5 qrcode 扫描器
  • ¥15 爬取网页信息并保存需要完整代码