title: How to disable only_full_group_by in MySQL or Sequelize
body: <p>In Sequelize, how would I do the equivalent of <code>SET sql_mode=''</code> to avoid getting the following error?</p>
  
  <blockquote>
    <p><code>SequelizeDatabaseError: ER_WRONG_FIELD_WITH_GROUP: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'assets.group_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by</code></p>
  </blockquote>
  
  <p>Or, alternatively, how do I change the default configuration of MySQL such that the <code>sql_mode</code> is always <code>''</code>?</p>
  
  <p>Thanks!</p>