How can I use SQL in my Node.js application?

How can I use SQL in my Node.js application?

You can use SQL in Node.js by utilizing libraries like mysql, pg for PostgreSQL, or sequelize for ORM. Which database are you planning to use?

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

Sure! First, install the mysql package using npm. Then, you can create a connection and run queries 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 statement in a similar way. 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);
});