MySQL Examples and Tutorials
In this tutorial, we will study the MySQL RADIANS() and MySQL DEGREES() functions. You must have come across radians and degrees as the two measures of angles in mathematics. The measures of angles are fundamental to geometry. Recommended read – MySQL SIN() and MySQL ASIN() functions Seeing this need, MySQL provides us with two functions …
MySQL RADIANS() and DEGREES() [With Easy Examples] Read More »
In this tutorial, we will learn about the MySQL LN() function. While studying maths, you must have come across the operation – loge (logarithm to the base of the mathematical constant e). Finding the loge of a number is also known as finding the natural logarithm of a number. Logarithm, in general, is a widely …
MySQL LN() Function – Easily find the natural logarithm of a number in MySQL Read More »
In this tutorial, we will study the MySQL ASIN() function. In maths, you must have come across the function – asin. The arcsine of a number x is the inverse sine function of x where x is a number between -1 and 1. Like all other trigonometric operations, asin is widely used and that’s why …
MySQL ASIN() – Find the arcsine of a number in MySQL Read More »
In this tutorial, we will learn about the MySQL SIN() function. While studying high school mathematics, you must have studied how to find the sine of an angle. Finding the sine of a number is an important trigonometric operation which finds use in mathematics, physics and so on. MySQL provides us with the SIN() function …
MySQL SIN() – How to find the sine of angles in MySQL? Read More »
In this tutorial, we will learn about the MySQL RAND() function. While working with MySQL, you will come across situations in which you would need a random number for certain operations. For this purpose, MySQL provides us with the RAND() function. The MySQL RAND() function is used to return a random floating-point number between 0 …
MySQL RAND() Function – Easily Generate Random Numbers in MySQL Read More »
In this tutorial, we will study the MySQL REPEAT() function. Suppose you have a string and for it to be presentable in your output, you want the string to be repeated a specific number of times. This is where the MySQL REPEAT() function comes into play. REPEAT() is used to repeat a string or an …
In this tutorial, we will learn about the MySQL EXP() function. While studying maths, you must have come across the exponential constant e. The exponential constant, given by the symbol e, is an important mathematical constant whose value is approximately 2.718. It is the base of natural logarithms. The exponential constant finds applications in maths …
MySQL EXP() – How to find the power of the exponential constant e in MySQL? Read More »
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 …