将当前日期和时间上传到mysql

var currentDate = new Date();
var currentDateTime = currentDate.toISOString(); // 将日期和时间转换为ISO 8601格式

var mysql = require('mysql');

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

connection.connect(function(err) {
  if (err) {
    console.error('Error connecting to MySQL database: ' + err.stack);
    return;
  }
  console.log('Connected to MySQL database as id ' + connection.threadId);

  var currentDate = new Date();
  var currentDateTime = currentDate.toISOString();

  var sql = 'INSERT INTO your_table (datetime_column) VALUES (?)';
  connection.query(sql, [currentDateTime], function(err, result) {
    if (err) {
      console.error('Error inserting data into MySQL database: ' + err.stack);
      return;
    }
    console.log('Data inserted into MySQL database');
  });

  connection.end();
});