{"id":1069,"date":"2023-02-16T08:07:14","date_gmt":"2023-02-16T08:07:14","guid":{"rendered":"https:\/\/www.tools.keywordfinder.us\/?page_id=1069"},"modified":"2023-02-16T08:07:14","modified_gmt":"2023-02-16T08:07:14","slug":"sql-formatter","status":"publish","type":"page","link":"https:\/\/tools.billionsideas.com\/nl_nl\/sql-formatter\/","title":{"rendered":"SQL Formatter"},"content":{"rendered":"<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n\n\n  \n    <script src=\"https:\/\/cdn.jsdelivr.net\/npm\/sql-formatter@2.3.2\/dist\/sql-formatter.min.js\"><\/script>\n    <script>\n      function formatSQL() {\n        \/\/ Get the input SQL query\n        var input = document.getElementById(\"input\").value;\n\n        \/\/ Format the query using the sql-formatter library\n        var output = sqlFormatter.format(input);\n\n        \/\/ Display the formatted query on the page\n        document.getElementById(\"output\").value = output;\n      }\n    <\/script>\n  \n  <section>    <h1>SQL Formatter<\/h1>\n\n    <textarea id=\"input\"><\/textarea>\n    <br>\n    <button onclick=\"formatSQL()\">Format SQL<\/button>\n    <br>\n    <textarea id=\"output\"><\/textarea><br><\/section>\n  \n\n\n<style>\nsection{\n         margin-top:60px;\n        width: 100%;\n        max-width: 970px;\n        background-color: #fff;\n        border: 1px solid #ddd;\n        padding: 25px;\n      }\n<\/style>\n\n<script>\n\ndocument.getElementById(\"copy\").addEventListener(\"click\", function() {\n  var output = document.getElementById(\"output\");\n  output.select();\n  document.execCommand(\"copy\");\n});\n\nfunction downloadText() {\n  var output = document.getElementById(\"output\").value;\n  var filename = \"formatted.sql\";\n  var blob = new Blob([output], { type: \"text\/plain\" });\n  var a = document.createElement(\"a\");\n  a.href = URL.createObjectURL(blob);\n  a.download = filename;\n  a.click();\n}\n\ndocument.getElementById(\"download\").addEventListener(\"click\", downloadText);\n\n<\/script>\n\n\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>SQL Formatter Format SQL<\/p>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","footnotes":""},"class_list":["post-1069","page","type-page","status-publish"],"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"Billions Ideas","author_link":"https:\/\/tools.billionsideas.com\/nl_nl\/author\/loginbillionsideas-com\/"},"comment_info":0,"jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/tools.billionsideas.com\/nl_nl\/wp-json\/wp\/v2\/pages\/1069","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tools.billionsideas.com\/nl_nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tools.billionsideas.com\/nl_nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tools.billionsideas.com\/nl_nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tools.billionsideas.com\/nl_nl\/wp-json\/wp\/v2\/comments?post=1069"}],"version-history":[{"count":0,"href":"https:\/\/tools.billionsideas.com\/nl_nl\/wp-json\/wp\/v2\/pages\/1069\/revisions"}],"wp:attachment":[{"href":"https:\/\/tools.billionsideas.com\/nl_nl\/wp-json\/wp\/v2\/media?parent=1069"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}