the thread through every rung
a reading log
19 rungs
01 · make a place to put it
a table, and the columns it holds
first time you type
( ) , ;02 · put something in it
a row, and the text around it
first time you type
'03 · ask for it back
selecting columns, and all of them
first time you type
*04 · only the ones you want
a condition on the rows
first time you type
< >05 · a note to yourself
a comment
first time you type
-06 · in an order that helps
sorting, both ways
nothing new to reach for
07 · give it a better name
matching exactly, and renaming
first time you type
= _08 · titles that look alike
a pattern instead of an exact match
first time you type
%09 · anything but that one
not equal, written the SQL way
nothing new to reach for
10 · stick two things together
joining text end to end
first time you type
|11 · count them up
totals over every row
nothing new to reach for
12 · a second place to put things
another table, to point at the first
nothing new to reach for
13 · two tables at once
a join, and the dotted names it needs
first time you type
.14 · one row for each person
grouping, so each name appears once
nothing new to reach for
15 · only some of the groups
a condition on the groups themselves
nothing new to reach for
16 · when there is nothing to match
keeping the row anyway
nothing new to reach for
17 · change what is there
updating a row in place
first time you type
+18 · take it out again
deleting, and checking what is left
nothing new to reach for
19 · the whole thing
everything so far, answering one question
nothing new to reach for