title: MySQL error code: 1175 during UPDATE (MySQL-Workbench vs. console)
body: <p>Am very aware of that this issue can be resolved with disabling safe update mode enabled (e.g. see here: <a href="https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench">MySQL error code: 1175 during UPDATE in MySQL Workbench</a>). However, I do not wish to disable safe update mode (and there are many many solutions that propose this).</p>
  
  <p>Similarly, I am aware that setting the WHERE clause to KEY-value that matches everything is supposed to work. However, doesn't appear to work on mysql-workbench - at least not the way I hoped (or the way it did work on the console).</p>
  
  <p>For example, the following didn't work on mysql-workbench (but did on the console):</p>
  
  <pre><code>UPDATE FUEL_SOURCES AS FS
  INNER JOIN
      FUEL_CATEGORY FC ON FC.FUEL_CATEGORY = FS.FUEL_CATEGORY 
  SET 
      FS.FUEL_CATEGORY_ID = FC.ID
  WHERE
      FC.ID &lt;&gt; 0 AND FS.ID &lt;&gt; 0
  </code></pre>
  
  <p>...If I explicitly / exactly set the ID's (e.g.  <code>WHERE FC.ID = 20 AND FS.ID &lt;&gt; 10</code> for example) it would work in mysql-workbench. But doing this would involve iterating through every key-pair combination. </p>
  
  <p>Be intereted to know what is causing this behaviour, or if I am doing something horribly wrong. Using mysql-workbench 6.3</p>