title: MySQL - problems updating a table
body: <p>I have a table which I want to update with values from another table, and  I am using the following code:</p>
  
  <pre><code>UPDATE TableA
  SET Value = (
      SELECT TableB.Value2
      FROM TableB
      WHERE TableA.id=TableB.ta_id
  );
  </code></pre>
  
  <p>Despite the fact that TableA.id is the primary key of tableA, I keep getting the following error:</p>
  
  <p>Error Code: 1175. 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 in Preferences -> SQL Editor and reconnect.</p>
  
  <p>What am I doing wrong?</p>