Why is it good to write the numbers in MySQL INTERVAL() function in ascending order?

Actually, INTERVAL() function uses the binary search for searching the bigger number than the number at first argument. So, that is why if we want INTERVAL() function to work efficiently the list of numbers would be in ascending order. Following is a good way to use INTERVAL() function −

mysql> Select INTERVAL(50,20,32,38,40,50,55);

Chandu yadav

Published on 21-Feb-2018 10:13:32

• Related Questions & Answers
• MySQL command to order timestamp values in ascending order?
• What is MySQL INTERVAL() function?
• Why is it not good to sleep on the stomach for the whole night?
• Why is it not good practice to use date values with two-digits years in MySQL?
• Is it possible to divide records in both ascending and descending order in MySQL and display them alternatively?
• Order MySQL records randomly and display name in Ascending order
• MySQL command to order timestamp values in ascending order without using TIMESTAMP()?
• Is it possible to sort varchar data in ascending order that have both string and number values with MySQL?
• Sorting numbers in ascending order and strings in alphabetical order in an array in JavaScript
• How can we sort MySQL output in ascending order?
• Program to find the minimum cost to arrange the numbers in ascending or descending order in Python
• Check if it is possible to rearrange rectangles in a non-ascending order of breadths in Python
• Why it is better not to create numbers as objects in JavaScript?
• Select last 20 records ordered in ascending order in MySQL?
• Why is feedback necessary for good business?