nodejs创建后一天检查并更新数据库字段

const mysql = require('mysql');

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

// 连接数据库
connection.connect();

// 查询需要检查的数据字段
const query = 'SELECT * FROM mytable';
connection.query(query, (error, results, fields) => {
  if (error) throw error;

  // 遍历查询结果
  results.forEach((row) => {
    const createTime = row.create_time;
    const currentTime = new Date();
    const oneDay = 24 * 60 * 60 * 1000; // 一天的毫秒数

    // 计算时间差
    const diffDays = Math.round(Math.abs((currentTime - createTime) / oneDay));

    // 判断是否满足更新条件
    if (diffDays >= 1) {
      // 更新数据库字段
      const updateQuery = `UPDATE mytable SET myfield = 'new value' WHERE id = ${row.id}`;
      connection.query(updateQuery, (error, results, fields) => {
        if (error) throw error;
        console.log(`Updated field for id ${row.id}`);
      });
    }
  });
});

// 关闭数据库连接
connection.end();