\uff11\uff0e\uff08\uff11\uff09\u306e\u65b9\u6cd5\u3060\u3068\u3001\u6e21\u3059\u5024\u306b’-‘\u3092\u542b\u3080\u3068\u5024\u3092\u6b63\u3057\u304f\u6e21\u305b\u306a\u3044
\n\uff08\uff11\uff09\u914d\u5217\u3092JOIN\u3057\u305f\u6587\u5b57\u5217\u3092”{” +…+ “}”\u3067\u62ec\u3063\u3066IN\u53e5\u306b\u6e21\u3059\u65b9\u6cd5
\n\uff08\uff12\uff09\u914d\u5217\u30c7\u30fc\u30bf\u306e\u6570\u3060\u3051?\u3092SQL\u306eIN\u53e5\u306b\u57cb\u3081\u8fbc\u3093\u3067\u3001\u5024\u3092\u914d\u5217\u3067\u6e21\u3059\u65b9\u6cd5<\/p>\n
\uff12\uff0e2\u7a2e\u985e\u306e\u65b9\u6cd5
\n\uff08\uff11\uff09\u914d\u5217\u3092JOIN\u3057\u305f\u6587\u5b57\u5217\u3092”{” +…+ “}”\u3067\u62ec\u3063\u3066IN\u53e5\u306b\u6e21\u3059\u65b9\u6cd5
\n“{‘”+strings.Join(user_ids , “‘,'”)+”‘}”<\/p>\n
\r\nSQL = `\r\n SELECT\r\n user_id,\r\n email_address AS username\r\n FROM\r\n user_authentication\r\n WHERE\r\n user_id NOT IN(?)\r\n`;\r\n\r\ns :=bytes.NewBufferString(\"\");\r\ns.WriteString(SQL);\r\nrows, err = db.Query(s.String(), \"{'\"+strings.Join(user_ids , \"','\")+\"'}\");\r\n<\/pre>\n\uff08\uff12\uff09\u914d\u5217\u30c7\u30fc\u30bf\u306e\u6570\u3060\u3051?\u3092SQL\u306eIN\u53e5\u306b\u57cb\u3081\u8fbc\u3093\u3067\u3001\u5024\u3092\u914d\u5217\u3067\u6e21\u3059\u65b9\u6cd5
\n\u30fbuuids\u306fstring\u306e\u914d\u5217
\n\u30fbrepeat := strings.Repeat(“?,”, len(uuids)-1) +”?” \u3067\u914d\u5217\u30c7\u30fc\u30bf\u306e\u6570\u3060\u3051?\u3092\u4f5c\u6210
\n\u30fbdb.Query\u306e\u5f15\u6570\u306ftype []interface {}\u306a\u306e\u3067\u3001range\u3068append\u3067\u3001string\u306e\u914d\u5217\u304b\u3089type\u5909\u63db\u3059\u308b<\/p>\n
\r\nrepeat := strings.Repeat(\"?,\", len(uuids)-1) +\"?\"\r\n\r\nvar args []interface {};\r\nfor _, tag := range uuids {\r\n args = append(args, tag)\r\n}\r\n\r\nSQL := `\r\n SELECT\r\n sub_id AS uuid\r\n FROM\r\n bills\r\n WHERE\r\n sub_id IN ( `+repeat+` )\r\n`;\r\n\r\ns := bytes.NewBufferString(\"\");\r\ns.WriteString(SQL);\r\n rows, err := db.Query(s.String(),args... );\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"\uff11\uff0e\uff08\uff11\uff09\u306e\u65b9\u6cd5\u3060\u3068\u3001\u6e21\u3059\u5024\u306b’-‘\u3092\u542b\u3080\u3068\u5024\u3092\u6b63\u3057\u304f\u6e21\u305b\u306a\u3044 \uff08\uff11\uff09\u914d\u5217\u3092JOIN\u3057\u305f\u6587\u5b57\u5217\u3092”{” +…+ “}”\u3067\u62ec\u3063\u3066IN\u53e5\u306b\u6e21…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/953"}],"collection":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=953"}],"version-history":[{"count":12,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/953\/revisions"}],"predecessor-version":[{"id":1157,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/953\/revisions\/1157"}],"wp:attachment":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=953"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=953"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=953"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}