How can I run multiple raw queries with sequelize in MySql?
Depending on the underlying mysql module being used, at least mysql
/mysql2
supports the multipleStatements: true
connection setting. This will allow you to send multiple queries at once. By default it is disabled for security reasons.
You can pass the multipleStatements
option using
new Sequelize(user, pass, db, {
dialectOptions: {
multipleStatements: true
}
});
Anything you put into dialectOptions
will be passed on to the underlying connection lib (in this case mysql
)