POW Function:- POW Function is used for returning the value of a number raised to the power of another number. This function is similar to the POWER function. Syntax:- If base = b and exponent
Continue ReadingCategory: Science And Technology
MySQL Numeric or Mathematical Function Part4
LN Function:- LN Function is used for returning the natural logarithm of a given number. If the number will be zero or less than zero then it will return NULL. The EXP() is the opposite
Continue ReadingMySQL Numeric or Mathematical Function Part3
DEGREES Function:- DEGREES Function is used for converting radian value into a degree. Syntax:- DEGREES(radian value) For Example:- SELECT DEGREES(PI()/2); Output:- 90 SELECT DEGREES(1.57079); Output:- 89.99963750135457 SELECT ROUND(DEGREES(1.57079)); Output:- 90 DIV Function:- DIV Function is
Continue ReadingMySQL Numeric or Mathematical Function Part2
AVG Function:- AVG Function is used for returning the average value of a given list of numeric values. Syntax:- AVG(List of numeric value) For Example:- SELECT * FROM Employee WHERE age > (SELECT AVG(age) FROM
Continue ReadingMySQL Numeric or Mathematical Function Part1
ABS Function:- The ABS Function is used for returning an absolute positive value. Syntax:- ABS(NUMBER) For Example:- SELECT ABS(47.5); output:- 47.5 SELECT ABS(-47.5); output:- 47.5 ACOS Function:- ACOS Function is used for returning arc cosine
Continue ReadingMySQL String Functions Part-6
RPAD Function:- RPAD Function is used for adding string on the right side of the original string. Syntax:- RPAD(string, length, pad string) For Example:- SELECT RPAD(“kshtutor”, 13, “^”); Output:- kshtutor^^^^^ SELECT RPAD(“kshtutor”, 12, “srkp”); Output:-
Continue ReadingMySQL String Functions Part-5
MATCH Function:- The MATCH Function is used for full-text searches. It performs a case-insensitive search. It is required to make a full-text index on the table before performing a full-text search. InnoDB and MyISAM engine
Continue ReadingMySQL String Functions Part-4
LCASE Function:- LCASE Function is used to convert strings in lowercase. LOWER() and LCASE() both perform the same task. We can say LCASE() is a synonym of LOWER(). Syntax:- LCASE(string) For Example:- SELECT LCASE(“MySQL is
Continue ReadingMySQL String Functions Part-3
ExtractValue Function:- ExtractValue Function is an XML function in MySQL. It retrieves data from XML content. It takes two arguments, the first argument will be text CDATA and the second argument will be Locator. Syntax:-
Continue ReadingMySQL String Functions Part-2
CONCAT Function:- CONCAT function adds or concatenate two or more argument or expression. If any argument is a NULL value then It returns NULL. If any argument is a binary value It returns Binary. If
Continue Reading