{"id":651,"date":"2020-03-26T11:38:41","date_gmt":"2020-03-26T10:38:41","guid":{"rendered":"https:\/\/cecetka.cp2.tuke.sk\/uvt\/wordpress\/?p=651"},"modified":"2020-04-15T11:39:41","modified_gmt":"2020-04-15T09:39:41","slug":"11-5-vykonanie-sql-dotazu-cez-webmin","status":"publish","type":"post","link":"https:\/\/robert.cecetka.website.tuke.sk\/?p=651","title":{"rendered":"11.5 Vykonanie SQL dotazu cez Webmin."},"content":{"rendered":"\n<p>Webmin umo\u017e\u0148uje vykona\u0165 SQL dotaz na MySQL.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>Zistenie po\u010dtu z\u00e1znamov v tabu\u013eke  po importe z AD.TUKE.SK<br> SELECT COUNT(*) FROM era_db.tbl_staff_user where removed=0;<\/p><\/blockquote>\n\n\n\n<p><\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>V\u00fdpis u\u017e\u00edvate\u013eov naimportovan\u00fdch z AD.TUKE.SK<br>SELECT * FROM era_db.tbl_staff_user where removed=0;<\/p><\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>V\u00fdpis zoznamu PC\/NB, ktor\u00e9 nemaj\u00fa pridelen\u00e9ho pou\u017e\u00edvate\u013ea z AD.TUKE.SK<\/p><\/blockquote>\n\n\n\n<div class=\"wp-block-file aligncenter\"><a href=\"https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/04\/mysql-select.txt\">mysql-select<\/a><a href=\"https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/04\/mysql-select.txt\" class=\"wp-block-file__button\" download>Stiahnu\u0165<\/a><\/div>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr1-9-1024x576.jpg\" alt=\"\" class=\"wp-image-652\" srcset=\"https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr1-9-1024x576.jpg 1024w, https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr1-9-300x169.jpg 300w, https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr1-9-768x432.jpg 768w, https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr1-9-1536x864.jpg 1536w, https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr1-9.jpg 1920w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr2-15-1024x576.jpg\" alt=\"\" class=\"wp-image-653\" srcset=\"https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr2-15-1024x576.jpg 1024w, https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr2-15-300x169.jpg 300w, https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr2-15-768x432.jpg 768w, https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr2-15-1536x864.jpg 1536w, https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr2-15.jpg 1920w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr3-7-1024x576.jpg\" alt=\"\" class=\"wp-image-654\" srcset=\"https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr3-7-1024x576.jpg 1024w, https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr3-7-300x169.jpg 300w, https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr3-7-768x432.jpg 768w, https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr3-7-1536x864.jpg 1536w, https:\/\/robert.cecetka.website.tuke.sk\/wp-content\/uploads\/2020\/03\/obr3-7.jpg 1920w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Odkaz na SQL pr\u00edkazy: <a href=\"https:\/\/www.w3resource.com\/sql\/aggregate-functions\/count-function.php\">https:\/\/www.w3resource.com\/sql\/aggregate-functions\/count-function.php<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Webmin umo\u017e\u0148uje vykona\u0165 SQL dotaz na MySQL. Zistenie po\u010dtu z\u00e1znamov v tabu\u013eke po importe z AD.TUKE.SK SELECT COUNT(*) FROM era_db.tbl_staff_user where removed=0; V\u00fdpis u\u017e\u00edvate\u013eov naimportovan\u00fdch z AD.TUKE.SKSELECT * FROM era_db.tbl_staff_user where removed=0; V\u00fdpis zoznamu PC\/NB, ktor\u00e9 nemaj\u00fa pridelen\u00e9ho pou\u017e\u00edvate\u013ea z AD.TUKE.SK Odkaz na SQL pr\u00edkazy: https:\/\/www.w3resource.com\/sql\/aggregate-functions\/count-function.php<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24],"tags":[],"_links":{"self":[{"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/posts\/651"}],"collection":[{"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=651"}],"version-history":[{"count":11,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/posts\/651\/revisions"}],"predecessor-version":[{"id":836,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/posts\/651\/revisions\/836"}],"wp:attachment":[{"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}