Built-in database functions allow for efficient filtering. This post will demonstrate that a simple date filter on the database side is almost twice as fast as filtering the result set on the application side.
One of the most common problems I come across is users not being able to resolve a basic SQL syntax error thrown in MySQL. You have an error in your SQL syntax; check the manual that corresponds to your MySQL… Continue Reading →
There may be a time where a software version is stored as a string. In order to sort it, it will need to be broken up into its individual parts (major, minor, patch and build) and then sorted.
I needed a way to do a daily backup of tables individually from a database. I accomplished this with a Windows batch script.