js脚本导入sql

npm install mysql fs

const mysql = require('mysql');
const fs = require('fs');

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

// 连接数据库
connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to the database!');

  // 读取SQL文件
  fs.readFile('path/to/your/file.sql', 'utf8', (err, data) => {
    if (err) throw err;

    // 分割SQL语句并执行
    const sqlStatements = data.split(';').map(statement => statement.trim()).filter(statement => statement.length > 0);
    let query = '';

    connection.query(query, (err, results) => {
      if (err) throw err;
      console.log('SQL file imported successfully!');
      connection.end();
    });

    sqlStatements.forEach(statement => {
      query += statement + ';';
      connection.query(query, (err, results) => {
        if (err) throw err;
      });
    });
  });
});

node importSQL.js