what is write way to multiple sorting in mysql

Question

how i can use multiple sorting in mysql

ORDER BY PARAM1 , PARAM2

or

ORDER BY PARAM1 AND PARAM2 AND PARAM3 DESC

what is write way to sorting in mysql

Answer 1

The first one is correct.

Answer 2

From Mysql Select Syntax you can see that that the correct syntax for using ORDER BY is:

[ORDER BY {col_name | expr | position}
[ASC | DESC], ...]
            ^
comma separated

So your first option is correct.

Answer 3

ORDER BY field1, field2, ...