{"id":1169,"date":"2022-01-21T12:55:32","date_gmt":"2022-01-21T03:55:32","guid":{"rendered":"https:\/\/blog.wsd.sh\/?p=1169"},"modified":"2022-01-21T12:57:23","modified_gmt":"2022-01-21T03:57:23","slug":"golang-mariadb%e3%81%aecolumn%e3%81%ab%e3%80%81%e6%9d%a1%e4%bb%b6%e3%80%81%e5%80%a4%e3%81%8cnull%e3%81%ae%e6%99%82%e3%81%abnull%e3%82%92%e6%9b%b8%e3%81%8d%e8%be%bc%e3%82%80","status":"publish","type":"post","link":"https:\/\/blog.wsd.sh\/?p=1169","title":{"rendered":"<small>Golang Mariadb\u306ecolumn\u306b\u3001\u6761\u4ef6\u3001\u5024\u304c\u201dnull\u201d\u306e\u6642\u306bNULL\u3092\u66f8\u304d\u8fbc\u3080<\/small>"},"content":{"rendered":"<p>\uff11\uff0eNULL\u3092\u66f8\u304d\u8fbc\u3080\u306b\u306f\u3001sql.NullString {} \u3092\u4f7f\u3046<br \/>\n\u30fb\u5909\u6570\u306etype\u306finterface {]\u3092\u4f7f\u3046<\/p>\n<p>\uff12\uff0e\u6761\u4ef6\u3068\u3057\u3066\u3001\u5024\u304c&#8221;null&#8221;\u306e\u6642\u306bNULL\u3092\u66f8\u304d\u8fbc\u3080<\/p>\n<pre>\r\n_r.Username = r.PostFormValue(\"username\");\r\n\r\nif _r.Username == \"null\" {\r\n   _r.Username = sql.NullString{};\r\n}\r\n<\/pre>\n<p>\uff13\uff0ecode<\/p>\n<pre>\r\n\r\ntype Page_s struct {\r\n   Serial          string      `json:\"serial\"`\r\n   Username        interface{} `json:\"_username\"`\r\n}\r\n\u30fb\u30fb\u30fb\r\n\r\nvar _r Page_s ;\r\n\r\n_r.Serial   = r.PostFormValue(\"serial\");\r\n_r.Username = r.PostFormValue(\"username\")\r\n\r\nif _r.Username == \"null\" {\r\n   _r.Username = sql.NullString{};\r\n}\r\n\r\nupdate( db *sql.DB, _r Page_s );\r\n\u30fb\u30fb\u30fb\r\n\r\nfunc update( db *sql.DB, _r Page_s ){\r\n\r\n   SQL := `\r\n      UPDATE\r\n         procure_admin\r\n      SET\r\n         username = ?\r\n      WHERE\r\n         serial = ?\r\n    `;\r\n\r\n    s := bytes.NewBufferString(\"\");\r\n    s.WriteString(SQL);\r\n\r\n    _, err := db.Exec(s.String(), _r.Username , _r.Serial);\r\n   if err != nil {\r\n       panic(err.Error());\r\n   }\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uff11\uff0eNULL\u3092\u66f8\u304d\u8fbc\u3080\u306b\u306f\u3001sql.NullString {} \u3092\u4f7f\u3046 \u30fb\u5909\u6570\u306etype\u306finterface {]\u3092\u4f7f\u3046 \uff12\uff0e\u6761\u4ef6\u3068\u3057\u3066\u3001\u5024\u304c&#8221;null&#8221;\u306e\u6642\u306bNULL\u3092\u66f8\u304d\u8fbc\u3080 _r.Usern&#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\/1169"}],"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=1169"}],"version-history":[{"count":6,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1169\/revisions"}],"predecessor-version":[{"id":1180,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1169\/revisions\/1180"}],"wp:attachment":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}