Over the years I’ve used many different hosting solutions. From shared hosting, a dedicated server, to several VPSes. These all came with a graphical control panel, most often Plesk, from which the server could be administered. The downside was the cost of the licence. So a little while ago I took the plunge and purchased …
Continue reading ‘Configuring A General-Purpose Ubuntu 14.04 Server’ »
Did you ever save dates as a string when you were a n00b? OK I’ll admit it, I did! Want to convert them to DATE or DATETIME fields now? Read on!
There is more than one way to copy a table in MySQL, but if you want to include column attributes and indexes defined in the original table you’ve got to choose the correct one!
MySQL tables can crash. Learn how to repair them!
Usually our SQL queries use JOINs in SELECT queries. But what about if you want to DELETE using a JOIN? It’s not as straightforward.
Ever need to order an SQL query by the surname/last name of a user, but their full name is all one single field? Here’s how to use some of MySQL’s string function to do just that!
MySQL can do far more than just insert, update and select data. In fact the world’s most popular open source database has a whole host of incredibly useful functions built in that you might never know about until you find one day that you need them – and then you wonder how you coped without them!
The MySQL relational database management system (RDBMS) supports a wide range of data types. The data type that you chose for your table columns is important because it determines how MySQL will store your data. It’s possible that any one of multiple data types could be used to store a piece of data, but which one is the best or optimal data type to use?