{"id":1699,"date":"2022-03-14T22:10:16","date_gmt":"2022-03-14T13:10:16","guid":{"rendered":"https:\/\/blog.wsd.sh\/?p=1699"},"modified":"2022-03-16T13:52:14","modified_gmt":"2022-03-16T04:52:14","slug":"nodejs%e3%81%a7db%e3%82%92select%e3%81%97%e3%81%9f%e7%b5%90%e6%9e%9c%e3%82%92console-log%e3%81%a7%e8%a1%a8%e7%a4%ba%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/blog.wsd.sh\/?p=1699","title":{"rendered":"<small>nodejs\u3067DB\u3092select\u3057\u305f\u7d50\u679c\u3092console.log\u3067\u8868\u793a\u3059\u308b<\/small>"},"content":{"rendered":"<p>\uff11\uff0enodejs\u3067DB\u3092select\u3057\u305f\u7d50\u679c\u3092console.log\u3067\u8868\u793a\u3059\u308b<\/p>\n<pre>\r\nconst Result = await execute(SQL, Args);\r\nconsole.log(Result)\r\n<\/pre>\n<p>\u30fbconsole \u306e\u51fa\u529b\u7d50\u679c<\/p>\n<pre>\r\n[\r\n  RowDataPacket {\r\n    code: '7297',\r\n    product_name: '\uff22\uff2f\uff38\u30cf\u30c3\u30d4\u30fc\u30b5\u30de\u30fc',\r\n    case_count: '50',\r\n    price: '74',\r\n  }\r\n]\r\n\/\/RowDataPacket\u3068\u3044\u3046\u6587\u5b57\u3092\u8868\u793a\u3059\u308b\r\n<\/pre>\n<p>\uff12\uff0e RowDataPacket\u306f\u7121\u8996\u3059\u308b<br \/>\n\u30fbMDN,Mozilla\u3067RowDataPacket\u3092\u691c\u7d22\u3057\u3066\u3082RowDataPacket\u304c\u5f15\u304d\u5f53\u305f\u3089\u306a\u3044\u306e\u3067\u3001\u4e00\u77ac\u60a9\u3093\u3060<\/p>\n<p>\uff13\uff0e\u30c7\u30fc\u30bf\u3078\u306e\u30a2\u30af\u30bb\u30b9<\/p>\n<pre>\r\nconst Result = await execute(SQL, Args);\r\nlet code = Result[0].code;\r\nlet product_name = Result[0].product_name;\r\nlet case_count = Result[0].case_count:\r\nlet price = Result[0].price;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uff11\uff0enodejs\u3067DB\u3092select\u3057\u305f\u7d50\u679c\u3092console.log\u3067\u8868\u793a\u3059\u308b const Result = await execute(SQL, Args); console.log(Result) \u30fbconsole &#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\/1699"}],"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=1699"}],"version-history":[{"count":17,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1699\/revisions"}],"predecessor-version":[{"id":1868,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1699\/revisions\/1868"}],"wp:attachment":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}