无法使用node-mysql进行分页

const mysql = require('mysql');

// 创建数据库连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

connection.connect();

// 分页参数
const page = 1; // 当前页码
const limit = 10; // 每页显示的记录数

// 计算偏移量
const offset = (page - 1) * limit;

// 构建分页查询语句
const sql = `SELECT * FROM your_table LIMIT ${limit} OFFSET ${offset}`;

connection.query(sql, (error, results, fields) => {
  if (error) throw error;
  console.log(results);
});

connection.end();

const sql = 'SELECT * FROM your_table LIMIT ? OFFSET ?';
connection.query(sql, [limit, offset], (error, results, fields) => {
  if (error) throw error;
  console.log(results);
});

// 基于游标的分页示例
const lastId = 100; // 上一页最后一个记录的ID
const sql = `SELECT * FROM your_table WHERE id > ? ORDER BY id LIMIT ${limit}`;
connection.query(sql, [lastId], (error, results, fields) => {
  if (error) throw error;
  console.log(results);
});