SQL Help

Based on the SQL Help series David J. Lake published here in 2006 to 2009. Rewritten for MySQL 8 by the WeFixTech editorial team. The tutorials stay at their original addresses, which old forum threads still link to.

Each rewrite keeps the original question and updates the SQL for MySQL 8, including window functions and the replacements for SQL_CALC_FOUND_ROWS.

Choosing a SQL book

Retrieving the rows you actually want

Keys, IDs and duplicates

Schema design & data cleanup

Working with the mysql client

More MySQL topics

These tutorials were written for the archive by the WeFixTech editorial team.