What are some examples of MySQL queries in Node.js?

Can you show me some examples of MySQL queries using Node.js?

Sure! Here are a few examples of MySQL queries in Node.js using the mysql package.

What about a simple SELECT query?

You can use the following code:

const mysql = require('mysql');
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydb'
});

connection.connect();

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

connection.end();

How do I insert data into a table?

You can insert data using the following code:

const sql = 'INSERT INTO users (name, age) VALUES (?, ?)';
const values = ['John Doe', 30];

connection.query(sql, values, (error, results) => {
  if (error) throw error;
  console.log('Inserted ID:', results.insertId);
});