Mysql order by null

Source: Internet
Author: User

Today, I found in mysql that there is such a select * from bb order by null sentence that cannot be seen, later, I found out that order by null is used to forcibly disable sorting of query results.

Order by null is used to forcibly disable sorting of query results. When you use explain to check the query statement, if the Extra column contains Using filesort, this has a certain impact on the performance, especially when Using group by, even if you do not display the specified order, mysql sorts data by grouping fields by default. In some cases, there is no need to use sorting. For example, when processing table report data (insert the original table data to a table for REPORT query after data statistics ), you can use order by null to cancel sorting. For example:

The Code is as follows: Copy code

Insert into reportTable (day, clicks, revenue)
Select day, count (*), sum (revenue) from clickOriginTalbe
Group by day
Order by null


In Order by, where is the Null value of MySQL? .

A:

In ASC, null is at the beginning, and desc is at the end.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.