Node.js Connect Mysql with Node app

Node.js MySQL Order By Clause

Last Updated : 07 Oct, 2021

Introduction: We use the SQL ORDER BY Clause to sort the data with respect to some column value in ascending or descending order.

Syntax:

SELECT * FROM users ORDER BY name; This will sort all rows of output in ascending order (by default) with respect to name column. SELECT address FROM users ORDER BY name DESC; This will sort all rows of output in descending order with respect to name column but return the data of address.

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

npm install mysql

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

Example 1: Select all columns from the users table but sort them by name in ascending order.

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

    // Our Query
    let query = 'SELECT * FROM users ORDER BY name';

    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: Select only the address column from the users table but sort them in descending order of name.

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 address column and DESC below
    let query = 'SELECT address FROM users ORDER BY name DESC';

    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 Connect Mysql with Node app

P

pratikraut0000

Improve

Article Tags :

Similar Reads

PHP | MySQL ORDER BY Clause

The ORDER BY Clause can be used along with the SELECT statement to sort the data of specific fields in an ordered way. It is used to sort the result-set in ascending or descending order. Syntax : The basic syntax of the Order By clause is - Implementation of the Order By Clause : Let us consider the

Node.js MySQL Limit Clause

LIMIT Clause is used to set the maximum size of the number of rows in the output of SQL Query. Syntax: Select only 3 rows from 1st row of users table. SELECT * FROM users LIMIT 3 Select only 3 rows from the 2nd row of the users table. SELECT * FROM users LIMIT 3 OFFSET 1 Modules: mysql: To handle My

Node.js MySQL Create Table

Introduction: Learn to create a table in MySQL database using NodeJS. We will see how to use the Create Table command in NodeJS using the MySQL module. Prerequisite: Introduction to NodeJS MySQL Setting up environment and Execution: Step 1: Create a NodeJS Project and initialize it using the followi

Node.js MySQL Delete Query

We use SQL DELETE Query to delete data with some condition from MySQL Table. Syntax: This will delete all rows of customers' tables but everything else will remain as it is (indexing, etc). DELETE FROM users This will delete all rows of users table where userId is 2. DELETE FROM users WHERE userId =

Node.js Connect Mysql with Node app

Node.js is a powerful platform for building server-side applications, and MySQL is a widely used relational database. Connecting these two can enable developers to build robust, data-driven applications. In this article, we'll explore how to connect a Node.js application with a MySQL database, cover

Node.js MySQL OR Operator

NodeJs: An open-source platform for executing javascript code on the server-side. Also, a javascript runtime built on Chromeâ€™s V8 JavaScript engine. It can be downloaded from here. Mysql An open-source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). It is the

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 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

Node.js MySQL Insert into Table

NodeJs: An open-source platform for executing javascript code on the server side. Also, a javascript runtime built on Chromeâ€™s V8 JavaScript engine. It can be downloaded from here. MysqlÂ An open-source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). It is th

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