js快速填充数据库

const mysql = require('mysql');

// 创建数据库连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

connection.connect();

// 要插入的数据
const data = [
  { name: 'Alice', age: 25 },
  { name: 'Bob', age: 30 },
  { name: 'Charlie', age: 35 }
];

// 构建SQL语句
let sql = 'INSERT INTO users (name, age) VALUES ?';
let values = data.map(item => [item.name, item.age]);

// 执行插入操作
connection.query(sql, [values], (error, results, fields) => {
  if (error) throw error;
  console.log('Data inserted successfully:', results);
});

// 关闭数据库连接
connection.end();