Tag: SQL
Fundamental text manipulations in SQL
Learn practical MySQL string functions for cleaning, extracting, and combining text.
Common Table Expressions
A powerful SQL construct for structuring queries, recursion, and sequence generation.
Logical Keys in data
Use information_schema to learn about logical/business keys and find associations in messy schemas.
Explore Database with Information Schema
Use information_schema to inspect unfamiliar databases: tables, columns, foreign keys, and indexes, with an emphasis on what the metadata can and cannot reliably tell you.
Generate SQL with Information Schema
Use MySQL information_schema to inspect table metadata and generate dynamic SQL safely.