MySQL

A common problem using the UNION command in MySQL is when you want to order data sets differently. If you do it incorrectly, you will see the error message: Incorrect usage of UNION and ORDER BY To solve the problem, wrap each SELECT statement in parenthesis as follows: Nice and simple; all you have to…

If you’ve ever had to transfer a large MySQL database, you know it can be a real pain. phpMyAdmin is the go-to for most web hosts, but when it comes to importing that massive SQL dump, it can be a big time-waster. Timeouts and errors are all too common when you’re trying to import data…