{"pageProps":{"user":null,"pages":[{"id":8,"title":"Getting Started","slug":"getting-started","level":1,"parent_id":null},{"id":9,"title":"Getting Started","slug":"getting-started","level":2,"parent_id":3},{"id":2,"title":"Quick Start","slug":"quick-start","level":1,"parent_id":null},{"id":3,"title":"GUI Reference","slug":"gui-reference","level":1,"parent_id":null},{"id":4,"title":"API Reference","slug":"api-reference","level":1,"parent_id":null},{"id":10,"title":"Get","slug":"get","level":2,"parent_id":4},{"id":12,"title":"Database Reference","slug":"database-reference","level":1,"parent_id":null},{"id":11,"title":"Post","slug":"post","level":2,"parent_id":4},{"id":13,"title":"Data types","slug":"data-types","level":2,"parent_id":12},{"id":14,"title":"Querying Data","slug":"querying-data","level":2,"parent_id":12},{"id":15,"title":"Upload Media","slug":"upload-media","level":2,"parent_id":3}],"targetPage":{"title":"Querying Data","slug":"querying-data","description":"<p>Using SQL to query data from your database</p>","content":"<h2>Overview</h2><p>Querying data will eventually be the most common thing you do with your datasquirel account. So it's important to know some essential querying syntax, our node module abstraction will not give you the same level of control as direct sql querying.</p><h2>SELECT Keyword</h2><pre class=\"language-markup\">SELECT * FROM blog_posts</pre><p>The select keyword is the most basic and used keyword. In the example above, we're selecting every row(or entry) from the table <code style=\"display:inline\">blog_posts</code> . The \"*\" sign stands for \"all columns\". To dial down to specific columns, you can replace the \"*\" symbol with the column(s) you want to select. Example:</p><pre class=\"language-markup\">SELECT title, body FROM blog_posts</pre><p>This query only targets the <code style=\"display:inline\">title</code> and <code style=\"display:inline\">body</code> columns(or fields) in the <code style=\"display:inline\">blog_posts﻿</code> table.</p>"}},"__N_SSG":true}