Incorrect usage of UNION and ORDER BY

MySQL can support large databases, but as the size of the data grows, the performance of your database can start to suffer. As a database administrator, there are a few things that you can do to improve the performance of your databases. The first place to start is with your hardware. As MySQL uses many…

Before you get going with your next big project, you’re going to have to create a database for it to use. Here’s a quick guide on the few different ways that you can create a database. The first method that you can use is a helper script. A really popular one for MySQL is phpMyAdmin….

Even the best MySQL implementation will sometimes have problems with processes taking too long and hogging the CPU and memory. This will have a knock-on effect on any other processes running on the server and can have a significant effect on performance. In an ideal world, you could just increase the resources available to the…

Setting up indexes is essential to keeping your queries nice and quick. Adding an index is easy – if you’re using phpMyAdmin, just find your table, click “Create an Index” and choose your column or columns. Adding the right indexes is not easy and can be a bit hit-and-miss. This is where the handy EXPLAIN…

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. The user table stores user accounts,…

Once you’ve inserted data into your MySQL tables, you’re going to have to change it at one point. The type of query that you use to update data is called an UPDATE query. It is used to change the values in rows that already exist. The syntax for the query is as follows: {code type=sql}UPDATE…