nodejs读写mysql数据库

npm install mysql

const mysql = require('mysql');

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

connection.connect();

connection.query('SELECT * FROM your_table', (error, results, fields) => {
  if (error) throw error;
  console.log(results);
});

connection.end();

const mysql = require('mysql');

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

connection.connect();

const sql = 'INSERT INTO your_table (column1, column2) VALUES (?, ?)';
const values = ['value1', 'value2'];

connection.query(sql, values, (error, results, fields) => {
  if (error) throw error;
  console.log('Inserted ' + results.affectedRows + ' row(s)');
});

connection.end();

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database',
  connectTimeout: 60000 // 设置连接超时时间为60秒
});