Incorrect usage of UNION and ORDER BY

Last Updated on: October 11, 2022 Security is an essential consideration for any computer system and MySQL is no exception to this rule. One big security problem that administrators can often overlook is obsolete accounts. These accounts were created for people who no longer use them and are big security holes waiting to be found….

Last Updated on: September 16, 2022 One of the most valuable additions to MySQL 5 is the subquery, which lets you execute SQL like this: Unfortunately, MySQL 4 lacks this feature and is still prevalent in many web hosts. If you need to use a subquery, try the following workaround in PHP; Step by step:…

Working with dates and times in MySQL is straightforward and there are several MySQL functions to do the calculations for you. Some of the most common requirements are to calculate the current date and time, and this can be done with the CURRENT_DATE() and NOW() functions like this: Sometimes you might want to extract some…

Last Updated on: October 11, 2022 On a standard MySQL installation, remote access is disabled by default. This is great if you are sitting next to your server but generally inconvenient if you are not. With the advent of modern support teams spanning the globe, it is entirely possible to administer a server that is…

Last Updated on: September 15, 2022 One of the most critical tasks for a MySQL administrator is reliably backing up and restoring databases. This, of course, helps to prevent data loss in the event of a hardware failure, data corruption… or a little accident. Most modern hosting/server solutions have some kind of database backup solution…

Last Updated on: March 13, 2011 One of the best ways to check the performance of your MySQL application is to benchmark it regularly. Put the application under as much load as you can to simulate the worst possible reasonable load and check the performance. Several functions within MySQL can help you to test your…