Zac Anger's Blog

SQL/RDBMS

28 January, 2016

Queries

These will be in SQLite, specifically.

SELECT * FROM foo_bar
SELECT quux,baz FROM foo_bar
/* find this thing in that table */
SELECT * FROM what WHERE things = 'stuff'
/* WHERE is a simple conditional */

Joins

This is a big deal, so it gets its own subsection.

Aaaandd... my brain kinda hurts. That's enough of that. Here are a couple of resources for learning the basics of relational databases:

Submit a bug report