Blog

Michael Sattler Archives

Javascript Constants — Fortresses Against Confusion

Constants are variables whose values can’t be changed. These are useful for creating immutable touchpoints for a...
const, javascript constants

SQL IFNULL — Hurdling Over Potholes

Relational databases store information in table cells — in columns that describe aspects of an item and...
ifnull, isnull, sql ifnull

SQL Union — Collections of Collections

Relational databases store information in table cells — in columns that describe aspects of an item and...
sql except, sql union, sql union all, sql union intersect

SQL Convert and SQL Cast — It’s All Back & Forth

Relational databases store information in table cells — in columns that describe aspects of an item and...
data types, sql cast, sql convert

SQL Insert Into — Everything Has Its Place

Relational databases store information in table cells — in columns that describe aspects of an item and...
insert into, sql insert into, sql insert into select. SQL

SQL Booleans — The True Will Set You Free

Relational databases store information in tables — in columns that describe aspects of an item and rows...
and, not, or, sql boolean, sql booleans
123456…9