title: Update table in mysql using stored procedure
body: <p>I have stored procedure in mysql. The procedure is created, but when the procedure is called I get an error: </p>
  
  <blockquote>
    <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 -> Query Editor
    and reconnect."</p>
  </blockquote>
  
  <p>Here is the procedure:</p>
  
  <pre><code>------------------------------------------------
  drop procedure if exists update_per_det;
  
  delimiter //
  
  create procedure update_per_det(IN name varchar(30))
  
  begin
  
   DECLARE age1 int;
  
  set age1=(select CalAge(name));
  
  update  per_det set age=age1 where username=name;
  
  end;//
  
  delimiter ;
  </code></pre>
  
  <p>How can I solve this issue?</p>