search

gvwilson / sql-tutorial

The Querynomicon: An Introduction to SQL for Wary Data Scientists
https://gvwilson.github.io/sql-tutorial/
Other
418 stars 35 forks source link

blob section is missing the SELECT query #30

Closed simonw closed 5 months ago

simonw commented 5 months ago

This bit here: https://gvwilson.github.io/sql-tutorial/#blobs

CleanShot 2024-02-06 at 15 26 17@2x

I think it's missing the select name, length(content) from images; query.

simonw commented 5 months ago

Or maybe that's deliberate?

https://github.com/gvwilson/sql-tutorial/blob/ace4f26d02467fbd4f043a7116d9fab7757e732b/src/blob.sql#L1-L15

The -- end tag comes before that SELECT query.

gvwilson commented 5 months ago

It was deliberate - I've omitted quite a few "select whatever to illustrate state of DB" queries from examples to keep things short - but I accept it's confusing. Fix coming.