Skip to content

Category Archives: Node.js

Both process.stdout.write and console.log in NodeJS have basic functionality to display messages on the console. Basically console.log implement process.stdout.write while process.stdout.write is a buffer/stream that… Read More
LCASE() function is a built-in function in MySQL that is used to convert all characters of a given string to lowercase. Syntax: LCASE(input_string) Parameters: It… Read More
FIND_IN_SET() function is a built-in function in MySQL that is used to get the position of the first occurrence of value string in a list… Read More
INSERT() function is a built-in function in MySQL that is used to insert a string into another string at some position after deleting some characters… Read More
LOWER() Function is a Builtin function in MySQL which is used to convert all characters of given string to lowercase. Syntax: LOWER(input_string) Parameters: LOWER() function… Read More
INSTR() function is a built-in function in MySQL that is used to get the position of the first occurrence of pattern in the text. Note:… Read More
LPAD() Function is a Builtin function in MySQL which is used to attach a given string to text from left side till total length is… Read More
FIELD() function is a built-in function in MySQL that is used to get the position of the first occurrence of a value in a set… Read More
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
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