Example
Return the current user name and host name for the MySQL connection:
SELECT SYSTEM_USER();
Definition and Usage
The SYSTEM_USER() function returns the current user name and host name for the MySQL connection.
Syntax
SYSTEM_USER()
Tag: difference in mysql
MySQL MAKETIME Function
Example
Create and return a time value based on an hour, minute, and second value:
SELECT MAKETIME(11, 35, 4);
Definition and Usage
The MAKETIME() function creates and returns a time based on an hour, minute, and second value.
Syntax
MAKETIME(hour, minute, second)
MySQL DIV Function
Example
Integer division (10/5):
SELECT 10 DIV 5;
Definition and Usage
The DIV function is used for integer division (x is divided by y). An integer value is returned. Continue reading MySQL DIV Function