Zac Anger's Blog



Tags: db, rdbms, sql, sqlite


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 */


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: * SQL Teaching * Stanford's Free Online Mini-Courses