async function insertData() {
const data = {name: 'John', age: 30};
const sql = `INSERT INTO users SET ?`;
try {
const result = await pool.query(sql, data);
console.log(result.insertId);
} catch (err) {
console.log(err);
}
}
const mysql = require('mysql2/promise');
const pool = mysql.createPool({
host: 'localhost',
user: 'root',
password: '',
database: 'database_name'
});
async function insertData() {
const data = {name: 'John', age: 30};
const sql = `INSERT INTO users SET ?`;
const connection = await pool.getConnection();
try {
await connection.query(sql, data);
console.log('数据插入成功');
} catch (err) {
console.log(err);
} finally {
connection.release();
}
}
insertData();
使用异步/等待 SQL 插入可使程序更加可读、简洁和易于维护。