Skip to content

Tag Archives: mysql

Sometimes we need to calculate population Standard deviation of an expression in MySQL. STDDEV() function can be used for this purpose in MySQL. It returns… Read More
TIMESTAMPDIFF() : This function in MySQL is used to return a value after subtracting a DateTime expression from another. Syntax : TIMESTAMPDIFF(unit,expr1,expr2) Parameters :  It… Read More
BIT_OR() function in MySQL is used to return the bitwise OR of all bits in a given expression. It first converts all decimal values into… Read More
This function in MySQL takes a dotted representation of an IPv4 or IPv6 address and returns a binary string that represents the numeric value of… Read More
STR_TO_DATE() : This function in MySQL helps to convert string values to date or time or DateTime values. The function will return zero (0000-00-00) if… Read More
STDDEV_POP() : This function in MySQL is used to calculate population standard deviation of an expression. Syntax : STDDEV_POP(expr); Parameter : This method accepts only… Read More
BIT_XOR() function in MySQL is used to return the bitwise XOR of all bits in a given expression. It first converts all decimal values into… Read More
This function in MySQL is used to return a “short” universal identifier as a 64-bit unsigned integer. The value of UUID_SHORT() is guaranteed to be… Read More
FROM_UNIXTIME() : This function in MySQL helps to return date /DateTime representation of a Unix timestamp. The format of returning value will be ‘YYYY-MM-DD HH:MM:SS’… Read More
UNIX_TIMESTAMP() : This function in MySQL helps to return a Unix timestamp. We can define a Unix timestamp as the number of seconds that have… Read More
LOCATE() function in MySQL is used for finding the location of a substring in a string. It will return the location of the first occurrence… Read More
INET6_NTOA() : This function in MySQL takes an IPv6 or IPv4 network address represented in numeric form as a binary string and it returns the… Read More
INET_NTOA() : This function in MySQL takes the IPv4 address in network byte order and then it returns the address as a dotted-quad string representation.… Read More
RLIKE : This operator in MySQL is used to performs a pattern match of a string expression against a pattern. Syntax : RLIKE pattern Parameters… Read More
A function is a special type of predefined command set that performs some operation and returns a single value. Functions operate on zero, one, two… Read More

Start Your Coding Journey Now!