Node.js is an open-source and cross-platform runtime environment built on Chrome’s V8 engine that enables us to use JavaScript outside the browser. Node.js helps us… Read More
Tag Archives: NodeJS-MySQL
We are going to use the query function in MySQL library in node.js that will return our output as expected. Using this approach, we can… Read More
POSITION() Function is a Builtin Function in MySQL which is used to get position of first occurrence of a pattern in a text when searched… Read More
Node.js is an open-source platform for executing JavaScript code on the server-side. It can be downloaded from here. MySQL is an open-source Relational Database Management… Read More
LEFT() Function is a Builtin function in MySQL which is used to get Prefix of a specific size of Given String. Syntax: LEFT(input_string, size_of_prefix) Parameters:… Read More
FORMAT() function is a built-in function in MySQL that is used to format input numbers in the format of …**, ***, *** also, round float… Read More
LENGTH() Function is a Builtin function in MySQL which is used to get length of given string in bytes. Syntax: LENGTH(input_string) Parameters: LENGTH() function accepts… Read More
LOCATE() Function is a Builtin function in MySQL which is used to get position of first occurrence of a pattern in a text when searched… 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
Courses
