What is asc in mysql?

Answer 1

ASC = ascending order ( 1 -> 10) - ( A -> Z)

DESC = Descending order (10 -> 1) - (Z - A)

Given sample int data and using SORT ASC:

Data: 5 2 1 3 4

Output:
1
2
3
4
5

Same with names
Data:
a c b d

Output:
a
b
c
d

DESC will do the opposite

Data: 1960 1990 1977 2005

Output:

2005
1990
1977
1960

Answer 2

'asc' is for sorting in ascending order.
'desc' is for sorting in descending order.

But you must always use a column name with it for it work. Eg-

Order by column_name desc;