Shulou(Shulou.com)06/01 Report--

This article will explain in detail what order refers to in MySQL. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Mysql is a relational database, which has many keywords for users to use to manipulate data, such as order, which I will introduce to you today. It is generally expressed in the form of order by in mysql.

When you use the select statement to query data from a table, the result sets are not sorted in any order. To sort the result set, use the ORDER BY clause. The ORDER BY clause allows you to:

Sorts the result set by single or multiple columns.

Sorts the result set of different columns in ascending or descending order.

The syntax of the ORDER BY clause is described below:

SELECT column1, column2,...FROM tblORDER BY column1 [ASC | DESC], column2 [ASC | DESC],...

ASC stands for ascending order and DESC for descending order. If no collation is specified, the order by clause sorts the result set in ascending order by default.

So much for sharing what order refers to in MySQL. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.