MySQL 与 Node.js

使用MySQL与Node.js进行数据库操作

javascript
npm install mysql

javascript
const mysql = require('mysql');
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});
connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to MySQL database');
});

javascript
connection.query('SELECT * FROM users', (err, rows) => {
  if (err) throw err;
  
  console.log('Users:');
  rows.forEach((row) => {
    console.log(row.name);
  });
});

javascript
const user = { name: 'John', email: 'john@example.com' };
connection.query('INSERT INTO users SET ?', user, (err, result) => {
  if (err) throw err;
  console.log('Inserted new user with ID:', result.insertId);
});

javascript
const userId = 1;
const newName = 'Jane';
connection.query('UPDATE users SET name = ? WHERE id = ?', [newName, userId], (err, result) => {
  if (err) throw err;
  console.log('Updated', result.changedRows, 'rows');
});

javascript
const userId = 1;
connection.query('DELETE FROM users WHERE id = ?', userId, (err, result) => {
  if (err) throw err;
  console.log('Deleted', result.affectedRows, 'rows');
});

javascript
connection.end((err) => {
  if (err) throw err;
  console.log('Disconnected from MySQL database');
});