You’ll encounter errors with MySQL frequently when working with development or administration for a variety of reasons. The configuration file settings, parameter variable restrictions, poorly
Category: MySQL
MySQL Functions
Below is a quick reference list for the MySQL Functions descriptions and usage examples that have already been posted on this site. You can search
NULLIF in MySQL
When the given two expressions are equal, the NULLIF() function compares them and returns NULL. If not, the first expression is returned. Examples: SELECT NULLIF(34,
SQL Server ISNULL equivalent in MySQL
One of the often used functions in SQL Server is ISNULL, which aids in replacing the null values of a column with an alternative value.
IFNULL in MySQL
If the expression is NULL, the IFNULL() function returns a specified alternative value. This function returns the expression if it is NOT NULL. This function
SUBTIME in MySQL
The SUBTIME() function subtracts a given time from a specified time or DateTime expression and then returns the resulting time/DateTime. Syntax: SUBTIME(datetime, time_interval) Note that
Big Data & SQL 