What is the default sort order in MySQL tables?

The default sort order in MySQL tables is ascending. Whenever we use ORDER BY clause to sort out the rows of a table, MySQL gives output in ascending order, with the smallest value first. Consider the following example from a table named ‘student’ −

mysql> Select * from student order by name;
+--------+--------+--------+
| Name   | RollNo | Grade  |
+--------+--------+--------+
| Aarav  | 150    | M.SC   |
| Aryan  | 165    | M.tech |
| Gaurav | 100    | B.tech |
+--------+--------+--------+
3 rows in set (0.00 sec)

We can see the query above gives the output, ordered by name, in ascending order, start with smallest value ‘Name’ column.

Rishi Rathor

Published on 21-Feb-2018 12:57:21

• Related Questions & Answers
• How can I change the default sort order of MySQL tables?
• What Is the Default MySQL Port Number?
• Is there a default ORDER BY value in MySQL?
• How to get the list of tables in default MySQL database?
• Implement Custom Sort Order in MySQL
• What is the alias to Show Tables in MySQL Result?
• What is the Default Gateway?
• MySQL show tables sort by table name?
• What is the default type of a hexadecimal value in MySQL?
• What is the use of ORDER BY clause in MySQL?
• What is the default constructor in C#?
• What is the use of OPTIMIZE TABLE statement in maintaining the MySQL tables?
• What is the use of CHECK TABLE statement in maintaining the MySQL tables?
• Call aggregate function in sort order with MySQL
• What is the purpose of ORDER BY columnname*1 in MySQL?