Skip to content
Related Articles

Related Articles

NodeJs MySQL Limit Clause
  • Difficulty Level : Hard
  • Last Updated : 08 Feb, 2021

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 MySql Connection and Queries
npm install mysql

SQL users table preview:



Example 1: Select 3 rows from 1st row of users table

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 our query
    let query = 'SELECT * FROM users LIMIT 3';
  
    db_con.query(query, (err, rows) => {
        if(err) throw err;
  
        console.log(rows);
    });
});

Output:

Example 2: Select 4 rows from 4th row of users table

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");
  
    // notice offset is 3, this means choose from row 4
    let query = 'SELECT * FROM users LIMIT 4 OFFSET 3';
  
    db_con.query(query, (err, rows) => {
        if(err) throw err;
  
        console.log(rows);
    });
});

Output: There are only 3 rows from 4th row. so, output contains only 3 rows

My Personal Notes arrow_drop_up
Recommended Articles
Page :