Node.js MySQL SUM() Function

Node.js MySQL AVG() Function

Last Updated : 07 Oct, 2021

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 Installation: Install the mysql module using the following command.

npm install mysql

Database: Our SQL publishers table preview with sample data is shown below:

Example 1:

index.js

const mysql = require("mysql");

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

db_con.on('error', (err) => {
    console.log(err.code);
});

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

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

    // Here is the query
    let query = "SELECT AVG(salary) AS avg_salary FROM publishers";

    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:

index.js

const mysql = require("mysql");

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

db_con.on('error', (err) => {
    console.log(err.code);
});

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

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

    // Here is the query
    let query = "SELECT AVG(salary) AS avg_salary 
                 FROM publishers WHERE id < 8";

    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:

Node.js MySQL SUM() Function

P

pratikraut0000

Improve

Article Tags :

Similar Reads

Node.js MySQL FORMAT() Function

FORMAT() function is a built-in function in MySQL that is used to format input numbers in the format of ...**, ***, *** also, round float numbers to a specific number of decimal places. Syntax: FORMAT(number, number_of_decimal_places)Parameters: It takes two parameters as follows: number: The number

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

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

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

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 of expressions. In the case of string values, it is not case-sensitive. Syntax: FIELD(value, input_1, input_2, input_3, ...)Parameters: It takes two parameters as follows: va

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

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, string_2, ...)Parameters: It takes two parameters as follows: separator: This separator will be used to concatenate strings.string

Node.js MySQL TRIM() Function

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 side