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.
Fixing MySQL "Incorrect string value": utf8 vs utf8mb4 Done Right
Posted by Kyle Hankinson
MySQL rejects emoji with error 1366 because utf8 is really the 3-byte utf8mb3. How to safely convert to utf8mb4 across every layer without breaking indexes.
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.