How can I execute SQL queries in Node.js?

How can I execute SQL queries in Node.js?

You can use libraries like mysql or pg for PostgreSQL to execute SQL queries in Node.js. Do you have a specific database in mind?

I'm using MySQL. Can you show me a simple example?

Sure! First, install the mysql package using npm. Then, you can connect to your database and execute a query like this:

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 SQL 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);
});