It is not a good idea to use the root MySQL account to do backups. So, let’s create a user dedicated exclusively to doing backups. Log on to MySQL as root: mysql -u root -p Then create the new user
Oracle – Change the behavior of ORDER BY
There are times when you would like to order the results of a query in such a way that it cannot be accomplished by the default behavior of the order by clause. For example, let’s look at the following table: