Today I Learned

Today I learnt that MySQL's 'not equal' operator (!= or <>) does not match null values unless you are specifically doing a comparison on a null value.

Semver is a popular way of versioning applications and software libraries. However, if you use git tag to list out all your tagged versions of a Git repository you’ll probably find the tags returned are not listed in the expected order. That’s because by default Git uses lexicographic order, also known as dictionary or alphabetical order. Therefore, 1.10.0 will come before 1.2.0 when listing the tags in ascending order.

Did you know that if you mistype a Git command you can automatically run the suggested fix? I’ve been using Git for many years now and only just come across this feature today. To enable it you need to assign a value to the config setting help.autocorrect.