Node.js MySQL SUM() Function

Node.js MySQL TRIM() Function

Last Updated : 07 Oct, 2021

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: It takes one parameter as follows:

string: It is the string to be trimmed from both sides.

Return Value: It returns string after trimming from both sides.

Module Installation: Install the mysql module using the following command:

npm install mysql

Example 1: Hard-Coded Query

index.js

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 TRIM('   Geeks For Geeks   ') AS TRIM_Output`;

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

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

Run the index.js file using the following command:

node index.js

Output:

Example 2: Dynamic Query

index.js

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");

    // Notice the ? in query
    let query = `SELECT TRIM(?) AS TRIM_Output`;
    
    // Dynamic Input
    let input_string = "    Pratik Raut   ";

    // Notice Second Dynamic Parameter
    db_con.query(query, input_string, (err, rows) => {
        if(err) throw err;

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

Run the index.js file using the following command:

node index.js

Output:

Node.js MySQL SUM() Function

P

pratikraut0000

Improve

Article Tags :

Similar Reads

Node.js MySQL SUM() Function

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 as mentioned above and described below. column_name: Columnâ€™s name from which we have to return the max value. Module Installation: Install the m

Node.js MySQL SUBSTRING() Function

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, length)Parameters: It takes three parameters as follows: input_string: It is the given string for which the substring will be exec

Node.js trim() function

The trim() function is a string function of Node.js which is used to remove white spaces from the string. Syntax: string.trim() Parameter: This function does not accept any parameter. Return Value: The function returns the string without white spaces. The below programs demonstrate the working of tr

Node.js MySQL UPPER() Function

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 takes one parameter as follows: input_string: It is the given string that is passed for conversion to uppercase.Return Value: It returns a

Node.js MySQL POSITION() Function

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 from specific position. Note: It is not Case Sensitive. Syntax: POSITION(pattern IN text) Parameters: POSITION() function accepts two parameters as mentioned abov

Node.js MySQL UCASE() Function

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 takes one parameter as follows: input_string: It is the string that is passed for converting this string to uppercase.Return Value: It retu

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

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 AVG() Function

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 a single parameter as mentioned above and described below. column_name: Columnâ€™s name from which we have to return the average value. Module Inst

Node.js GM trim() Function

The trim() function is an inbuilt function in the GraphicsMagick library which is used to remove edges that are exactly the same color as the corner pixels. The function returns the true value of success.Â Syntax: trim() Parameters: This function does not accept any parameters.Â Return Value: This f