mysql nodejs 中的 IN 子句

MySQL和Node.js中的IN子句

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);

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 the MySQL server.');
});

javascript
const ages = [18, 20, 25];
const sql = `SELECT * FROM users WHERE age IN (?)`;
connection.query(sql, [ages], (err, result) => {
  if (err) throw err;
  console.log(result);
});
connection.end();