MySQL Examples and Tutorials
In this tutorial, we will learn about MySQL LPAD() and MySQL RPAD() functions in MySQL. Padding is the process of adding some unnecessary material in your strings, often to meet a minimum word count. Padding in MySQL can be very useful in formatting the output of a query. MySQL provides us with two padding functions …
MySQL LPAD() and RPAD() – Add Arbitrary Characters to a String Read More »
In this tutorial, we will learn about the MySQL FIND_IN_SET() function. The FIND_IN_SET() function is used to return the position of a string or a number from a list of strings or numbers. Suppose we have a list of strings and we want to find the position of ‘Hello’ in the string list. If ‘Hello’’ …
MySQL FIND_IN_SET() – Find Substring Positions using MySQL Read More »
In this tutorial, we will study about the MySQL ROUND() and MySQL TRUNCATE() functions. You must have studied rounding off to a certain decimal place while studying high school maths. Since it is such a common mathematical operation, MySQL provides us with the ROUND() function. The MySQL ROUND() function is used to round off a …
In this tutorial, we will learn about the MySQL FORMAT() function. In the real world, when you have to write one hundred thousand in figures, you write it as 100,000 and not as 100000. You use some form of formatting by adding the comma to make the number more readable. You must have observed so …
MySQL FORMAT() – How to format numbers in MySQL? Read More »
In this tutorial, we will learn about the MySQL LTRIM(), RTRIM() and TRIM() functions. Data in tables might not always be clean. By not being clean, I mean the values may have excessive spaces or other jargon or no value at all. Suppose you have a table containing Country names. When you take a look …
In this tutorial, we will learn about the MySQL FLOOR() and CEIL() functions. The FLOOR() function accepts a number or a numeric expression as an argument and returns the largest integer value that is less than or equal to the argument. For instance, if you pass 23.7 in FLOOR(), it will return you the largest …
In this tutorial, we will learn about the MySQL ABS() and the MySQL SIGN() functions. The ABS() function is used to find the absolute value of a number. The absolute value of a number is the non-negative value of the number. MySQL ABS() disregards the sign of a number and returns the result as a …
In this tutorial, we will study the MySQL PI() function. While studying maths in high school, you must have come across the value of 𝜋 known as Pi. The value of Pi is 22/7 or 3.142 up to three decimal places. Pi is used in a variety of mathematical calculations – geometry, calculus, and physics. …
MySQL PI() – Calculating Pi Value in MySQL [Simple Examples] Read More »
In this tutorial, we will study the MySQL DIV and MOD functions. As we saw in an earlier article, MySQL provides us with a variety of arithmetic functions. We will explore the DIV and MOD functions in this one. The MySQL DIV function performs the integer division of two numbers and returns the quotient. An …
MySQL DIV and MOD – Easy examples to find the quotient and remainder in MySQL Read More »
In this tutorial, we will learn about the MySQL SQRT() function. In high school maths, you must have come across exercises involving finding the square root of a number. Furthermore, square root finds applications across geometry, calculus, statistics, physics and many other domains which makes it one of the essential mathematical operations. For this reason …
MySQL SQRT() – Easy Way to Find the Square Root with MySQL Read More »