MySQL: SESSION_USER Function
In this guide, we will explain how to use the MySQL SESSION_USER function with syntax and examples. Description The MySQL SESSION_USER function returns the user name and host name for the current…
MySQL: NULLIF Function
In this guide, we will explain how to use the MySQL NULLIF function with syntax and examples. Description The MySQL NULLIF function returns NULL if two expressions are equivalent. Otherwise, it returns…
MySQL: LAST_INSERT_ID Function
In this guide, we will explain how to use the MySQL LAST_INSERT_ID function with syntax and examples. Description The MySQL LAST_INSERT_ID function returns the first AUTO_INCREMENT value that was set by the…
MySQL: ISNULL Function
In this guide, we will explain how to use the MySQL ISNULL function with syntax and examples. Description The MySQL ISNULL function tests whether an expression is NULL. Syntax The syntax for…
MySQL: IFNULL Function
In this guide, we will explain how to use the MySQL IFNULL function with syntax and examples. Description The MySQL IFNULL function allows you to return an alternate value if an expression is NULL.…
MySQL: IF Function
In this guide, we will explain how to use the MySQL IF function with syntax and examples. Description The IF function returns one value if a condition evaluates to TRUE, or another…
MySQL: DATABASE Function
In this guide, we will explain how to use the MySQL DATABASE function with syntax and examples. Description The DATABASE function returns the name of the default database. Syntax The syntax for…
MySQL: CURRENT_USER Function
In this guide, we will explain how to use the MySQL CURRENT_USER function with syntax and examples. Description The MySQL CURRENT_USER function returns the user name and host name for the MySQL…
MySQL: CONVERT Function
In this guide, we will explain how to use the MySQL CONVERT function with syntax and examples. Description The MySQL CONVERT function converts a value from one datatype to another, or one…
MySQL: CONV Function
In this guide, we will explain how to use the MySQL CONV function with syntax and examples. Description The MySQL CONV function converts a number from one number base to another and…