{"id":8124,"date":"2017-03-08T09:35:51","date_gmt":"2017-03-08T01:35:51","guid":{"rendered":"http:\/\/www.ifroglab.com\/?p=8124"},"modified":"2017-03-08T09:35:51","modified_gmt":"2017-03-08T01:35:51","slug":"11raspberry-pi-lora-gateway-add-database-at-mysql","status":"publish","type":"post","link":"https:\/\/www.ifroglab.com\/tw\/?p=8124","title":{"rendered":"11,Raspberry Pi LoRa Gateway &#8211;  Add Database at MySQL"},"content":{"rendered":"<p>\u8a2d\u5b9a\u8cc7\u6599\u5eab\u7684\u8cc7\u6599\uff0c<br \/>\n\u8acb\u5148\u5b89\u88ddMysql \u548cmyphpadmin<br \/>\n\u4e26\u5efa\u7acb\u8cc7\u6599\u5eabifroglab<br \/>\n\u8cc7\u6599\u5eab\u7684\u7528\u6236ifroglab \u548cifroglab<br \/>\n\u4e26\u65b0\u589e\u4ee5\u4e0b\u7684\u8868\u683c<\/p>\n<p>CREATE TABLE `IoTTable` (<br \/>\n  `Id` int(11) NOT NULL,<br \/>\n  `Datetime` datetime NOT NULL,<br \/>\n  `KeyName` varchar(50) COLLATE latin1_general_ci NOT NULL,<br \/>\n  `Data` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,<br \/>\n  `OwnerId` int(11) NOT NULL,<br \/>\n  `Datatype` varchar(20) COLLATE latin1_general_ci NOT NULL,<br \/>\n  `IoTProjectsId` int(11) NOT NULL DEFAULT &#8216;0&#8217;<br \/>\n) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;<\/p>\n<p><iframe loading=\"lazy\" width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/zUW-XJ2jdU8\" frameborder=\"0\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8a2d\u5b9a\u8cc7\u6599\u5eab\u7684\u8cc7\u6599\uff0c \u8acb\u5148\u5b89\u88ddMysql \u548cmyphpadmin \u4e26\u5efa\u7acb\u8cc7\u6599\u5eabif [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":8125,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[100],"tags":[],"class_list":["post-8124","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-4-raspberry-pi"],"_links":{"self":[{"href":"https:\/\/www.ifroglab.com\/tw\/index.php?rest_route=\/wp\/v2\/posts\/8124"}],"collection":[{"href":"https:\/\/www.ifroglab.com\/tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ifroglab.com\/tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ifroglab.com\/tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ifroglab.com\/tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8124"}],"version-history":[{"count":1,"href":"https:\/\/www.ifroglab.com\/tw\/index.php?rest_route=\/wp\/v2\/posts\/8124\/revisions"}],"predecessor-version":[{"id":8126,"href":"https:\/\/www.ifroglab.com\/tw\/index.php?rest_route=\/wp\/v2\/posts\/8124\/revisions\/8126"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ifroglab.com\/tw\/index.php?rest_route=\/wp\/v2\/media\/8125"}],"wp:attachment":[{"href":"https:\/\/www.ifroglab.com\/tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ifroglab.com\/tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ifroglab.com\/tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}