{"id":382,"date":"2021-03-25T13:48:47","date_gmt":"2021-03-25T13:48:47","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/?page_id=382"},"modified":"2021-03-25T15:09:27","modified_gmt":"2021-03-25T15:09:27","slug":"using-db4sql-sql","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/sql\/using-db4sql-sql\/","title":{"rendered":"Using DB4SQL &amp; SQL"},"content":{"rendered":"<ul>\n<li>Click the &#8220;Execute SQL&#8221; tab:<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-386\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25135222\/DB4SQL-execute-sql.png\" alt=\"\" width=\"418\" height=\"26\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25135222\/DB4SQL-execute-sql.png 418w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25135222\/DB4SQL-execute-sql-300x19.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELD%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQDnqdD%2Fq%2Be6%2Bb%2FOV6pVLjTeM1XUUtcIw4NYtnpED9oatQIhAPIJsw0YC9sTxTC9xOyzknREJndrxjEM%2FJNSlHqwSAYWKrkFCHkQBRoMMjczNTcwMTk1NDMzIgwUtJTz1AQcO8gf%2BbUqlgWA5lhQGnlnj7oOfDLQaCbhKMFBzemKVNO2QYep87vpKNAAPb9aAc%2FyzwGK7EoqB7Q%2BZjJFh8wpdO%2B3IeXyjPUTV63SgGopTb%2Bcr0CygV%2BTobaZCb1hmrqG%2B1so9cEZ0t%2FQo3ZMK7MzpfdRgqmGchujmYoflKrGYXQN1OaU0dXtuXqJtyapdwFmOwdA1EYm81BLiIG0iBbxywQzl32KYBgi0kD0KBfBVhkZ9hRiIMEh4dTpnOm3cpwnQ9StNCaxy9nuOYfdNkKWmU%2Fz6JT%2Fc25Kaj0BXck2cY1Qwr4i2vHe7uUcr0t9j%2F36LcWkVCwcgC5nz5enMiuBzeSjEgpkUGxvZH4yNyYgFjRHIPjhncn6pJizJAe%2Buk58n2PaVmaiW7tql9492G0zK3Ht58YcaueAdSWBxSAoimGRxpc103W6PFVsJ7oLmG4sAyWhhbqqQIqQqCOBoSVduFh9Z0HZZFQBufCg5%2F%2Ff4J2yi2OGAvxhf%2FDM8fK6DSvXdFu7bR2Zdm5DwEm%2BGGmICHaI6FXiBDkaxTIuRqubcXaH8IRUsdjJ2%2BOV2EDEdZg17qy7bAv1qqz3sF7fGG8W6%2FX%2FsRxDi%2Fw4adIhNtXMMIAy42a9BkNp%2Bhj%2Bsab9xKGf4aocfw4RUC00Rzlc6EAA3yUPTC1FWQai81Xf8lKCmLE1chxjN1R%2BHO0vO3gAhaD5DeSnt1new4gd%2F59ocn6RRqUUA0KXqRnGsZB%2BmPsR0T71gShVVR0cBGt4zp1rdmJ1SjoHdORJrUpG4ahufU8IEG%2BE6FPn7NQJaZxWqmegPQwK7n8AbMv3qXHKA50SkwPVZ9vpV6gr5C8if64mRMdtu2nXsk1GdyzxxI2aVkwRSS5zfizWtvLNF8r1iRKwojDi3OjWBjqwATR1PZnuGPCYyxuwxq00GOQTzeGY6F5DNXSM0iS6P17S%2FrDGUCLBQhL0qdfoL0LgAvSEfTz4pcalYgihB27dpnSqU%2FFjwQgaQf8cAfm%2FAU%2Bv1V44BRNlHrOD%2Bmem6KjB4a1C9nuEr2SLx6BzYEpJ6A%2BzqYlWF1iN7jG7JHx%2FrH1lFimtt4zFSPG2mpecK4q%2Fnxb2w5PSLNmgEXSoch6qMpGkvJLHxoa0vsmicAtZyn2J&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXPFB5WQP%2F20261022%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261022T160409Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b62b8d39b4c43359a3d6091ced5ea9849d7b44ca24a60b0f27d48559a701f2e2 300w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25135222\/DB4SQL-execute-sql-400x26.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELD%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQDnqdD%2Fq%2Be6%2Bb%2FOV6pVLjTeM1XUUtcIw4NYtnpED9oatQIhAPIJsw0YC9sTxTC9xOyzknREJndrxjEM%2FJNSlHqwSAYWKrkFCHkQBRoMMjczNTcwMTk1NDMzIgwUtJTz1AQcO8gf%2BbUqlgWA5lhQGnlnj7oOfDLQaCbhKMFBzemKVNO2QYep87vpKNAAPb9aAc%2FyzwGK7EoqB7Q%2BZjJFh8wpdO%2B3IeXyjPUTV63SgGopTb%2Bcr0CygV%2BTobaZCb1hmrqG%2B1so9cEZ0t%2FQo3ZMK7MzpfdRgqmGchujmYoflKrGYXQN1OaU0dXtuXqJtyapdwFmOwdA1EYm81BLiIG0iBbxywQzl32KYBgi0kD0KBfBVhkZ9hRiIMEh4dTpnOm3cpwnQ9StNCaxy9nuOYfdNkKWmU%2Fz6JT%2Fc25Kaj0BXck2cY1Qwr4i2vHe7uUcr0t9j%2F36LcWkVCwcgC5nz5enMiuBzeSjEgpkUGxvZH4yNyYgFjRHIPjhncn6pJizJAe%2Buk58n2PaVmaiW7tql9492G0zK3Ht58YcaueAdSWBxSAoimGRxpc103W6PFVsJ7oLmG4sAyWhhbqqQIqQqCOBoSVduFh9Z0HZZFQBufCg5%2F%2Ff4J2yi2OGAvxhf%2FDM8fK6DSvXdFu7bR2Zdm5DwEm%2BGGmICHaI6FXiBDkaxTIuRqubcXaH8IRUsdjJ2%2BOV2EDEdZg17qy7bAv1qqz3sF7fGG8W6%2FX%2FsRxDi%2Fw4adIhNtXMMIAy42a9BkNp%2Bhj%2Bsab9xKGf4aocfw4RUC00Rzlc6EAA3yUPTC1FWQai81Xf8lKCmLE1chxjN1R%2BHO0vO3gAhaD5DeSnt1new4gd%2F59ocn6RRqUUA0KXqRnGsZB%2BmPsR0T71gShVVR0cBGt4zp1rdmJ1SjoHdORJrUpG4ahufU8IEG%2BE6FPn7NQJaZxWqmegPQwK7n8AbMv3qXHKA50SkwPVZ9vpV6gr5C8if64mRMdtu2nXsk1GdyzxxI2aVkwRSS5zfizWtvLNF8r1iRKwojDi3OjWBjqwATR1PZnuGPCYyxuwxq00GOQTzeGY6F5DNXSM0iS6P17S%2FrDGUCLBQhL0qdfoL0LgAvSEfTz4pcalYgihB27dpnSqU%2FFjwQgaQf8cAfm%2FAU%2Bv1V44BRNlHrOD%2Bmem6KjB4a1C9nuEr2SLx6BzYEpJ6A%2BzqYlWF1iN7jG7JHx%2FrH1lFimtt4zFSPG2mpecK4q%2Fnxb2w5PSLNmgEXSoch6qMpGkvJLHxoa0vsmicAtZyn2J&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXPFB5WQP%2F20261022%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261022T160409Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=32e761474905759ad5e2212d19994a6aff341f818849b03bd9d1f93cb487e236 400w\" sizes=\"(max-width: 418px) 100vw, 418px\" \/><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>Type your commands in the top panel<br \/>\n<em>Use ctr+mousewheel to enlarge text<\/em><\/li>\n<li><img decoding=\"async\" class=\"alignnone size-full wp-image-387\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25135927\/DB4SQL-execute-sql2.png\" alt=\"\" width=\"616\" height=\"348\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25135927\/DB4SQL-execute-sql2.png 616w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25135927\/DB4SQL-execute-sql2-300x169.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELD%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQDnqdD%2Fq%2Be6%2Bb%2FOV6pVLjTeM1XUUtcIw4NYtnpED9oatQIhAPIJsw0YC9sTxTC9xOyzknREJndrxjEM%2FJNSlHqwSAYWKrkFCHkQBRoMMjczNTcwMTk1NDMzIgwUtJTz1AQcO8gf%2BbUqlgWA5lhQGnlnj7oOfDLQaCbhKMFBzemKVNO2QYep87vpKNAAPb9aAc%2FyzwGK7EoqB7Q%2BZjJFh8wpdO%2B3IeXyjPUTV63SgGopTb%2Bcr0CygV%2BTobaZCb1hmrqG%2B1so9cEZ0t%2FQo3ZMK7MzpfdRgqmGchujmYoflKrGYXQN1OaU0dXtuXqJtyapdwFmOwdA1EYm81BLiIG0iBbxywQzl32KYBgi0kD0KBfBVhkZ9hRiIMEh4dTpnOm3cpwnQ9StNCaxy9nuOYfdNkKWmU%2Fz6JT%2Fc25Kaj0BXck2cY1Qwr4i2vHe7uUcr0t9j%2F36LcWkVCwcgC5nz5enMiuBzeSjEgpkUGxvZH4yNyYgFjRHIPjhncn6pJizJAe%2Buk58n2PaVmaiW7tql9492G0zK3Ht58YcaueAdSWBxSAoimGRxpc103W6PFVsJ7oLmG4sAyWhhbqqQIqQqCOBoSVduFh9Z0HZZFQBufCg5%2F%2Ff4J2yi2OGAvxhf%2FDM8fK6DSvXdFu7bR2Zdm5DwEm%2BGGmICHaI6FXiBDkaxTIuRqubcXaH8IRUsdjJ2%2BOV2EDEdZg17qy7bAv1qqz3sF7fGG8W6%2FX%2FsRxDi%2Fw4adIhNtXMMIAy42a9BkNp%2Bhj%2Bsab9xKGf4aocfw4RUC00Rzlc6EAA3yUPTC1FWQai81Xf8lKCmLE1chxjN1R%2BHO0vO3gAhaD5DeSnt1new4gd%2F59ocn6RRqUUA0KXqRnGsZB%2BmPsR0T71gShVVR0cBGt4zp1rdmJ1SjoHdORJrUpG4ahufU8IEG%2BE6FPn7NQJaZxWqmegPQwK7n8AbMv3qXHKA50SkwPVZ9vpV6gr5C8if64mRMdtu2nXsk1GdyzxxI2aVkwRSS5zfizWtvLNF8r1iRKwojDi3OjWBjqwATR1PZnuGPCYyxuwxq00GOQTzeGY6F5DNXSM0iS6P17S%2FrDGUCLBQhL0qdfoL0LgAvSEfTz4pcalYgihB27dpnSqU%2FFjwQgaQf8cAfm%2FAU%2Bv1V44BRNlHrOD%2Bmem6KjB4a1C9nuEr2SLx6BzYEpJ6A%2BzqYlWF1iN7jG7JHx%2FrH1lFimtt4zFSPG2mpecK4q%2Fnxb2w5PSLNmgEXSoch6qMpGkvJLHxoa0vsmicAtZyn2J&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXPFB5WQP%2F20261022%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261022T160409Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=db9ddb3ec014527ccd6b3f37fc189c17d98677915ba7e1e2461db5b5f28aff85 300w\" sizes=\"(max-width: 616px) 100vw, 616px\" \/><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Click the &#8220;Execute SQL&#8221; tab: &nbsp; Type your commands in the top panel Use ctr+mousewheel to enlarge text<\/p>\n","protected":false},"author":7,"featured_media":0,"parent":9,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-382","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/comments?post=382"}],"version-history":[{"count":4,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/382\/revisions"}],"predecessor-version":[{"id":389,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/382\/revisions\/389"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/9"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/media?parent=382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}