node mysql sequelize raw query code example

Example: sequelize query result

sequelize.query("UPDATE users SET y = 42 WHERE x = 12").spread(function(results,
  	metadata) {
  // Results will be an empty array and metadata will contain the number of 
  // affected rows.
})

/* In cases where you don't need to access the metadata you can pass in a query 
type to tell sequelize how to format the results. For example, for a simple 
select query you could do: */

sequelize.query("SELECT * FROM `users`", { type: sequelize.QueryTypes.SELECT})
  .then(function(users) {
    // We don't need spread here, since only the results will be returned for 
    // select queries
  })