title: MySQL error code: 1175 during UPDATE in MySQL Workbench
body: <p>I'm trying to update the column <code>visited</code> to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command:</p>
  
  <pre><code>UPDATE tablename SET columnname=1;
  </code></pre>
  
  <p>It gives me the following error:</p>
  
  <blockquote>
    <p>You are using safe update mode and you tried to update a table without
    a WHERE that uses a KEY column To disable safe mode, toggle the option
    ....</p>
  </blockquote>
  
  <p>I followed the instructions, and I unchecked the <code>safe update</code> option from the <code>Edit</code> menu then <code>Preferences</code> then <code>SQL Editor</code>. The same error still appear &amp; I'm not able to update this value. Please, tell me what is wrong?</p>