title: Query failed with the following: (Error #1366) Incorrect integer value: '' for column; how to set version compatibility
body: <p>Here is my <em>current</em> version of MySQL:</p>
  
  <pre><code>mysql  Ver 14.14 Distrib 5.7.18, for Linux (x86_64) using  EditLine wrapper
  </code></pre>
  
  <p>Here is the previous version:</p>
  
  <pre><code>mysql  Ver 14.14 Distrib 5.5.47, for Linux (x86_64) using readline 5.1
  </code></pre>
  
  <p>The query (abbereviated) that I'm trying to run is:</p>
  
  <pre><code>INSERT INTO bais_logs SET editor_id = '', type = 'basic'; -- no editor
  </code></pre>
  
  <p>And I get the error specified.  <code>editor_id</code> is a <code>INT(10) UNSIGNED NOT NULL</code></p>
  
  <p>It worked in the previous version, and it will be difficult and time-consuming to update the related queries.  Is there any way to set compatibility with the MySQL 5.5 server so that this would just ignore the <code>''</code> and proceed?</p>