{"id":245,"date":"2010-10-28T07:15:37","date_gmt":"2010-10-28T06:15:37","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=245&#038;lang=fr"},"modified":"2015-11-20T11:23:17","modified_gmt":"2015-11-20T10:23:17","slug":"sql-query","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=245","title":{"rendered":"DeMaSy SQL Query procedures"},"content":{"rendered":"<p>After having <a href=\"..\/?p=338%E2%8C%A9=fr\">accessed the DeMaSy Utilities<\/a>, click on the Icon called &#8220;Sql Query&#8221;.<\/p>\n<p>Next, Screen 1 appears. It allows you to choose a database. In the white space area you can type your SQL Query. You may also paste a query that is in the <a title=\"Software Clipboard\" href=\"http:\/\/en.wikipedia.org\/wiki\/Clipboard_%28software%29\" target=\"_blank\">clipboard<\/a>.<\/p>\n<p>There is also the possibility on Screen 2 to see all the Sql commands, and instead of typing the commands, you build them with the buttons. In order to access this screen you must select the <a title=\"Radio button\" href=\"http:\/\/en.wikipedia.org\/wiki\/Radio_buttons\" target=\"_blank\">radio boutton<\/a> called &#8220;Sql buttons&#8221;.<\/p>\n<p>After having built your Sql Query, click on &#8220;Get Results or Execute&#8221;. For an Insert, Update or Delete query you must enter a checksum. This checksum can only be obtained from the Hotline.<\/p>\n<p>The results will be displayed on the Tab called &#8220;SQL Query Results&#8221;<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/sdna.lu\/?attachment_id=317\" rel=\"attachment wp-att-317\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-317\" title=\"DeMaSy-Utilities-SqlQueries\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/DeMaSy-Utilities-SqlQueries1.png\" alt=\"\" width=\"631\" height=\"492\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/DeMaSy-Utilities-SqlQueries1.png 631w, https:\/\/sdna.lu\/wp-content\/uploads\/DeMaSy-Utilities-SqlQueries1-300x233.png 300w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/a>Screen 1<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/sdna.lu\/?attachment_id=248\" rel=\"attachment wp-att-248\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-248\" title=\"DeMaSy-Utilities-SqlQueriesBouton\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/DeMaSy-Utilities-SqlQueriesBouton.png\" alt=\"\" width=\"631\" height=\"492\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/DeMaSy-Utilities-SqlQueriesBouton.png 631w, https:\/\/sdna.lu\/wp-content\/uploads\/DeMaSy-Utilities-SqlQueriesBouton-300x233.png 300w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/a>Screen 2<\/p>\n","protected":false},"excerpt":{"rendered":"<p>After having accessed the DeMaSy Utilities, click on the Icon called &#8220;Sql Query&#8221;. Next, Screen 1 appears. It allows you to choose a database. In the white space area you can type your SQL Query. You may also paste a query that is in the clipboard. There is also the possibility on Screen 2 to [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-245","post","type-post","status-publish","format-standard","hentry","category-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/245","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=245"}],"version-history":[{"count":24,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/245\/revisions"}],"predecessor-version":[{"id":4531,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/245\/revisions\/4531"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}