MySQL Multi-field order by usage

Today, operation and maintenance of the data show added processing identity sorting function, see the code found that the original order by, is in reverse order of the ID, it is necessary to sort two fields at the same time.

Added a parameter to try, the results of an error .... Later found a comma is missing ...

In MySQL, we can use the ASC or DESC keyword to set the query result to be sorted in ascending or descending order. By default, it is sorted in ascending order .

The order by can be added 2 fields, separated by commas,

such as a in ascending order, b descending, SQL should write this way, order by a ASC, b desc; it can also be written as follows: Order by a, b desc;
If all in descending order, must use two desc, order by A Desc, B desc;

MySQL Multi-field order by usage