The PASSWORD() function in MySQL can generate a hash value for encrypted passwords, similar to md5() in PHP. It is generally not recommended to use this function in an application as it is not particularly secure – it is intended for internal use. If, however, your application uses the MySQL PASSWORD() function, you need to…
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…
