In MySQL, select statements use order to sort by row, and mysqlorder

In MySQL, select statements use order to sort by row, and mysqlorder

This article describes how to execute the select query statement in the MySQL database and sort the query results using the order by clause.

Let's review the select statement syntax in the SQL statement:

Basic syntax of the Select statement:

Select <column set> from <Table Name> where <condition> order by <sorting field and method>

To sort the query results by a field, use the order by clause as follows:

Select * from <Table Name> order by <field Name> <sorting method>

The following two examples show that the first query of all the data in the test table is in the forward order of t_id. The second query is in the reverse order of the first one.

Mysql> select t_id, t_name from test order by t_id;
+ ------ + -------- +
| T_id | t_name |
+ ------ + -------- +
| 1 | name1 |
| 2 | name2 |
+ ------ + -------- +
2 rows in set (0.00 sec)

Mysql> select t_id, t_name from test order by t_id desc;
+ ------ + -------- +
| T_id | t_name |
+ ------ + -------- +
| 2 | name2 |
| 1 | name1 |
+ ------ + -------- +
2 rows in set (0.00 sec)

Note: In positive order sorting, asc can be used as the keyword of the sorting method or not. In reverse order, desc must be used as the keyword.

This article describes how to sort the select statement in MySQL by order in rows. I hope it will be helpful to you. Thank you!