SQL

5/14/21
SQL output without a table using VALUES syntax
1/20/20
Common Table Expression (CTE) aka WITH clause
12/27/19
Window Function - an old SQL standard that is now available in MySQL
5/3/17
Extract JSON elements from a JSON column (MariaDB, MySQL)
5/2/17
Create a json object from your table columns
6/23/16
Not equal where condition on index as a performance problem
9/19/15
SQL Row-Value constructor in a Where-clause
7/20/15
Prevent a temporary DB table caused by SQL group by
5/11/15
Doing math in SQL can ignore indices
5/7/15
Even LIKE can use an index in SQL. It depends on the wildcard.
4/23/15
Combined indexes may not work with OR. Try an index_merge in MySQL
4/10/15
How to make MySQL using an index only by adding "order by"
4/4/15
Instead of MySQL's IFNULL function, this works on PostgreSQL, Sqlite and others too
3/29/15
Getting row counts of different columns in one query in MySQL