在javascript中显示两个数据库记录的总和

// 连接数据库
const mysql = require('mysql');
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'username',
  password: 'password',
  database: 'database_name'
});

connection.connect();

// 查询数据库
const query = 'SELECT value FROM records WHERE id IN (1, 2)';
connection.query(query, (error, results) => {
  if (error) throw error;

  // 计算总和
  const sum = results.reduce((total, record) => total + record.value, 0);

  // 显示结果
  console.log('总和：', sum);
});

connection.end();