How do I perform MySQL queries in Node.js?

How do I perform MySQL queries in Node.js?

You can use the 'mysql' package in Node.js to connect to a MySQL database and perform queries. Would you like a code example?

Yes, please provide a simple example of a SELECT query.

Sure! Here's a basic example:

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'yourUsername',
  password: 'yourPassword',
  database: 'yourDatabase'
});

connection.connect();

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

connection.end();

What if I want to insert data into the database?

You can use the INSERT INTO statement. Here's an example:

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

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