在mysql中从node.js创建存储过程

const mysql = require('mysql');

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

// 连接数据库
connection.connect();

// 创建存储过程
const createProcedure = `
  CREATE PROCEDURE get_users()
  BEGIN
    SELECT * FROM users;
  END
`;

connection.query(createProcedure, (error, results, fields) => {
  if (error) throw error;
  console.log('存储过程已创建');
});

// 调用存储过程
connection.query('CALL get_users()', (error, results, fields) => {
  if (error) throw error;
  console.log(results);
});

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