MySQL

In this tutorial, we will study the MySQL RIGHT JOIN. A join is used to combine two or more tables using a commonly related column between them.  There are different types of joins in MySQL. They are – Inner Join Left (Outer) Join Right (Outer) Join Full Outer Join In this article, we will focus […]

In this tutorial, we will learn about the MySQL HOUR(), MINUTE() and SECOND() functions. The MySQL HOUR(), MINUTE() and SECOND() functions are a part of the date-time functions in MySQL. Suppose you have a datetime or time value and you want to know what hour of the day it is, or what is the minute

In this tutorial, we will study the MySQL LEFT JOIN. We saw what a join is in the INNER JOIN article but let us refresh our memory again. A join is used to combine two or more tables using a commonly related column between them.  There are different types of joins in MySQL. They are

In this tutorial, we will learn about the MySQL LOG() function. In an earlier article, we studied the LN() function which finds the natural logarithm of a function. We also studied the LOG2() and LOG10() functions that return the logarithm of a number to the base 2 and 10 respectively. But won’t it be easy

In this tutorial, we will study the MySQL DAYNAME() and MONTHNAME() functions. The MySQL DAYNAME() and MONTHNAME() functions are a part of the date functions in MySQL. Suppose you have a date value and you want to know what day of the week it occurred. For instance, you have the date – 2021-01-12 and you

In this tutorial, we will study the MySQL ATAN() and ATAN2() functions. In high school, you must have studied the arc tangent of an angle in trigonometry. Since trigonometry is so widely used across a number of fields, MySQL provides us with the MySQL ATAN() and ATAN2() functions. The ATAN() function is used to find

In this tutorial, we will learn about the MySQL COT() function. Cotangent or the ‘cot’ function is a trigonometric function that is used to find the cotangent of an angle. The cotangent of an angle is also the reciprocal of the tangent of an angle. Finding the cotangent of an angle is an important trigonometric

In this tutorial, we will study the MySQL ACOS() function. In maths, you must have come across the function – acos. The arc cosine of a number x is the inverse cosine function of x where x is a number between -1 and 1. It returns the angle whose cosine is a given number. Arc

In this tutorial, we will learn about the MySQL BIN(), OCT() and HEX() functions. As you would have known by now, computers do not understand the language of humans. They only understand 0s and 1s. Numbers in the computer language often have a base or radix, such that all numbers present in that number system

In this tutorial, we will study the MySQL DAY(), MONTH() and YEAR() functions. The DAY(), MONTH() and YEAR() functions are a part of the date functions in MySQL. The DAY() function is used to return the day of a month for a given date. As expected, the returned value is a numerical value from 1