Aggregates

Data comparison         Backslashes in data         Compare data in two tables         Show rows where column value changed

Database metadata         Add auto-incrementing primary key to a table         Auto-increment: reset next value         Change or drop a foreign key         Compare structures of two tables         Compare two databases         Database size         Find child tables         Find parent tables         Find primary key of a table         Find the size of all databases on the server         List databases, tables, columns         List differences between two databases         List users of a database         Rename Database         Replace text in all string columns of a database         Show

Date and time

Frequencies

Graphs and Hierarchies         Trees, networks and parts explosions in MySQL         Dijkstra’s shortest path algorithm         Tree query performance         Trees of known depth

JOIN         Approximate joins         Cascading JOINs         Classroom scheduling         Data-driven joins         Full Outer Join         Intersection and difference         Join or subquery?         Many-to-many joins         What else did buyers of X buy?

NULLs         List NULLs at end of query output         Parents with and without children

Ordering resultsets         Emulate Row_Number()         Next row         Order by leading digits         Order by month name         Order by numerics then alphas         Pagination         Suppress repeating ordering values

Pivot tables (crosstabs)

Relational division

Sequences

Spherical geometry         Great circle distance

Statistics without aggregates

Stored procedures         A cursor if necessary, but not necessarily a cursor         Emulate sp_exec         Variable-length argument for query IN() clause

Strings         Count delimited substrings         Count substrings         Levenshtein distance         Proper case         Retrieve octets from IP addresses         Return digits or alphas from a string         Strip HTML tags