LTRIM() Function is a Builtin Function in MySQL which is used to trim all spaces from left side of input string. Syntax: LTRIM(string) Parameters: LTRIM()… Read More
Tag Archives: NodeJS-MySQL
We use the COUNT() function in MySQL to count a number of rows in a column satisfying the WHERE clause. Syntax: COUNT([column_name]) Parameters: COUNT() function… Read More
MID() Function is a Builtin Function in MySQL which is used to get substring of input string between given range inclusive. Syntax: MID(input_string, from, length)… Read More
We use AVG Function to get the average value of all rows in the given column of MySQL Table. Syntax: AVG([column_name]) Parameters: AVG() function accepts… Read More
CONCAT_WS() function is a built-in function in MySQL that is used to concatenate a set of strings with a commonly given separator. Syntax: CONCAT_WS(separator, string_1,… Read More
We use the SUM() function in MySQL to get Sum of the value of some columns. Syntax: SUM(column_name) Parameters: SUM() function accepts a single parameter… Read More
CHAR_LENGTH() function is a built-in function in MySQL that is used to get a number of characters in a given string. Syntax: CHAR_LENGTH(input_string) Parameters: It… Read More
CHARACTER_LENGTH() function is a built-in function in MySQL that is used to get a number of characters in a given string. Syntax: CHARACTER_LENGTH(input_string) Parameters: It… Read More
UPPER() function is a built-in function in MySQL that is used to convert all characters of a given string to uppercase. Syntax: UPPER(input_string) Parameters: It… Read More
TRIM() function is a built-in function in MySQL that is used to trim all spaces from both sides of the input string. Syntax: TRIM(string) Parameters:… Read More
UCASE() function is a builtin function in MySQL that is used to convert all characters of a given string to uppercase. Syntax: UCASE(input_string) Parameters: It… Read More
SUBSTRING() function is a built-in function in MySQL that is used to get a substring of input string between given range inclusive. Syntax: SUBSTRING(input_string, from,… Read More
We will be using Max() function in MySQL to get Maximum value of some particular column. Syntax: MAX(column_name) Parameters: MAX() function accepts a single parameter… Read More
In this article, will learn to handle NULL values and make Query on the basis of NULL values. Syntax: IS NULL; IS NOT NULL; Return… Read More
We will be using Min() function in MySQL to get Minimum value from some particular column. Syntax: MIN(column_name) Parameters: MIN() function accepts a single parameter… Read More
