SQLPro for MySQL Blog
Tips, tutorials, and updates for MySQL and MariaDB.
SQLPro Keyboard Shortcuts
Posted by Kyle Hankinson
The full list of default keyboard shortcuts in SQLPro for MySQL on macOS and Windows, which actions ship unassigned, and how to rebind any of them from Preferences.
SQL NULL traps: = NULL, NOT IN, and sort order
Posted by Kyle Hankinson
WHERE col = NULL matches nothing, one NULL empties a NOT IN query, and engines sort NULLs differently. How to spot and fix SQL's three classic NULL traps.
Fixing MySQL Error 1055 (ONLY_FULL_GROUP_BY) Without Disabling It
Posted by Kyle Hankinson
MySQL error 1055 means your GROUP BY query is ambiguous. How to rewrite it with aggregates, ANY_VALUE, or window functions instead of disabling the mode.
Fixing "Authentication plugin 'caching_sha2_password' cannot be loaded"
Posted by Kyle Hankinson
MySQL 8 changed its default authentication plugin and broke older clients. How to fix caching_sha2_password errors correctly on MySQL 8.0, 8.4, and 9.
SQL Window Functions: SUM, AVG, LAG, and LEAD
Posted by Kyle Hankinson
Master SQL window functions with practical examples for running totals, moving averages, and row-to-row comparisons.