{"id":792,"date":"2021-11-29T19:54:45","date_gmt":"2021-11-29T10:54:45","guid":{"rendered":"https:\/\/blog.wsd.sh\/?p=792"},"modified":"2021-12-22T07:52:56","modified_gmt":"2021-12-21T22:52:56","slug":"golang%e3%80%81mariadb%e3%81%aecolumn%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e5%9e%8b%e3%81%8cint%e3%81%a7null%e3%82%92%e8%a8%b1%e5%8f%af%e3%81%99%e3%82%8b%e5%a0%b4%e5%90%88%e3%81%aenull%e5%88%a4","status":"publish","type":"post","link":"https:\/\/blog.wsd.sh\/?p=792","title":{"rendered":"<small>Golang\u3001MariaDB:table\u306ecolumn\u306e\u30c7\u30fc\u30bf\u578b\u304cINT\u3067NULL\u3092\u8a31\u53ef\u3059\u308b\u5834\u5408\u306eNULL\u5224\u5b9a<\/small>"},"content":{"rendered":"<p>to_id\u306e\u5024\u304cNULL\u306e\u6642\u3000int(to_id.Int64)\u306e\u5024\u306f0, to_id.Valid\u306e\u5024\u306ffalse<br \/>\nto_id\u306e\u5024\u304c0\u306e\u6642\u3000   int(to_id.Int64)\u306e\u5024\u306f0, to_id.Valid\u306e\u5024\u306ftrue<\/p>\n<pre>\r\nvar to_id sql.NullInt64;\r\n\r\nsql := bytes.NewBufferString(\"\");\r\nsql.WriteString(\" SELECT to_id FROM bills WHERE id = ?\");\r\nrows, err = db.Query(sql.String(), id);\r\n_ := rows.Scan(&to_id);\r\n\r\nfmt.Println (int(to_id.Int64), to_id.Valid);\r\n\r\nif int(to_id.Int64) == 0 {\r\n   if to_id.Valid == false {\r\n      \/\/to_id\u306e\u5024\u304cNULL\u306e\u6642\r\n   }\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>to_id\u306e\u5024\u304cNULL\u306e\u6642\u3000int(to_id.Int64)\u306e\u5024\u306f0, to_id.Valid\u306e\u5024\u306ffalse to_id\u306e\u5024\u304c0\u306e\u6642\u3000 int(to_id.Int64)\u306e\u5024\u306f0, to_id.Valid\u306e\u5024\u306ftrue&#8230;<\/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\/792"}],"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=792"}],"version-history":[{"count":7,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/792\/revisions"}],"predecessor-version":[{"id":819,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/792\/revisions\/819"}],"wp:attachment":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=792"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=792"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}