SQL Articles
- Database Upgrade Problems! MySQL 5 → 8 with WordPress My webhost upgraded their database server from MySQL 5 to 8. The upgrade itself went smoothly, but I did find some after-effects on my WordPress sites
- Dates and ColdFusion Query of Queries ColdFusion’s Query of Queries is very particular about the format of dates on both sides of the comparison.
- First Stab at WordPress/MySQL Tuning (Obsolete) My job sent me to a class on scaling, optimizing and troubleshooting MySQL this week.
- Groovy, null, and ‘null’ Sometimes you get a null value, and sometimes you get the word null. Make sure it checks the one you expect!
- How to get Grails to use a reserved word with Microsoft SQL You can use a custom database mapping from reserved to [reserved].
- Moving WordPress: Finding and Updating Old Paths How to find every last reference to the old path in the entire site and config because WordPress stores absolute paths all over the place and some configurations will break if you don’t update it.
- WordPress 5.7 Upgrade Breaks Posts with Emoji in the Title? Posts with emoji in the title mysteriously stopped displaying anywhere on the blog except the edit form, possibly due to mismatched character sets.