SQL by example

Setup

Install extended version of hugo.

• Run development server: hugo server.
• Create a new post: hugo new --kind post posts/<post-name>.md

TODO

• SELECT

• WHERE

• INSERT

• UPDATE

• DELETE

• ORDER BY

• GROUP BY

• AND, OR, NOT

• LIMIT

• Comments

• MIN, MAX

• COUNT

• SUM

• AVG

• AS (Alias)

• LIKE

• SELECT DISTINCT

• IN

• BETWEEN

• JOIN

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

• CROSS JOIN

• UNION

• WITH

• HAVING

• EXISTS

• ROUND

• ANY

• ALL

• CASE

• NULL

• ALTER TABLE

• TRUNCATE

• SIMILAR TO https://www.postgresql.org/docs/16/functions-matching.html

• Operators

• Constraints

• Unique

• Primary key

• Index

• Default

• Auto increment

• Dates and times

License

Licensed under the MIT License