{"id":881,"date":"2020-05-19T14:36:46","date_gmt":"2020-05-19T07:36:46","guid":{"rendered":"http:\/\/www.oopsbox.com\/?p=881"},"modified":"2020-05-19T14:52:10","modified_gmt":"2020-05-19T07:52:10","slug":"%e0%b8%ab%e0%b8%b2%e0%b8%88%e0%b8%b3%e0%b8%99%e0%b8%a7%e0%b8%99%e0%b8%a3%e0%b8%b2%e0%b8%a2%e0%b9%83%e0%b8%ab%e0%b8%a1%e0%b9%88%e0%b9%82%e0%b8%94%e0%b8%a2%e0%b9%83%e0%b8%8a%e0%b9%89%e0%b8%81%e0%b8%b2","status":"publish","type":"post","link":"https:\/\/www.oopsbox.com\/?p=881","title":{"rendered":"\u0e2b\u0e32\u0e08\u0e33\u0e19\u0e27\u0e19\u0e23\u0e32\u0e22\u0e43\u0e2b\u0e21\u0e48\u0e42\u0e14\u0e22\u0e43\u0e0a\u0e49\u0e01\u0e32\u0e23\u0e40\u0e1b\u0e23\u0e35\u0e22\u0e1a\u0e40\u0e17\u0e35\u0e22\u0e1a\u0e23\u0e30\u0e2b\u0e27\u0e48\u0e32\u0e07\u0e41\u0e16\u0e27\u0e43\u0e19 MySQL"},"content":{"rendered":"<p>\u0e27\u0e31\u0e19\u0e19\u0e35\u0e49\u0e1a\u0e25\u0e47\u0e2d\u0e01\u0e2a\u0e31\u0e49\u0e19 \u0e46 \u0e08\u0e32\u0e01\u0e2b\u0e31\u0e27\u0e02\u0e49\u0e2d\u0e44\u0e21\u0e48\u0e07\u0e07\u0e01\u0e31\u0e19\u0e43\u0e0a\u0e48\u0e44\u0e2b\u0e21 ^__^\u00a0 \u0e2d\u0e18\u0e34\u0e1a\u0e32\u0e22\u0e04\u0e23\u0e48\u0e32\u0e27 \u0e46 \u0e04\u0e37\u0e2d\u0e01\u0e23\u0e13\u0e35\u0e40\u0e23\u0e32\u0e21\u0e35\u0e15\u0e32\u0e23\u0e32\u0e07\u0e17\u0e35\u0e48\u0e40\u0e01\u0e47\u0e1a\u0e08\u0e33\u0e19\u0e27\u0e19\u0e2a\u0e30\u0e2a\u0e21\u0e44\u0e27\u0e49\u0e43\u0e19\u0e41\u0e15\u0e48\u0e25\u0e30\u0e27\u0e31\u0e19 \u0e40\u0e27\u0e25\u0e32\u0e40\u0e23\u0e32\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23\u0e17\u0e23\u0e32\u0e1a\u0e27\u0e48\u0e32\u0e41\u0e25\u0e49\u0e27\u0e27\u0e31\u0e19\u0e19\u0e35\u0e49\u0e21\u0e35\u0e40\u0e1e\u0e34\u0e48\u0e21\u0e40\u0e02\u0e49\u0e32\u0e21\u0e32\u0e43\u0e2b\u0e21\u0e48\u0e40\u0e17\u0e48\u0e32\u0e44\u0e2b\u0e23\u0e48 \u0e42\u0e14\u0e22\u0e17\u0e31\u0e48\u0e27\u0e44\u0e1b\u0e17\u0e33\u0e21\u0e37\u0e2d\u0e01\u0e47\u0e2d\u0e32\u0e08\u0e08\u0e30<\/p>\n<ul>\n<li>\u0e19\u0e31\u0e1a\u0e08\u0e33\u0e19\u0e27\u0e19\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e23\u0e32\u0e22\u0e17\u0e35\u0e48\u0e21\u0e32\u0e43\u0e2b\u0e21\u0e48\u0e44\u0e07<\/li>\n<li>\u0e2b\u0e23\u0e37\u0e2d\u0e40\u0e2d\u0e32\u0e08\u0e33\u0e19\u0e27\u0e19\u0e2a\u0e30\u0e2a\u0e21\u0e02\u0e2d\u0e07\u0e27\u0e31\u0e19\u0e19\u0e35\u0e49\/\u0e15\u0e2d\u0e19\u0e19\u0e35\u0e49 \u0e44\u0e1b\u0e25\u0e1a\u0e01\u0e31\u0e1a\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e41\u0e25\u0e49\u0e27<\/li>\n<\/ul>\n<p>\u0e43\u0e0a\u0e48\u0e19\u0e31\u0e48\u0e19\u0e41\u0e2b\u0e25\u0e48\u0e30\u0e17\u0e33\u0e14\u0e49\u0e27\u0e22\u0e21\u0e37\u0e2d \u0e41\u0e25\u0e49\u0e27\u0e43\u0e19\u0e20\u0e32\u0e29\u0e32 SQL \u0e40\u0e04\u0e49\u0e32\u0e17\u0e33\u0e22\u0e31\u0e07\u0e44\u0e07\u0e01\u0e31\u0e19 \u0e43\u0e2b\u0e49\u0e40\u0e2b\u0e47\u0e19\u0e20\u0e32\u0e1e\u0e21\u0e32\u0e01\u0e02\u0e36\u0e49\u0e19\u0e40\u0e23\u0e32\u0e08\u0e30\u0e40\u0e2d\u0e32\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e40\u0e04\u0e2a\u0e42\u0e04\u0e27\u0e34\u0e14 19 \u0e02\u0e2d\u0e07\u0e1b\u0e23\u0e30\u0e40\u0e17\u0e28\u0e44\u0e17\u0e22\u0e43\u0e19\u0e41\u0e15\u0e48\u0e25\u0e30\u0e27\u0e31\u0e19\u0e21\u0e32\u0e40\u0e1b\u0e47\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e14\u0e31\u0e21\u0e21\u0e35\u0e48\u0e2b\u0e25\u0e48\u0e30\u0e01\u0e31\u0e19 (\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e23\u0e34\u0e07\u0e19\u0e30 \u0e19\u0e35\u0e48\u00a0 \u0e28\u0e1a\u0e04. \u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e17\u0e38\u0e01\u0e27\u0e31\u0e19 \u0e2d\u0e22\u0e32\u0e01\u0e44\u0e14\u0e49\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e01\u0e47\u0e44\u0e1b\u0e17\u0e35\u0e48\u0e01\u0e23\u0e21\u0e04\u0e27\u0e1a\u0e04\u0e38\u0e21\u0e42\u0e23\u0e04 <a href=\"https:\/\/covid19.ddc.moph.go.th\/th\/api\">\u0e17\u0e35\u0e48\u0e19\u0e35\u0e48\u0e40\u0e25\u0e22 https:\/\/covid19.ddc.moph.go.th\/th\/api<\/a>)<\/p>\n<p>*\u0e40\u0e23\u0e32\u0e15\u0e31\u0e14\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e22\u0e2d\u0e14\u0e2a\u0e30\u0e2a\u0e21\u0e02\u0e2d\u0e07\u0e41\u0e15\u0e48\u0e25\u0e30\u0e27\u0e31\u0e19\u0e43\u0e19\u0e40\u0e14\u0e37\u0e2d\u0e19\u0e1e\u0e24\u0e29\u0e20\u0e32\u0e04\u0e21\u0e2b\u0e25\u0e48\u0e30\u0e01\u0e31\u0e19 \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e08\u0e30\u0e44\u0e14\u0e49\u0e07\u0e48\u0e32\u0e22\u0e02\u0e36\u0e49\u0e19<\/p>\n<pre>CREATE TABLE `covid19timeline` (\r\n  `ConfirmedDate` date NOT NULL,\r\n  `Confirmed` int(11) NOT NULL,\r\n  `Recovered` int(11) NOT NULL,\r\n  `Hospitalized` int(11) NOT NULL,\r\n  `Deaths` int(11) NOT NULL,\r\n  PRIMARY KEY (`ConfirmedDate`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\r\n\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-01',2960,2719,187,54);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-02',2966,2732,180,54);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-03',2969,2739,176,54);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-04',2987,2740,193,54);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-05',2988,2747,187,54);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-06',2989,2761,173,55);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-07',2992,2772,165,55);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-08',3000,2784,161,55);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-09',3004,2787,161,56);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-10',3009,2794,159,56);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-11',3015,2796,163,56);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-12',3017,2798,163,56);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-13',3017,2844,117,56);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-14',3018,2850,112,56);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-15',3025,2854,115,56);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-16',3025,2855,114,56);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-17',3028,2856,116,56);\r\nINSERT INTO `covid19timeline` (`ConfirmedDate`,`Confirmed`,`Recovered`,`Hospitalized`,`Deaths`) VALUES ('2020-05-18',3031,2857,118,56);\r\n<\/pre>\n<p>\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e01\u0e47\u0e15\u0e32\u0e21\u0e19\u0e35\u0e49<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-882 size-large\" src=\"https:\/\/www.oopsbox.com\/wp-content\/uploads\/Screenshot-20200519142540-1742x780-1-1024x459.png\" alt=\"\" width=\"700\" height=\"314\" srcset=\"https:\/\/www.oopsbox.com\/wp-content\/uploads\/Screenshot-20200519142540-1742x780-1-1024x459.png 1024w, https:\/\/www.oopsbox.com\/wp-content\/uploads\/Screenshot-20200519142540-1742x780-1-300x134.png 300w, https:\/\/www.oopsbox.com\/wp-content\/uploads\/Screenshot-20200519142540-1742x780-1-768x344.png 768w, https:\/\/www.oopsbox.com\/wp-content\/uploads\/Screenshot-20200519142540-1742x780-1-1536x688.png 1536w, https:\/\/www.oopsbox.com\/wp-content\/uploads\/Screenshot-20200519142540-1742x780-1-700x313.png 700w, https:\/\/www.oopsbox.com\/wp-content\/uploads\/Screenshot-20200519142540-1742x780-1.png 1742w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>\u0e17\u0e35\u0e19\u0e35\u0e49\u0e40\u0e23\u0e32\u0e01\u0e47\u0e2b\u0e32\u0e08\u0e33\u0e19\u0e27\u0e19\u0e23\u0e32\u0e22\u0e43\u0e2b\u0e21\u0e48\u0e01\u0e31\u0e19\u0e27\u0e48\u0e32\u0e21\u0e35\u0e08\u0e33\u0e19\u0e27\u0e19\u0e40\u0e17\u0e48\u0e32\u0e44\u0e2b\u0e23\u0e48\u0e42\u0e14\u0e22\u0e01\u0e32\u0e23\u0e40\u0e1b\u0e23\u0e35\u0e22\u0e1a\u0e40\u0e17\u0e35\u0e22\u0e1a\u0e01\u0e31\u0e1a\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e41\u0e25\u0e49\u0e27<\/p>\n<pre>SELECT \r\n\tc1.*,\r\n    COALESCE(c1.Confirmed - c2.Confirmed, 0) AS NewConfirmed\r\nFROM covid19timeline c1 \r\n\tLEFT JOIN covid19timeline c2 ON c2.ConfirmedDate = DATE_SUB(c1.ConfirmedDate, INTERVAL 1 DAY)\r\nORDER BY c1.ConfirmedDate;\r\n<\/pre>\n<p>\u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c\u0e17\u0e35\u0e48\u0e44\u0e14\u0e49\u0e15\u0e32\u0e21\u0e19\u0e35\u0e49 \u0e42\u0e14\u0e22 NewConfirmed \u0e04\u0e37\u0e2d\u0e08\u0e33\u0e19\u0e27\u0e19\u0e23\u0e32\u0e22\u0e43\u0e2b\u0e21\u0e48\u0e17\u0e35\u0e48\u0e40\u0e1e\u0e34\u0e48\u0e21\u0e40\u0e02\u0e49\u0e32\u0e21\u0e32<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-883\" src=\"https:\/\/www.oopsbox.com\/wp-content\/uploads\/Screenshot-20200519142803-1627x745-1-1024x469.png\" alt=\"\" width=\"700\" height=\"321\" srcset=\"https:\/\/www.oopsbox.com\/wp-content\/uploads\/Screenshot-20200519142803-1627x745-1-1024x469.png 1024w, https:\/\/www.oopsbox.com\/wp-content\/uploads\/Screenshot-20200519142803-1627x745-1-300x137.png 300w, https:\/\/www.oopsbox.com\/wp-content\/uploads\/Screenshot-20200519142803-1627x745-1-768x352.png 768w, https:\/\/www.oopsbox.com\/wp-content\/uploads\/Screenshot-20200519142803-1627x745-1-1536x703.png 1536w, https:\/\/www.oopsbox.com\/wp-content\/uploads\/Screenshot-20200519142803-1627x745-1-700x321.png 700w, https:\/\/www.oopsbox.com\/wp-content\/uploads\/Screenshot-20200519142803-1627x745-1.png 1627w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>\u0e08\u0e1a\u0e1b\u0e34\u0e4a\u0e07 !! ^__^<\/p>\n<p>\u0e1b.\u0e25.<\/p>\n<ul>\n<li>\u0e41\u0e25\u0e49\u0e27\u0e40\u0e23\u0e32\u0e08\u0e30\u0e40\u0e2d\u0e32\u0e21\u0e32\u0e43\u0e0a\u0e49\u0e15\u0e2d\u0e19\u0e44\u0e2b\u0e19 \u0e42\u0e14\u0e22\u0e1b\u0e01\u0e15\u0e34\u0e2a\u0e48\u0e27\u0e19\u0e43\u0e2b\u0e0d\u0e48\u0e01\u0e47\u0e21\u0e31\u0e01\u0e2d\u0e22\u0e39\u0e48\u0e43\u0e19\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e17\u0e35\u0e48\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23\u0e14\u0e39\u0e04\u0e27\u0e32\u0e21\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19\u0e41\u0e1b\u0e25\u0e07\u0e40\u0e1b\u0e47\u0e19\u0e2b\u0e25\u0e31\u0e01\u0e41\u0e15\u0e48\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e40\u0e23\u0e32\u0e21\u0e35\u0e21\u0e31\u0e01\u0e40\u0e1b\u0e47\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e2a\u0e30\u0e2a\u0e21\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e40\u0e14\u0e35\u0e22\u0e27 \u0e2d\u0e22\u0e48\u0e32\u0e07\u0e40\u0e04\u0e2a\u0e01\u0e32\u0e23\u0e23\u0e30\u0e1a\u0e32\u0e14\u0e02\u0e2d\u0e07\u0e42\u0e04\u0e27\u0e34\u0e14 19 \u0e40\u0e1b\u0e47\u0e19\u0e15\u0e49\u0e19 (\u0e41\u0e15\u0e48 api \u0e40\u0e04\u0e49\u0e32\u0e21\u0e35\u0e41\u0e08\u0e49\u0e07\u0e23\u0e32\u0e22\u0e43\u0e2b\u0e21\u0e48\u0e19\u0e30\u0e15\u0e31\u0e14\u0e2d\u0e2d\u0e01\u0e40\u0e09\u0e22 \u0e46)<\/li>\n<li>\u0e44\u0e1b\u0e25\u0e2d\u0e07\u0e40\u0e25\u0e48\u0e19\u0e01\u0e31\u0e19\u0e44\u0e14\u0e49\u0e17\u0e35\u0e48 <a href=\"https:\/\/www.db-fiddle.com\/f\/n3Zbf8FmThZxPGDgSGhmVN\/0\">https:\/\/www.db-fiddle.com\/f\/n3Zbf8FmThZxPGDgSGhmVN\/0<\/a><\/li>\n<\/ul>\n<div id=\"s-share-buttons\" class=\"\"><div class=\"s-single-share\">\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"fb-share-button\" data-href=\"https:\/\/www.oopsbox.com\/?p=881\" data-type=\"button_count\"><\/div><\/div><div class=\"s-single-share\"><a href=\"https:\/\/twitter.com\/share\" class=\"twitter-share-button\"><\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><div class=\"s-single-share\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"g-plusone\" data-size=\"medium\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div><div class=\"s-single-share\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"\/\/www.pinterest.com\/pin\/create\/button\/\" data-pin-do=\"buttonBookmark\"  data-pin-color=\"red\"><img decoding=\"async\" src=\"\/\/assets.pinterest.com\/images\/pidgets\/pinit_fg_en_rect_red_20.png\" \/><\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<script type=\"text\/javascript\" async defer src=\"\/\/assets.pinterest.com\/js\/pinit.js\"><\/script>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div><div class=\"s-single-share\">\n\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"mailto:?Subject=\u0e2b\u0e32\u0e08\u0e33\u0e19\u0e27\u0e19\u0e23\u0e32\u0e22\u0e43\u0e2b\u0e21\u0e48\u0e42\u0e14\u0e22\u0e43\u0e0a\u0e49\u0e01\u0e32\u0e23\u0e40\u0e1b\u0e23\u0e35\u0e22\u0e1a\u0e40\u0e17\u0e35\u0e22\u0e1a\u0e23\u0e30\u0e2b\u0e27\u0e48\u0e32\u0e07\u0e41\u0e16\u0e27\u0e43\u0e19%20MySQL&Body=Here%20is%20the%20link%20to%20the%20article:%20https:\/\/www.oopsbox.com\/?p=881\" title=\"Email\" class=\"s3-email\"><img decoding=\"async\" src=\"https:\/\/www.oopsbox.com\/wp-content\/plugins\/simple-social-share\/includes\/..\/images\/share-email.png\"><\/a>\n\t\t\t\t\t\t\t\t\t\t\t<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>\u0e27\u0e31\u0e19\u0e19\u0e35\u0e49\u0e1a\u0e25\u0e47\u0e2d\u0e01\u0e2a\u0e31\u0e49\u0e19 \u0e46 \u0e08\u0e32\u0e01\u0e2b\u0e31\u0e27\u0e02\u0e49\u0e2d\u0e44\u0e21\u0e48\u0e07\u0e07\u0e01\u0e31\u0e19\u0e43\u0e0a\u0e48\u0e44\u0e2b\u0e21 ^__^\u00a0 \u0e2d\u0e18\u0e34\u0e1a\u0e32\u0e22\u0e04\u0e23\u0e48\u0e32\u0e27 \u0e46 \u0e04\u0e37\u0e2d\u0e01\u0e23\u0e13\u0e35\u0e40\u0e23\u0e32\u0e21\u0e35\u0e15\u0e32\u0e23\u0e32\u0e07\u0e17\u0e35\u0e48\u0e40\u0e01\u0e47\u0e1a\u0e08\u0e33\u0e19\u0e27\u0e19\u0e2a\u0e30\u0e2a\u0e21\u0e44\u0e27\u0e49\u0e43\u0e19\u0e41\u0e15\u0e48\u0e25\u0e30\u0e27\u0e31\u0e19 \u0e40\u0e27\u0e25\u0e32\u0e40\u0e23\u0e32\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23\u0e17\u0e23\u0e32\u0e1a\u0e27\u0e48\u0e32\u0e41\u0e25\u0e49\u0e27\u0e27\u0e31\u0e19\u0e19\u0e35\u0e49\u0e21\u0e35\u0e40\u0e1e\u0e34\u0e48\u0e21\u0e40\u0e02\u0e49\u0e32\u0e21\u0e32\u0e43\u0e2b\u0e21\u0e48\u0e40\u0e17\u0e48\u0e32\u0e44\u0e2b\u0e23\u0e48 \u0e42\u0e14\u0e22\u0e17\u0e31\u0e48\u0e27\u0e44\u0e1b\u0e17\u0e33\u0e21\u0e37\u0e2d\u0e01\u0e47\u0e2d\u0e32\u0e08\u0e08\u0e30 \u0e19\u0e31\u0e1a\u0e08\u0e33\u0e19\u0e27\u0e19\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e23\u0e32\u0e22\u0e17\u0e35\u0e48\u0e21\u0e32\u0e43\u0e2b\u0e21\u0e48\u0e44\u0e07 \u0e2b\u0e23\u0e37\u0e2d\u0e40\u0e2d\u0e32\u0e08\u0e33\u0e19\u0e27\u0e19\u0e2a\u0e30\u0e2a\u0e21\u0e02\u0e2d\u0e07\u0e27\u0e31\u0e19\u0e19\u0e35\u0e49\/\u0e15\u0e2d\u0e19\u0e19\u0e35\u0e49 \u0e44\u0e1b\u0e25\u0e1a\u0e01\u0e31\u0e1a\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e41\u0e25\u0e49\u0e27 \u0e43\u0e0a\u0e48\u0e19\u0e31\u0e48\u0e19\u0e41\u0e2b\u0e25\u0e48\u0e30\u0e17\u0e33\u0e14\u0e49\u0e27\u0e22\u0e21\u0e37\u0e2d \u0e41\u0e25\u0e49\u0e27\u0e43\u0e19\u0e20\u0e32\u0e29\u0e32 SQL \u0e40\u0e04\u0e49\u0e32\u0e17\u0e33\u0e22\u0e31\u0e07\u0e44\u0e07\u0e01\u0e31\u0e19 \u0e43\u0e2b\u0e49\u0e40\u0e2b\u0e47\u0e19\u0e20\u0e32\u0e1e\u0e21\u0e32\u0e01\u0e02\u0e36\u0e49\u0e19\u0e40\u0e23\u0e32\u0e08\u0e30\u0e40\u0e2d\u0e32\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e40\u0e04\u0e2a\u0e42\u0e04\u0e27\u0e34\u0e14 19 \u0e02\u0e2d\u0e07\u0e1b\u0e23\u0e30\u0e40\u0e17\u0e28\u0e44\u0e17\u0e22\u0e43\u0e19\u0e41\u0e15\u0e48\u0e25\u0e30\u0e27\u0e31\u0e19\u0e21\u0e32\u0e40\u0e1b\u0e47\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e14\u0e31\u0e21\u0e21\u0e35\u0e48\u0e2b\u0e25\u0e48\u0e30\u0e01\u0e31\u0e19 (\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e23\u0e34\u0e07\u0e19\u0e30 \u0e19\u0e35\u0e48\u00a0 \u0e28\u0e1a\u0e04. \u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e17\u0e38\u0e01\u0e27\u0e31\u0e19 \u0e2d\u0e22\u0e32\u0e01\u0e44\u0e14\u0e49\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e01\u0e47\u0e44\u0e1b\u0e17\u0e35\u0e48\u0e01\u0e23\u0e21\u0e04\u0e27\u0e1a\u0e04\u0e38\u0e21\u0e42\u0e23\u0e04 \u0e17\u0e35\u0e48\u0e19\u0e35\u0e48\u0e40\u0e25\u0e22 https:\/\/covid19.ddc.moph.go.th\/th\/api) *\u0e40\u0e23\u0e32\u0e15\u0e31\u0e14\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e22\u0e2d\u0e14\u0e2a\u0e30\u0e2a\u0e21\u0e02\u0e2d\u0e07\u0e41\u0e15\u0e48\u0e25\u0e30\u0e27\u0e31\u0e19\u0e43\u0e19\u0e40\u0e14\u0e37\u0e2d\u0e19\u0e1e\u0e24\u0e29\u0e20\u0e32\u0e04\u0e21\u0e2b\u0e25\u0e48\u0e30\u0e01\u0e31\u0e19 \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e08\u0e30\u0e44\u0e14\u0e49\u0e07\u0e48\u0e32\u0e22\u0e02\u0e36\u0e49\u0e19 CREATE TABLE `covid19timeline` ( `ConfirmedDate` date NOT NULL, `Confirmed` int(11) NOT NULL, `Recovered` int(11) NOT NULL, `Hospitalized` int(11) NOT NULL, `Deaths` int(11) NOT NULL, PRIMARY KEY (`ConfirmedDate`) &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.oopsbox.com\/?p=881\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;\u0e2b\u0e32\u0e08\u0e33\u0e19\u0e27\u0e19\u0e23\u0e32\u0e22\u0e43\u0e2b\u0e21\u0e48\u0e42\u0e14\u0e22\u0e43\u0e0a\u0e49\u0e01\u0e32\u0e23\u0e40\u0e1b\u0e23\u0e35\u0e22\u0e1a\u0e40\u0e17\u0e35\u0e22\u0e1a\u0e23\u0e30\u0e2b\u0e27\u0e48\u0e32\u0e07\u0e41\u0e16\u0e27\u0e43\u0e19 MySQL&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":884,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5],"tags":[112,12],"class_list":["post-881","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-comparing-same-table","tag-mysql","entry"],"views":3178,"_links":{"self":[{"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=\/wp\/v2\/posts\/881","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=881"}],"version-history":[{"count":2,"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=\/wp\/v2\/posts\/881\/revisions"}],"predecessor-version":[{"id":886,"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=\/wp\/v2\/posts\/881\/revisions\/886"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=\/wp\/v2\/media\/884"}],"wp:attachment":[{"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=881"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=881"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oopsbox.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=881"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}