Node.js MySQL LEFT() Function

Node.js MySQL LENGTH() Function

Last Updated : 07 Oct, 2021

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 a single parameter as mentioned above and described below.

input_string: We will get number of characters of this string

Return Value: LENGTH() function returns length of given string in bytes.

Modules:

mysql: To handle MySQL Connection and Queries

npm install mysql

SQL publishers Table Preview:

Example 1:

JavaScript

const mysql = require("mysql");

let db_con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "",
  database: "gfg_db",
});

db_con.connect((err) => {
  if (err) {
    console.log("Database Connection Failed !!!", err);
    return;
  }

  console.log("We are connected to gfg_db database");

  // here is the query
  let query = `SELECT LENGTH('Geeks for Geeks') AS length_in_bytes`;

  db_con.query(query, (err, rows) => {
    if (err) throw err;

    console.log(rows);
  });
});

Output:

Example 2:

JavaScript

const mysql = require("mysql");

let db_con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "",
  database: "gfg_db",
});

db_con.connect((err) => {
  if (err) {
    console.log("Database Connection Failed !!!", err);
    return;
  }

  console.log("We are connected to gfg_db database");

  // here is the query
  let query = `SELECT name, LENGTH(name) AS length_in_bytes FROM publishers`;

  db_con.query(query, (err, rows) => {
    if (err) throw err;

    console.log(rows);
  });
});

Output:

Node.js MySQL LEFT() Function

P

pratikraut0000

Improve

Article Tags :

Similar Reads

Node.js MySQL LEFT() Function

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: LEFT() function accepts two parameters as mentioned above and described below. input_string: We will get prefix of this input stringsi

Node.js MySQL CHAR_LENGTH() Function

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 takes one parameter as follows: input_string: It is the given string whose length is to be determined.Return Value: It returns a number

Node.js MySQL LTRIM() Function

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() function accepts a single parameters as mentioned above and described below. string: String needed to be trimmed from left side Return Value: LTR

Node.js MySQL LCASE() Function

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 takes one parameter as follows: input_string: Input string which is passed as a parameter to convert this string to lowercase.Return Value

Node.js MySQL LOWER() Function

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 accepts a single parameter as mentioned above and described below. input_string: We will convert this string to lowercase Ret

Node.js MySQL Min() Function

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 as mentioned above and described below. column_name: Columnâ€™s name from which we have to return the min value. Return Value: MIN()

Node.js MySQL LPAD() Function

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 equal to given value. If the given string is small then it is repeated multiple times. Syntax: LPAD(text, total_length, string) Parameters: LPAD() function accepts three

Node.js MySQL LOCATE() Function

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 from specific position. Note: It is Not Case Sensitive. Syntax: LOCATE(pattern, text, starting_position) Parameters: LOCATE() function accepts three parameters as m

Node.js MySQL CHARACTER_LENGTH() Function

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 takes one parameter as follows: input_string: We will get number of characters of this string.Return Value: It returns a numb

Node.js MySQL MID() Function

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) Parameters: MID() function accepts three parameters as mentioned above and described below. input_string: Substring of this input will b