How to get a scalar value from mysql in node.js?

1

npm install mysql

1

const mysql = require('mysql');

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_user',
  password: 'your_password',
  database: 'your_database'
});

connection.connect(function(err) {
  if (err) throw err;
  console.log('Connected to MySQL server');
});

 1
 2
 3
 4
 5
 6
 7
 8
 9
10

const query = 'SELECT COUNT(*) as count FROM your_table';

connection.query(query, function(err, results, fields) {
  if (err) throw err;
  
  // Access the scalar value
  const scalarValue = results[0].count;
  
  console.log('Scalar value:', scalarValue);
});

1
2
3
4

connection.end(function(err) {
  if (err) throw err;
  console.log('Connection closed');
});